Export data to several excell sheets at will
So I have this new project where I'm required to create a billing report in C.R. 10 and export the results in Excel. The catch is the sample excel results I've been given spans serveral worksheets for drill down purposes(all w/in the same workbook).
I've read that if report row results are greater than say 65,000 (or something close) the exported excel results will continue to a new worksheet. That's swell. But, does anyone know of a way to force C.R. to use a new sheet after say, 30 (or X number of rows) results?
Thanks in advance,