Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Interactive SQL Reporting

Status
Not open for further replies.

JtheRipper

IS-IT--Management
Oct 4, 2002
274
GB
Hi there,

I am VERY new to reporting services, and started playing with it recently. I am also using the lessons on to learn about this product.

I have a few questions on reporting server functionality that I hope someone will be able to answer..

Is it possible to create an interactive report using SQL Reporting Services 2005?
Ex. I have a table in the SQL database with fields "snapdate" and "response_time".
Code:
SNAPDATE               RESPONSE TIME
10:00 10082006         0.5
10:05 10082006         0.5
10:10 10082006         0.6
10:15 10082006         0.3
10:20 10082006         0.9
10:25 10082006         1.5
...

I have created a line chart using the data from this table. The problem is that there will be data in this table for many days (records inserted every 5 minutes). Can I create a "parent" page for the report where the user will be given a drop down list or something with all the days he can select i.e.
"20060810"
"20060809"
"20060808"
.
.
and then pass that selected value to the SQL in the actual report with the chart? In other words, I only want to display the selected day's chart.

I have done something similar before using Coldfusion, but can this be done using SQL Server Reporting Services?

Any feedback will be greatly appreciated.

Thanks,
J.
 
certainly - no need for parent report - simply use a parameter. This can be filled with values by using a seperate (or the same) dataset that is populating the report. The parameter basically gets inserted into the WHERE clause of the SQL

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question
 
Hi,

Thanks for the feedback. Got my interactive report running eventually using parameters.

Cheers,
J.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top