Parametarize Reports

I am new to reporting service but i see all the tutorial that just show how to create static reports. But I want something like I put some combo box and when i select particaul option it should show such reports

milindsaraswala

Firstly if you can get your hands on the Reporting Services Book Online, you will find some very useful information.

There are a number of ways to add a parameter the easiest way for me is to add some criteria to your query, for eg,

Change it from

SELECT * FROM table1

to

SELECT * FROM table1 WHERE name = @.Parameter1

When you look at the report parameters option in your layout tab you will now see Parameter1 as a parameter for the report, in this view you can set things like prompt, where nulls/blanks are allowed. It is here that you can select the values for the paramter be based on a query, which when you go to your preview tab will display the parameter now as a combo box.

HTH

Page reloaded automatically and rapidly

Hi,

I'm new to the reporting service. I followed the tutorial from the online book and created the basic report. After I deployed the report and opened it in the browser, it kept reloading the page automatically. Seems to me the page is reloaded at least 5 times per second. I turned off the Autorefresh for the report. It still behaves the same. That causes the CPU of my computer runs on 100% constantly. Can anyone help me to solve the problem?

Thanks,

Jia

Jia,

One way to get a report to refresh is the 'Autorefresh' property (Report Properties, General Tab, Autorefresh checkbox). You've already verified that that checkbox is unchecked (this is a design time property).

A report can also be refreshed based on the Report Server's caching property. To change this setting, you can use the Report Manager. Make sure that you've got the following radio buttons selected and no others (available when you deploy to the report manager, run the report, select the Properties tab, and the Execution page):

Always run this report with the most recent data|||

Hi Tnx1m,

I did as what you said. Unfortunately they didn't work.

After the first page is loaded, the page starts to *flash*. I use SQL Profiler to check on the backend. There is no query sent to the database. It looks like the page is in an infinite loop to be refreshed but not sending any commands to the database. Any idea why it is like that?

Thanks,

Jia

|||

Hi Hia,

seems like you are running IE 7 Beta 3 :-) Look here for more information about this: http://sqlserver2005.de/SQLServer2005/MyBlog/tabid/56/EntryID/10/Default.aspx

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Hi Jen,

That's exactly where the problem comes from. Thanks so much!

Jia