Solved

rs:ClearSession =true

Posted on 2010-11-17
5
1,746 Views
Last Modified: 2012-05-10
I would like to use the following property rs:ClearSession =true  as discussed on

http://msdn.microsoft.com/en-us/library/ms153610(v=SQL.90).aspx

I don't know where to go to change the setting? Is it somewhere in BIDS?
0
Comment
Question by:Mr_Shaw
  • 3
  • 2
5 Comments
 
LVL 10

Expert Comment

by:itcouple
ID: 34154484
Hi

You add it to the end of your report link.

I will post examples in a minute.

Regards
Emil
0
 
LVL 10

Expert Comment

by:itcouple
ID: 34154513
Go to Reportserver (usually link below)

http://ServerName/ReportServer

Find your report and click it and the end of the reprot add &rs:ClearSession=true

eg.:
http://servername/ReportServer/Pages/ReportViewer.aspx?%2fFolderName%2fSubForlder%2fReportName&rs:Command=Render&rs:ClearSession=true

Hope that helps
Emil
0
 

Author Comment

by:Mr_Shaw
ID: 34154527
How can I set the report up so that It always uses these properties.
0
 
LVL 10

Accepted Solution

by:
itcouple earned 500 total points
ID: 34154676
Hi

If you use reportmanager then I don't think there is option to do that using it but maybe there is something in config SSRS files, if that works you still need access to files on production and there are global settings so not everyone might like that.

If you jump to another report you might be able to use URL and add this option.

Hope that helps
Emil
0
 

Author Closing Comment

by:Mr_Shaw
ID: 34154733
thanks
0

Featured Post

[Webinar] Disaster Recovery and Cloud Management

Learn from Unigma and CloudBerry industry veterans which providers are best for certain use cases and how to lower cloud costs, how to grow your Managed Services practice in IaaS clouds, and how to utilize public cloud for Disaster Recovery

Question has a verified solution.

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

Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

863 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

22 Experts available now in Live!

Get 1:1 Help Now