Calling Crystal Report having stored procedure in ASP.NET

[bharatasp]

Hi All,

I m designing a few reports which fetch data from stored procedures.

When I create reports using Report Designer interface provided by VS.NET, I am able to do so but when i create a report using Crystal Report 9 Designer, it throws an unhandelled exception :

 

Exception: Exception of type System.Exception was thrown.]

CrystalDecisions.Web.ReportAgent.v(Boolean �`) +345

CrystalDecisions.Web.CrystalReportViewer.OnPreRender(EventArgs e) +108

System.Web.UI.Control.PreRenderRecursiveInternal() +62

System.Web.UI.Control.PreRenderRecursiveInternal() +125

System.Web.UI.Control.PreRenderRecursiveInternal() +125

System.Web.UI.Page.ProcessRequestMain() +1470

 

 

I can design the reports in VS interface too but it will take hell lot of time as it doesnt have most of the features which are there in Crystal Reports interface.

 

Has anyone came across the same problem?

Please try to help me out !!!

 

Thanks in advance.

 

« bharat »

[Robby]

While using the Crystal Reports interface, are able to get data from the Stored Proc? Or is that where it errors out?

[bharatasp]

I get the data from Stored procedure and can preview the report in CR Interface. But problem is when i include that report in project (by clicking "Include in project"), it throws that exception

one thing more, when i create parameters and make a mistake while adding parameter, it gives me error message.

 

that means it creates parameters but while showing the report , it gives me that error.

I m able to include and show reports, based on views but problem occurs only in case of Stored procedures.

Seems a weird problem!!

 

Can this be a bug in the Web Control?

[Robby]

Hmm, this sounds weird. I checked it out at Crystal and it seems like your not the only one, here are a few search results there, many of them have no replies. :( http://support.crystaldecisions.com/forums/search/search_results.asp?search_text=CrystalDecisions%2EWeb%2EReportAgent&pagenumber=1&ps=100&sortby=&searchkey=0&forumid=1&forumid=5&forumid=9&forumid=7&forumid=70&forumid=72&forumid=74&forumid=76&forumid=78&forumid=80&forumid=69&forumid=71&forumid=77&forumid=320&forumid=321&forumid=341&forumid=82&forumid=251&forumid=254&forumid=256&forumid=258&forumid=260&forumid=255&forumid=257&forumid=259&forumid=261&forumid=312&forumid=382&forumid=385&forumid=386&forumid=383&forumid=384&forumid=309&forumid=310&forumid=311&forumid=342&forumid=343&forumid=344&forumid=87&search_attachments=