Solved

rs:ClearSession =true

Posted on 2010-11-17
5
1,730 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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

747 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

13 Experts available now in Live!

Get 1:1 Help Now