Excel generation

Stimulsoft Reports.NET discussion
Post Reply
kpriya
Posts: 2
Joined: Wed Jun 04, 2014 11:53 am

Excel generation

Post by kpriya »

Hi,

I use stimulsoft API for .NET.

What is the property settings in the designer to generate an Excel with each worksheet having upto 10000 rows?
We set unlimited height = true, but for every group each excel worksheet seems to accomodate only 80 rows or so and then the page breaks into a new worksheet.

What should be the settings for excel to generate 10000 rows per worksheet when we group by an attribute?
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Excel generation

Post by Alex K. »

Hello,

Please send us your report with test data for analysis.

Thank you.
kpriya
Posts: 2
Joined: Wed Jun 04, 2014 11:53 am

Re: Excel generation

Post by kpriya »

Hi,

Attached Excel is what is generated. I expect all Summary worksheets until Summary-50 to be generated in the same worksheet as it is grouped by the term - COST CENTER.

At Summary-51, it groups correctly into the next attribute, but again beyond it , I expect the summary sheets to be in the same worksheet for each group.

What should be my settings ? Pls help ASAP as this is urgent.
Attachments
New20K0000000020.xls
(1.64 MiB) Downloaded 115 times
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Excel generation

Post by HighAley »

Hello.

Could you specify which version of our assemblies do you use?
How do you export report? What settings do you use?
Could you send us the report template that you use?

Thank you.
Post Reply