Crystal Report Viewer Problem..?

Question

0.00/5 (No votes)

See more:

I have created a Project in ASP.NET using C# as Back End.
In my project i have use crystal report to show reports to user.

I have dynamic report like when user select 1 report then the Crystal Report Viewer Show the First Report or it select second then the crystal report viewer show the second report.
and i have also pass the parameter value to my report by seting crystal report viewers paramterfiledinfo property.

now i have done it and it will work great. but my problem is arise when i have more then one page data in report and i went to second page it will show error like this..

"No valid report source is available"

please help me...

Posted 1-Nov-11 3:06am

Tejas Vaishnav

Add a Solution

Comments

Artashes Tovmasyan 23-Jun-16 3:20am

Hi :) I'm having the same problem
Did you solve the paging problem ??

Thanks in advance

Tejas Vaishnav 29-Jun-16 1:34am

Can you check answers listed below, may solve your problem.

2 solutions

Solution 1

I think you need to bind the data to the report every time the Report viewer page postback, as following:

C#

CrystalDecisions.CrystalReports.Engine.ReportDocument rpt;

protected void Page_Load(object sender, EventArgs e)
    {
        rpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
            rpt.Load(Server.MapPath(GetFilePath(/*report file path*/)));
            if (rptData is DataSet)
                rpt.SetDataSource((DataSet)rptData);
            else if (rptData is DataTable)
                rpt.SetDataSource((DataTable)rptData);
            else if (rptData is IEnumerable)
                rpt.SetDataSource((IEnumerable)rptData);

            CrystalReportViewer1.ReportSource = rpt;
            CrystalReportViewer1.DataBind();
    }

and close the report every time the page unload, as following:

C#

protected void Page_UnLoad(object sender, EventArgs e)
    {
        if (rpt != null)
        {
            rpt.Close();
            rpt.Dispose();
        }
    }

Posted 1-Nov-11 3:28am

greatayman

Comments

cutest 17-Apr-16 4:38am

crystal report is useless

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Tejas Vaishnav · Accepted Answer · 2011-11-03T02:07:00

Fro solving this issue i need to do like this....

after assinig a report to report viwer i will add it to session also displaying report and also call this function in side OnNavigate or OnViewZoom etc.... events of report viewer

C#

protected void setReportSource(object sender, EventArgs e)
{
   if (Session["Report"] != null)
   {
       if (Session["Parameter"] != null)
       {
            CRPTViewer.ParameterFieldInfo = (ParameterFields)Session["Parameter"];
       }
       CRPTViewer.ReportSource = (ReportDocument)Session["Report"];
   }
}

Crystal Report Viewer Problem..?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Crystal Report Viewer Problem..?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us