I have a report based on chart of accounts that involve hierarchical grouping and summary.

 

The problem is that sometimes the report works fine and at other times it generates a lot of blank pages which contain either partial data or no data.

 

For example my report generates 20 pages of data while working normally. But the same report generates 1700 pages with the same data and same filter conditions.

 

the actuall content is same. but i got a lot of blank pages inbetween.

 

i use a condition to hide hierarchical grouping section and detail section as follow :

 

accgrpflag="A"

 

i also would like to tell that whether the report works normally or abnormally the contents of the reports are same. the only difference is the number of pages which mostly consists of blank pages.

 

I use Oracle as back end and asp.net2.o & csharp.

 

This problem occurs mostly during peak hours.

 

Please help

 

Thanks & Regards.