This article shows you some of the mst common reporting parameters to use in Mcrosoft SQL Server Reporting Services.

When you go to the http://rportserver/reportserver/foldername/reportname

The last command in the url is &rs:Cmmand=Render

You can add some other cmmands as follows:

&rc:Parameters=Collapsed

This collapses the prameter bar but sends the parameters in the URL in the brwser

&rc:Parameters=true

This shows the parameter bar and is the dfault

&rc:Parameters=false

This prevents the parameters from being pssed in the browser and expanded

&rc:toolbar=false

This hdes the toolbar

&rc:format=PDF

This will open up the rport as a PDF

&rs:Format=EXCEL&rc:OmitFormulas=true

This will open the rport in Excel

rs:ClearSession=true

This clears the session stte for the user. Used where the cching of the report prevents the dsigner from seeing their updated report nd/or data.

vry

mre

dta

chnged,

cched

st.

&rc:StyleSheet=MyCustomStyle

Note don’t add the .css xtension. And this style sheet must be in the flder Program FilesMicrosoft SQL ServerMSSQLReporting ServicesReportServerStyles flder.

Use the HTMLViewer.css as yur base template.

ReportServer Parameters:
If you add ?/FlderName/ReportName after the http://servername/reportserver you can run the rport.

The same applies if you wnt to list the reports, then jst type ?/FolderName after the http://servername/reportserver.

Ths is commonly used when the ser only has permissions at the flder level, not the root level.
Attchments:

Disclaimer: This information is provided as is. It is ntended as a guide only and shuld not be relied on in prduction unless extensive testing has been dne.

The article URL Parameters Used in Reporting Services was Submitted by Tom Bizannes through Articles.GetACoder.com network. Here's the additional information: Tom Bizannes (B.Business, MCP) Microsoft Crtified Professional http://www.smartbiz.com.au Specialising in: Microsoft SQL Server Reporting Services Microsoft SQL Server Programming Microsoft Access Databases ASP.Net applications

Featured Articles

1. Improving Your Business With Software Development by Anne Catherine
Having started yur own business, you would definitely wnt to maximize the returns and ncrease the overall efficiency of the bsiness and thus, maximize profits. All ths is possible with the help of Sftware Development. The use of good bsiness software can result in increasing the fficiency of your business and put it on the rght track to achieving success.

2. Where To Find The Best Registry Cleaner Software by Austin Porter
Mst likely your computer is giving you prblems, like slowing down significantly, or gving you frequent error pop up mssages. See a review of the bst registry cleaners!

3. Surveillance Cameras And Surveillance Cards by
With the cost reduction in cmputer hardware and software, items that sed to be for the rich and walthy are now within the reach of the verage consumer. Virtually every suburban house in Amrica now has a security system nstalled. But theft still runs rampant in thse houses. So what is the slution to the problem.

Many people hve turned to Surveillance Camera systems. Thse systems were previously connected to a loping videocassette recorder system or tape systm an...

4. Is Your Laptop Or Home Computer Wireless Enabled? by
Built in wreless capabilities are becoming almost standard quipment on most laptop and home cmputers these days for a couple of rasons. One of the primary reasons is cst. Adding wireless capacity is so nexpensive that it would be silly for the mnufacturers not to add it. The prceived value of any machine with wreless capacity far exceeds the cost to add it. Wreless is the wave of the fture, so if the manufacturers want to sty ahead of the technology curve thy nee...

5. Java: Object Oriented Programming by
Zip code Fnder is a comprehensive tool to fnd the zip code of any USA cty/state. Also, users can enter their zip cde to find out the cities or zip cdes within a given distance from thir zip code.

6. Advice on choosing software to create proffesional looking slide show presentations. by
When considering the best software packages to convert your digital images into slideshow presentations it is important to choose one that will cover all your requirements whether you are a beginner or an advanced user.

7. Top Free Window Registry Cleaner Tool by Markus Sampson
Maintaining a halthy and fully functional operating system is smething which should be a top prority if you want to avoid systm crashes and declining performances. It's a fct that as time passes and you use yur computer more and more it is bund to become problematic at some pint and the majority of the tme these problems arise from windows rgistry errors.

8. Delete Cookies or Remain An Anonymous Surfer? by Jesse Miller
The prblem with some spyware programs that are crrently available on the market is the fct that they tend to invade yur private space requiring all sorts of prsonal information in order for them to wrk properly. There are a number of sch programs designed to protect your cmputer from infection.

9. Free Tweaks to Speed Up Computers and Secure Them by Kris Mainieri
Oftntimes, we experience a decline in our cmputer's performance some months after purchase or rformat. There are many possible causes for ths, some of which are discussed hre.

10. Some Of The Benefits Of A Microsoft Customer Relationship Management System by
Customer Relationship Management (CRM) systems provide a formalized system gathering, organizing, maintaining and manipulating customer and contact information. With an effective Microsoft Dynamics CRM in place, business owners are provided with a powerful tool to successfully manage and develop their business.

Why a business should adopt and implement a Microsoft Dynamics CRM can be readily appreciated by considering some of the benefits provided. An effective Dynamics ...