• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2705
  • Last Modified:

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,
  • 2
1 Solution
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.

Ganesh Dutt Upadhyay
Hi SystemExpert,
Is there any problems ? Please follow the above, i am sure u get the solution.
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.

Join & Write a Comment

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now