NinaWilliam
Member
- Joined
- Jul 13, 2008
- Messages
- 18
- Programming Experience
- 3-5
Hi there,
ASP.NET 1.1 / VB.NET / SQL 2000
I am generation report using crystal reports 10... the report is working fine but the problem that it is taking too long to load and display the data.
what I am doing is: I have two tables (one to many). I am getting all records from the first table and storing it in a table in my dataset... then I am getting all records from the second table depending on the ID from the first table. then storing it in another table in the dataset.
after that, I merge both tables in dataset by doing for each loop to merge each record to its related id.
Finally, bind it to the report
The merging process takes 2 minutes!!
What can I do? is there a better way to do the same thing?
can I control the range of records in my SQL statement?
Please help me
ASP.NET 1.1 / VB.NET / SQL 2000
I am generation report using crystal reports 10... the report is working fine but the problem that it is taking too long to load and display the data.
what I am doing is: I have two tables (one to many). I am getting all records from the first table and storing it in a table in my dataset... then I am getting all records from the second table depending on the ID from the first table. then storing it in another table in the dataset.
after that, I merge both tables in dataset by doing for each loop to merge each record to its related id.
Finally, bind it to the report
The merging process takes 2 minutes!!
What can I do? is there a better way to do the same thing?
can I control the range of records in my SQL statement?
Please help me
