I can't view other prepared pages in webreport

ccihan

hi everyone.
I save my prepared reports in database . load from database and Show report if clients want to view report.
I have webReport as WebReport1 in my page.

my report load function is here. but only 1 page is Showing. but if export report to pdf, I can view all pages.

using (SqlConnection DBcon = new SqlConnection..
{
MemoryStream ms;

DBcon.Open();
using (SqlCommand cmd = new SqlCommand("Select REPORT from REPORTDB where IDX=41", DBcon))
{
var varArray = (Byte[])cmd.ExecuteScalar();
ms = new MemoryStream(varArray);
WebReport1.Report.LoadPrepared(ms);
WebReport1.ReportDone = true;
}

ccihan

I found solution.

DBcon.Open();
using (SqlCommand cmd = new SqlCommand("Select RPT from TEMPRPT where IDX=@IDX";, DBcon))
{
cmd.Parameters.Add("@IDX";, SqlDbType.Int).Value = IDX;
var varArray = (Byte[])cmd.ExecuteScalar();
ms = new MemoryStream(varArray);
WebReport1.CurrentTab.Report.LoadPrepared(ms);
WebReport1.ReportDone = true;