Expand a servername with seperate values in Report Builder 3.0

Question

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

                                               Date      BackupTime

                                               Date      BackupTime

etc.

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.

Answer 1

Actually I just figured it out.

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.