Load Report Failed error sporadically shows up

Hi all,

I have written an asp.net web site (CR2008 sp2.5, .net3.5, VS2008, vb.net running on winServ2003 hitting an Oracle 10g database) that does nothing but dish out reports for users. I built in the asp.net member/role security, which works fine, and different sections have a "frmReportViewer.aspx" file that has a crystal report viewer control in it.

Based on a querystring parameter, the report will load the correct rpt to the control on the page.

here's the problem.: sometimes when loading a report, it instantly comes back with "LOAD REPORT FAILED". Sometimes, you can close the window, click the link again, and it will work fine. Sometimes, if the report does load, then if i try to drill down into a group, it will tell me "no valid report source is available" in a little ajax-style dialog box in the report.

My main question is....why does this work sometimes? this instability will make this project go down the tubes (along with my job perhaps)....I showed my company what CAN be done, now i need to make it RUN LIKE IT SHOULD!

THANKS IN ADVANCE!

GEORGE

Edited by: george hardy on Mar 25, 2010 7:58 PM