Reports failed when sessionState mode="SQLServer"

[FISCAL]

Hi,

Keeping in mind with the scalability we have decided to use SessionState mode to SQLServer.Unfortunately, telerik reports fail to display any data. The odd thing is it was working and it works when SessionState mode is "InProc".

As everyone knows, I have modified SessionState in web.config. Please advise me.

Many thanks.

MG

 

[Peter]

Hi M G,

Using Out Proc session requires some re-factoring of your project. Take into account that the report is processed in a separate request, thus this requires serialization of the report. Generally we serialize the report type, not the instance. Check out the Design Considerations for Out-Proc Session State help article that elaborates on the topic.

Sincerely yours,
Peter
the Telerik team

[FISCAL]

Hi Peter,

Thanks for your suggestion - my scenario is a bit weird one.

I have got  chart control embedded within Telerik reporting. Chart is drawn based on data from database and then to have the facility of exporting to different formats I am embedding into a report.

On Report classs,
I have a method call 

public void  DrawChart(int processID, dateTime? from, DateTime? to) 
    {
    ...... responsible for drawing chart.
    }
 
I am invoking this method from .aspx page where there is a reportViewer as below.

on button click event,
{
ReportClass rpt = new ReportClass();
rpt.DrawChart(100,from, to);
myReportViewer.Report = rpt;
}

As per the article "Design consideration for Out-Proc Session state", I should avoid calling DrawChart(..)!  I can't put everyting in the default constructor or ReportClass().

Any suggestion would be highly appreciated,

Thanks a lot.

MG

[Peter]

Hello M G,

You are correct - you must avoid the DrawChart method. Our suggestion is to move that code to the default report's constructor. You can use Report Parameters instead of the method parameters and custom logic to handle your scenario.

Regards,
Peter
the Telerik team