Very Slow Report

[G.hammad]

Hello

I have two problem in my report :
1) first if i'm using simple cross tab report with 23386 row exactly for first run it take long time in registering the data in report
and in the next run it give me this exception : (An exception of type 'System.OutOfMemoryException' occurred in Stimulsoft.Report.dll but was not handled in user code) , for another report with 21966 row not give this exception at all i don't know what the difference!

2) second problem when i use report with some relations and enable cache all data property it take very very long time in rendering the report then i stop running the report before dispaly it ! what is the problem do u think?! and i'm using render mode = ajax with cache

[HighAley]

Hello.

1) first if i'm using simple cross tab report with 23386 row exactly for first run it take long time in registering the data in report
and in the next run it give me this exception : (An exception of type 'System.OutOfMemoryException' occurred in Stimulsoft.Report.dll but was not handled in user code) , for another report with 21966 row not give this exception at all i don't know what the difference!

The difference in in amount of memory that need for report. Please, read the The Out of Memory exception while rendering a report article from our Knowledge Base.

2) second problem when i use report with some relations and enable cache all data property it take very very long time in rendering the report then i stop running the report before dispaly it ! what is the problem do u think?! and i'm using render mode = ajax with cache

Please, send us a sample project with more detailed description of the problem. We need to analyze it before we give your any advice.

Thank you.

[G.hammad]

Hello

this sample project for used relation and cache all data it take time in register data if number of records more than 23,000 records
but the most important it take long long time in render as u can see in the sample

thank you

[HighAley]

Hello.

We need some additional time for analyzing of the issue.
We will let you know about results.

Thank you.

[G.hammad]

Hello Aleksey

good thats mean you see the problem
ok i'll wait your answer

thank you.

[HighAley]

Hello.

Could you specify what type of report do you need to generate.
If there is an only column then it's better to avoid using cross-tab and use the Data Band.

Thank you.

[G.hammad]

Hello Aleksey ,

no i want to use cross tab since it generate more than one column and my data register to report have more than one column for example
if i choose get all data i need for one month then i need 30 columns each column represent specific day and date of month so for that reason i used cross tab

[Alex K.]

Hello,

We are working on the issue. We will let you know about the result.

Thank you.

[G.hammad]

Hello ,

do you solve the problem ? or at least know what the problem ?! i need to solve this problem in my report as fast as i can

[Alex K.]

Hello,

We work hard on this problem and do our best to do it as fast as possible. We will let you know when the solution is available.

Thank you.