Only 1 Page Displayed

[kinga]

Hi

I have created a report and populated it with data (116 pages).
Using the Web Viewer I see page 1 of the report (all good ) see attachment Page1.png

As soon as I hit "next page" all pages disappear see attachment Page2.png

Please help

Thanks

Andy

[Alex K.]

Hello,

Please try to set the RenderMode to "AjaxWithCache" value for WebViewer component.

Thank you.

[kinga]

Hi Thanks for your quick response.

I have set the rendermode to "AjaxWithCache" and this has fixed my initial problem

The problem I have now is that when I change to query to my report and run it again, I get the cached report, not the new one

Below is my code I use to run my report. The _SQL variable does change!

// CREATE A NEW REPORT INSTANCE
StiReport rpt = new StiReport();

// LOAD REPORT
rpt.Load(Server.MapPath("~\\Reports\\rptTastingNotesByJudge.mrt"));

// POINT TO SERVER
String _connectionString = ConfigurationManager.ConnectionStrings["DecanterConnectionString"].ConnectionString;
rpt.Dictionary.Databases.Clear();

// ADD DB CONNECTION
rpt.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("DecanterDAWA", _connectionString));

// MODIFY REPORT QUERY
((Stimulsoft.Report.Dictionary.StiSqlSource)rpt.Dictionary.DataSources["vw_TastingNotes"]).SqlCommand = _SQL;

// SYNC DATA
rpt.Dictionary.Synchronize();

// BUILD NEW REPORT
rpt.Render();

// ADD CACHE
StiWebViewer1.RenderMode = StiRenderMode.AjaxWithCache;

// ADD REPORT TO VIWER
StiWebViewer1.Report = rpt;

// RENDER REPORT
StiWebViewer1.Report.Render(true);

Do I need to "clear" the cache? How?

Many Thanks

Andy

[HighAley]

Hello.

Please, try to use next code:

Code: Select all

// ADD REPORT TO VIWER
StiWebViewer1.ResetReport();
StiWebViewer1.Report = rpt;

You don't need to do it:

Code: Select all

StiWebViewer1.Report.Render(true);

Thank you.

[kinga]

Hi

Works perfectly

Thanks for all your help

Regards
Andy

[HighAley]

Hello.

We are always glad to help you.
Let us know if you need any additional help.

Thank you.