?
Solved

rs:ClearSession =true

Posted on 2010-11-17
5
Medium Priority
?
1,838 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 2000 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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

Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…

719 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