This is a migrated thread and some comments may be shown as answers.

Reports failed when sessionState mode="SQLServer"

3 Answers 149 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
FISCAL
Top achievements
Rank 1
FISCAL asked on 12 Oct 2010, 08:43 AM
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

 

3 Answers, 1 is accepted

Sort by
0
Peter
Telerik team
answered on 15 Oct 2010, 09:54 AM
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
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
0
FISCAL
Top achievements
Rank 1
answered on 15 Oct 2010, 10:05 AM
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

0
Peter
Telerik team
answered on 19 Oct 2010, 04:12 PM
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
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
Tags
General Discussions
Asked by
FISCAL
Top achievements
Rank 1
Answers by
Peter
Telerik team
FISCAL
Top achievements
Rank 1
Share this question
or