?
Solved

SQL Reporting services

Posted on 2006-07-06
1
Medium Priority
?
765 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 2000 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Loops Section Overview
Suggested Courses

839 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