display data

This is the data in the table.

BookTitle1 BookGenre1 TitleName1
BookTitle1 BookGenre1 TitleName2
BookTitle1 BookGenre1 TitleName3
BookTitle1 BookGenre1 TitleName4
BookTitle1 BookGenre1 TitleName5
BookTitle2 BookGenre2 TitleName6
BookTitle2 BookGenre2 TitleName7
BookTitle2 BookGenre2 TitleName8
BookTitle2 BookGenre2 TitleName9
BookTitle2 BookGenre2 TitleName10
BookTitle3 BookGenre3 TitleName11
BookTitle3 BookGenre3 TitleName12
BookTitle3 BookGenre3 TitleName13
BookTitle3 BookGenre3 TitleName14
BookTitle3 BookGenre3 TitleName15
BookTitle4 BookGenre4 TitleName16
BookTitle4 BookGenre4 TitleName17
BookTitle4 BookGenre4 TitleName18
BookTitle4 BookGenre4 TitleName19
BookTitle4 BookGenre4 TitleName20
BookTitle5 BookGenre5 TitleName21
BookTitle5 BookGenre5 TitleName22
BookTitle5 BookGenre5 TitleName23
BookTitle5 BookGenre5 TitleName24
BookTitle5 BookGenre5 TitleName25



How do youdisplay data like this in the SSRS report?

BookTitle1
BookGenre1
TitleName1
TitleName2
TitleName3
TitleName4
TitleName5
BookTitle2
BookGenre2
TitleName6
TitleName7
TitleName8
TitleName9
TitleName10
BookTitle3
BookGenre3
TitleName11
TitleName12
TitleName13
TitleName14
TitleName15
BookTitle4
BookGenre4
TitleName16
TitleName17
TitleName18
TitleName19
TitleName20
BookTitle5
BookGenre5
TitleName21
TitleName22
TitleName23
TitleName24
TitleName25



  • Edited by ForumHelp7 Saturday, July 11, 2015 4:13 AM
July 11th, 2015 4:06am

How do you add the groups below each other?
  • Edited by ForumHelp7 Sunday, July 12, 2015 11:25 PM
Free Windows Admin Tool Kit Click here and download it now
July 12th, 2015 11:25pm

First get your mouse pointer on Details wow group and then right click and Add Parent group called C1(BookTitle1 column)in the image shown above and then select the c1 row group and Add child group c2 and so on and add every group with group header option
July 13th, 2015 9:56am

Thank you :)
Free Windows Admin Tool Kit Click here and download it now
July 14th, 2015 9:29pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics