Solved

SQL Reporting services

Posted on 2006-07-06
1
713 Views
Last Modified: 2012-05-05
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
1 Comment
 
LVL 9

Accepted Solution

by:
gdupadhyay earned 500 total points
ID: 17088289
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.

Note : This answer is same as ur previous question

Thanks,
Ganesh Dutt Upadhyay
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
This video discusses moving either the default database or any database to a new volume.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

760 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now