I'm using Report Builder v3.0 and currently have a report displaying SQL Server backup times on a per server and per day basis. Works great. I'd like to expand this to display per server & multiple days with their corresponding backup times.
So it would look like:
ServerName Job Name Date BackupTime
My sql code in the dataset pulls back all the required information but getting it to do what I want it to do is my problem. Right now it just displays the most recent record in each return.
Under the "Job Name" column I edited the group properties to group on the "RunDateTime". Then it gives me the + next to my servername & it expands out to show each backup time per server/per date. Works just how I wanted it too!
Thanks to anyone that started to reply to his.
Marcado como respuestaCowskijueves, 02 de agosto de 2012 21:02