Caching SQL Results for Fast Report Export

Hi Team,

We are currently using fast report in .NET 3.1.

The situation is when we are generating a report it generates SQL query and fetched records and rendered in application as preview. Again while trying to export the report as pdf or excel ,the same query is executing from the first step and generating the same result and finally its exporting.

Generally Caching technique is preferred for small memory consuming data, Are any other technique can be used to overcome the above situation?

It would be great help if any thoughts or hits received

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.