I have a .Net web site that is using Crystal Reports XI to render reports.
I have created a page called "ReportRouter.aspx" its construction is:
---ReportRouter.aspx holds the viewer
---ReportRouter.vb holds all the code to view any report that needs to be generated. We have "Parameter Pages" which have a "generate" button on them which then calls the ReporRouter.aspx to then view the report.
Now my problem is that when we view a report in the CrystalViewer1, the first page renders just fine, however when I click on the second page, it reruns the entire ReportRouter.vb code again just to get to the second page of the report.
This is not good as we have code to create temp tables which are used by the report and they keep getting recreated on ever "turn of the page"
Can someone tell me why this is happening?
I have used Crystal in VB before and I have never seen this behavior.