Solved

SQL Server Reporting Service - Refresh Problem

Posted on 2006-07-06
2
2,689 Views
Last Modified: 2012-06-21

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,
0
Comment
Question by:SystemExpert
  • 2
2 Comments
 
LVL 9

Accepted Solution

by:
gdupadhyay earned 500 total points
ID: 17088281
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
 
LVL 9

Expert Comment

by:gdupadhyay
ID: 17097121
Hi SystemExpert,
Is there any problems ? Please follow the above, i am sure u get the solution.
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

713 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question