JtheRipper
IS-IT--Management
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".
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.
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.