SQL Server Reporting Service - Refresh Problem


Hi .
I am using SQL Reporting services for my Report.

I am using rs:clearsession=true for refreshing of report data from my page.i had passed
rs:clearsession parameter from aspx page to report URL, but when i am navigating from parent
report to child report then rs:clearsession is not appended.

so is there any way by which we can set some property in reporting service and we can get
the result of "rs:clearsession" variable in itself report.

===============================
rs:clearsession=true  // I am using it for fetching the updated data from DB

Thanks in advance,
LVL 10
SystemExpertAsked:
Who is Participating?
 
gdupadhyayConnect With a Mentor Commented:
Hi Systemexpert,
You can use Jump to URL option and call the report using javascripts like this,


="javascript:void(window.open('" &Globals!ReportServerUrl &"?"& Globals!ReportFolder & "%2fRPTMAS01&ORD=2" & "&RES_PRF_ID_R="& Fields!RPID.Value & "&FAC_ID_N=" & Fields!FACNO.Value & "&APPLN_ID_N=" & Fields!STMTID.Value & "&UserID=" & Parameters!USERID.Value & 
"&MapUrl=" & Parameters!MapUrl.Value &
"&rs:clearsession=true&rs%3aParameterLanguage=&rc%3aParameters=Collapsed" & "','_self'))",false)

In this way u can refresh the page using  "rs:clearsession=true" parameter with report.

Its not possible Jump to report and Jump to bookmark option.

I tested it and working fine.

Thanks,
Ganesh Dutt Upadhyay
0
 
gdupadhyayCommented:
Hi SystemExpert,
Is there any problems ? Please follow the above, i am sure u get the solution.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.