Build Timlenie Reports using SQL Server Reporting Services 2008 Report Builder 2.0 or VS Inteligent 2008


 Hi,
I have just started using SQL Server Reporting Services (SQL Server 2008). I've build my first reports in Report Builder 2.0 and in VS 2008.
I need to build reports with timelines. So I have to execute evry second (or minute) sql query to check and calculate the value.
Do you have an idea how to do this?
OR if you can send some links to a good tutorials :) I will apprisiate.
Thanks

Please Mark as Answer if it helps you in solving your problem.
0
aco_mk
3/19/2009 2:56:28 PM
📁 asp.net.ssrs
📃 4514 articles.
⭐ 1 followers.

💬 4 Replies
👁️‍🗨️ 1404 Views



Do you have the time data in your database  or u just have the start time and end time?
0
boban984
3/21/2009 10:39:17 PM

 If i have exsact time :) then building the report is really easy but I am am interested in solution if i only have start and end time?

Please Mark as Answer if it helps you in solving your problem.
0
aco_mk
3/21/2009 11:08:45 PM

Hi,
Based on my understandings, you want to view your data of the report according to the datetime. If so, please confirm whether the records have the datetime field. If the records don't have the datetime field themselves, we couldn't manage them via the datetime. So I suggest to add a datetime field, for example: add a column to record the time you inserting the data.
 
 
Please feel free to let me know if I’ve misunderstood anything.

Sincerely,
Zong-Qing Li
Microsoft Online Community Support
Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as
Answer” if a marked post does not actually answer your question.
0
Zong
3/24/2009 7:47:15 AM

 
Zong-Qing Li - MSFT:

Hi,

Based on my understandings, you want to view your data of the report according to the datetime. If so, please confirm whether the records have the datetime field. If the records don't have the datetime field themselves, we couldn't manage them via the datetime. So I suggest to add a datetime field, for example: add a column to record the time you inserting the data.


Please feel free to let me know if I’ve misunderstood anything.


 
HI, 
These is the problem In the DB i have series of events and for each event i have start and end date and time. Now i each moment i need to make sum of the events that are in the interval. So if i have
start 2009-01-01 12-00-00 end 2009-01-01 13-00-00 -> 50 units EVENT 1
start 2009-01-01 12-30-00 end 2009-01-01 13-30-00 -> 30 units EVENT 1
i need in the timeline report for 12-00-00 to be written 50 ..... till 12-29-00 then to be written 80 till 13:00:00 and then 50 again :))

One solution is to create other table, and for each minute from the interval to add different row with the date and time for the event. And then creating timeline report is very easy, i keep this option as last resort :)))
2009-01-01 12-01-00
2009-01-01 12-02-00
2009-01-01 12-03-00
2009-01-01 12-04-00
2009-01-01 12-05-00
.........
2009-01-01 12-30-00
2009-01-01 12-30-00
2009-01-01 12-31-00
2009-01-01 12-31-00
if i add rows like this then everything is much simpler, the report is making sum for all records that have same date :) 

Please Mark as Answer if it helps you in solving your problem.
0
aco_mk
3/25/2009 9:38:33 AM
Reply: