Hey all, this is my first post to this forum, hope someone has some advice.
I'm developing a
VB.NET application in which we embed some CrystalReportViewer controls to display some charts and reports. It works quite well on our dev machine, but as soon as we move to a test machine, the report has a hard coded location to find the .mdb database within the .rpt file and it doesnt load (with a terribly unhelpful "login error" type message, but thats for another day).
The only way i've found to get around this "officially" is to create a ADO.NET DataSet object with the same tables that i used in the report design phase and pass it off to the report viewer while loading everything up. This works fine, EXCEPT that its amazingly slow.
I have one complex 114 page report that takes about 4-5 seconds to display if crystal opens the .mdb file with its internal hardcoded path, but 20-30 seconds with the cpu hard pegged at 100% to open the same report if I hand the viewer a dataset.
Is there anything to be done? Is there another way to do this?
thanks so much!