Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kkiranvr
Yak Posting Veteran
54 Posts |
 Posted - 2008-08-04 : 20:46:57
|
| Hi all, I am creating a report using SSRS tool, and i am new to SSRS, here i am creating a simple table from the report builder, and i am having the columns, StartTime, EndTime and Duration. I am having StartTime as Datetime Duration as Int in my table,From this i need to get EndTime as Datetime format. and Endtime should be Duration + StartTimeso here my question is, How can i get Endtime and how can i keep this value into my Report?-Thanks N Regards,Chinna. |
|
|
mrm23
Posting Yak Master
198 Posts |
Posted - 2008-08-06 : 04:55:28
|
| i think you can add them.so,for the endtime field in the layout, just assign their sum. i tried something like this:select getdate() + 1.2 and this worked for me. so i think you can simply add those two parameters. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-06 : 14:16:38
|
| use DateADD("d",Duration,StartTime) |
|
|
|
|
|
|
Report Parameters