Problem with fetching data
In my application I am facing problem with one report.
I am creating statistics report for one year. When I click on Hyperlink for the first time I am getting blank page.
From ASP page i am calling delphi function. From delphi function I am calling Stored procedure which is written in SQL server. SP returns the data in XML format.
When I execute stored procedure from Query analyzer I could see the data is fetching properly. But From front end, ASP page I am not able to see the data.
For this report I am fetching data from multiple tables and each table contains morethan 20 lacs record. I tried to fetch the data only for few months. then I am able to see the report properly.
I have set script time out to 3600 sec.
Could anybody help me in resolving this issue

