"Error in File < Path..>\ASPNET\LOCALS~1\Temp\Employees {BBE0A87A-CFF9-4682-A6AD-B0E256CF4793}.rpt:" Crystal Report error in ASP.Net 2.0

Did you ever encounter with this error saying
"Error in File C:\DOCUME~1\..\ASPNET\LOCALS~1\Temp\Employees {BBE0A87A-CFF9-4682-A6AD-B0E256CF4793}.rpt: Get page number for group failed" while working with Crystal Report in ASP.Net 2.0 ?

This error will occur when you try a postback in the .net page by a tree node click or so. And the reason behind is while postback, report is not able to find the data.

Resolution
To avoid this error, enable the caching by making the prOperty of CrystalReportSource "Enable Caching = true".

HTH
-::-

How do we generate XSD in VS.Net for reporting from a stored procedure containing #temp tables (local) ?

In many scenarios we may have to use local temp tables in procedures instead of functions returning tables. Always, temp tables are best in performance. When there is any temp table involved in an sp, say for reporting, VS.Net will not allow you to generate a typed dataset (.xsd) out of that.

Resolution

1. Comment the lines containting temp tables in sp
2. Generate .xsd file in .net IDE
3. Uncomment the comments

Yeah!!! It worked

-::-

Crystal Report prompts for report parameters in VS.Net 2005 after being upgraded (VS.Net 2003)

I got parameter prompts when i run my windows application after upgrading to framework 2.0. The application was built on .net 1.1 and was running successfully

Resolution

Pass the parameter after binding the report document to the report viewer component as below. (I passed it before binding to CRV component in .net 2003)

rptDoc.SetDataSource(ds.Tables[0]);
crv.ReportSource = rptDoc;
rptDoc.SetParameterValue("BRAND", Application.ProductName);

-::-