May 21, 2012 at 6:51 am
Hi ,
Im a newbie to the world of report building and BIDS in particular.
I need assistance - I need to illustrate a breakdown in charging time of a battery based on the report start time and report end time
so if the report is drawn from 18:00 to 23:00
i need to display in the following manner:
charged 19h05-19H15 10 mins
20h40-20h55 15 mins
21h04-21h45 41 mins
ect-till 23:00
TOTAL charge time = xx mins e.g (which must be converted into HH:MM:SS)
How to i do this?
May 21, 2012 at 8:26 am
I assume you have queries to get this data? If not, you'll need someone to help you write a query. If you have questions on that, post some DDL and sample data in a T-SQL forum here for help.
For the report, if you haven't worked with BIDS and building reports, you need to learn. This isn't something easily answered here, but you can read this series of articels for help: http://www.sqlservercentral.com/stairway/72382/
May 21, 2012 at 8:44 am
jparenzee (5/21/2012)
Hi ,Im a newbie to the world of report building and BIDS in particular.
I need assistance - I need to illustrate a breakdown in charging time of a battery based on the report start time and report end time
so if the report is drawn from 18:00 to 23:00
i need to display in the following manner:
charged 19h05-19H15 10 mins
20h40-20h55 15 mins
21h04-21h45 41 mins
ect-till 23:00
TOTAL charge time = xx mins e.g (which must be converted into HH:MM:SS)
How to i do this?
have a look at the datediff function in books online - this should show you almost everything you need to make those date calculations
e.g. - number of seconds between start and end = datediff(ss,start,end)
MVDBA
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply