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. Follow

4 Replies
1138 Views

Similar Articles

[PageSpeed] 48

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:

Similar Artilces:

SQL Server Reporting Services / VS 2008 intelligence / Report Builder 2.0 Video Tutorails
Hi, If some of you know some good video tutorials for building reports in VS 2008 intelligence / Report Builder 2.0 , please share.thanks Please Mark as Answer if it helps you in solving your problem. Hi Ace i have some tutorials that i think u could use :)   Hi, Please check the following links. Report Builder 2.0: http://msdn.microsoft.com/en-us/library/dd239338.aspx Microsoft Reports: http://msdn.microsoft.com/en-us/library/bb885185.aspx Video: http://msevents.microsoft.com/cui/SearchDisplay.aspx?culture=en-US#culture=en-US;sortKey=;sortOrder=;pageEvent=false;hdnIni...

.NET 2.0 Reporting Module using SQL Server Reporting Services
Hello Everyone,I have created a generic module using ASP.NET 2.0, MS SQL Server 2005 and SQL Server 2005 Reporting Services. This module is intended to provide a generic user interface for selecting and generating reports. You can configure its respective table for your fixed or flexible parameters for each report. It also supports end user access level security for each report and report group which is generally required for any basic reporting module.You can view reports in two different styles:-- Drop down--Tree View And You can view your report in 3 supported formats.  This is an in...

SQL Server Reporting Services for SQL SERVER 2000 AND Visual Studio.NET 2005 .NET 2.0
Hi, Which version of SQl Server Reporting Services will work with SQL SERVER 2000 in pararrel with ASP.NET 2.0 (.NET 2.0 framework)?  Thanks, Azam HighOnCodingWanna get high! Hi, Okay I got the answer. Yes, we can use the SQL SERVER 2005 Reporting Services with SQL SERVER 2000. HighOnCodingWanna get high! ...

"Using other editions of SQL Server for report data sources and/or the report server database" is not supported in this edition of Reporting Services
Hi My project is in .NET 2003 i.e. framework 1.1 and database in SQLServer 2000. But the reports have been developed using SQLServer 2005 Reporting Services. Now when I am trying to deploy them through deployment project of .NET its giving me following error:"Using other editions of SQL Server for report data sources and/or the report server database" is not supported in this edition of Reporting Services.  Now I am really confused with this. Can any one please guide me regarding this ASAP. Thanks, Falguni    You will need to use the SQL Server ...

Export PPT and PPS reports in SQL Server 2008 Reporting Services
What’s new in this release? Aspose.Slides for Reporting Services v2.0.0.0 now allows you to export Microsoft PowerPoint PPT and PPS reports in SQL server 2008 also. The improved rendering engine makes it possible generating reports with nested tables, groups and lists. More about Aspose.Slides for Reporting Services Aspose.Slides for Reporting Services is a rendering extension for Microsoft SQL Server 2000, 2005 & 2008 Reporting Services (x86 and x64) to generate reports in Microsoft PowerPoint PPT and PPS formats. All RDL report features including tables, matrices, charts, images, su...

Report Server Project using sql server 2005 and VS 2008
 ok...this question might be completely stupidI run sql server 2005 and VS 2008...I need to create to Report Server projectVS2005 has the Report Server Project under the Business Intelligence Projects selection when you create a new project...How do I do this in VS2008?  Unfortunately u can't do it with VS2008U have to use VS2005 for sql server 2005 reporting.VS2008 will support[not current]  the reporting services project of Sql server 2008 You can check http://www.tech-archive.net/Archive/VisualStudio/microsoft.public.vsnet.setup/2008-01/msg00026.htmlKamran ShahidSr. ...

How to design SQL Server 2005 Reporting Services Reports in VS.NET 2005 web applications
Hi,   Can we design SQL Server 2005 Reporting Services Reports in VS.NET 2005 web applications. If so how they can be designed. Plz help me if any one know the solution. Thanx in advance, Vidya     Are you asking if you can use VS.Net 2005 to design reports, yes, both client and server reports are built using VS.Net. If you are asking if you can use a web application to build a report, well yes you could, but you would have you design it.  All sql server reports are is an xml file, so if you can build a front end that will generate the xml in the proper ...

Crystal report not showing in web in windows server 2003 with CR 2008 using .Net 2.0 framework installed.
we have Crystal Report 2008 Full product  installed in Windows XP professional SP2 and visual studio 2005 in the development system.We are able to see crystal report thru the Crystal Report Viewer in web.   For deployment when we have installed CR 2008 in Windows 2003 server standard edition and it has also .Net 2.0 Framework(no visual studio 2005 installed in it).But not showing  the report thru CR viewer.   Can any one help  that do I need to install anything more in the server.My guess is CR viewer is unable to show the crystal report.Although i...

Crystal Report vs SQL Server Reporting Services
Hello,Can any one suggest which is best Crystal Report or SQL Server reporting services,  in compare of performance, developing and licensing cost.Can we use any of these reporting on shared hosting.If we want to go for SSRS then which edition of SQL Server we should purchase.Thanks,Deepesh Verma Dont forget to click “Mark as Answer” on the post that helped you.This credits that member, earns you a point and mark your thread as Resolved for the sake of Future Readers....

Crystal Reports vs Sql Server Reporting Services.
I have some reporting requirements. Please advise whether I should go for Crystal Reports or Sql Server Reprting Services.Please click "Mark As Answer" if this hepled in solving your problem. Onr thing I would like to add. The reports are to be incorporated in web pages only or can be viewed by the business people standalone, but no support for desktop based product is required.Please click "Mark As Answer" if this hepled in solving your problem. Check this link. its good, but its better, if u tell ur requirements briefly. so that we can suggest u http://www.crystalr...

Report Features NOT using SQL Server Reporting Services
Hi, I have a web app that is using rdlc reporting that needs some refinement.  The research I've done on the improvements I'd like to make indicates that they can be done with SQL Server Reporting Services; however, I don't have a license for SQL Server and would like not to have to purchase one if I can do what needs to be done without it.  I'd like to know if it is POSSIBLE in rdlc reporting to do 2 things, and if so, how to approach a solution: 1. I would like to export a version of the report to a file location on a routine basis (say once a day). 2. T...

User instance when using VWD 2008 and SQL 2008 reporting services
Hi All I have been fighting an issue for nearly 2 weeks now. I have recreated an asp app which links to a database within app_data the user must login in to the database to extract information. One of the pages incudes a Chart which uses reportviewer to extract from a reportserver on my local machine (at the moment). I can logon to the reportserver and see my deployed report project and datasources and reports . I can view the reports from here no problem.  The issue- : If the Chart page is shown within the root(ie not logged in) and manually input the parameter required it s...

How to add barcode images in Reporting Services 2000 (SSRS 2000) with VS.NET Report Server Projects
Due to its flexible design, Neodynamic Barcode Professional for Reporting Services allows you to show barcode images in Microsoft SQL Server 2000 Reporting Services reports. You can use all Barcode Symbologies Linear & 2D built-in Barcode Professional.In this Step By Step Guide you'll learn how to create a Reporting Services report which shows barcode images into it using Barcode Professional and Visual Studio .NET 2003. In this sample we'll create a Reporting Services report to create fictitious access cards for Northwind's employees getting them from Microsoft's Northwind database samp...

Creating Editable Reports using Sql server Reporting Services
Hey All I m new to sql server reporting services and have done a lot of search into it i have also created some custom reports now i want to  create editable reports the textbox control which we can add in reports should be editable after generation of reports  i think its possible just want to know how so wht do u think   regards shark...

Web resources about - Build Timlenie Reports using SQL Server Reporting Services 2008 Report Builder 2.0 or VS Inteligent 2008 - asp.net.ssrs

Bubbles June 13 1 - Flickr - Photo Sharing!
Looks much better large.... just press L on your keyboard.

Twitter
Sign in Sign up To bring you Twitter, we and our partners use cookies on our and other websites. Cookies help personalize Twitter content, tailor ...

Photo by eonline • Instagram
eonline's photo on Instagram ariiu If you are not agree with the publication, please, be a little more inteligent and keep quiet. Thanks !

Randon thoughts
EDMONTON _ Just sitting in the press box at Rexall Place waiting for the puck drop between the Senators.Talk surfaced that Jason Spezza has ...

All Movie Talk » Top 6 Words: Life
Posted in Top 6 Words at 5:00 am by Sam For this entry in the Top 6 Words series, I asked my friend ThePhan to pick a word for me. She chose ...

Baby Blues Archive
www.babyblues.com is the official site for Baby Blues cartoons, stuff and links featuring daily and Sunday comics, books, calendars and events ...

Tips
All About Babies – One Stop Baby Resources Home Baby-Development Stimulation For Baby Pregnancy Suggest A Link Contact Us Archive for the ‘tips’ ...

A Place to Stand
A Place to Stand Comments from Scotland on politics, technology & all related matters (ie everything)/"The whole aim of practical politics is ...

Futureseohelper: Free Directory List, Free Articles Sites List, Social Bookmarking Sites List,Huge List ...
skip to main - skip to sidebar Home Free Articles Submission Sites Free Directory List RSS Feed Twitter Futureseohelper Social Bookmarking Sites ...

Rock Snob Confidential
Well I know it is the edgy/cool thing to hate Panic at the disco. But for the record, I will be a "cliche loser" and like them. Their catchy ...

Resources last updated: 12/26/2015 6:37:30 PM