Post reply

Placement of group headings on my first report!

  • March 27, 2009 at 5:02 am

    #384233

    I'm generating a simple report of server, database name, date created eg

    Server1 Database1 Date

    Server1 Database2 Date

    Server2 Database1 Date

    What I really want to do is to display the following

    Server1 Database1 Date

    Database2 Date

    Server2 Database1 Date

    I can create a group & get the heading displayed so I get the following

    Server1

    Database1 Date

    Database2 Date

    Server2

    Database1 Date

    But that just looks messy.

    So my question is how do I stop a field repeatedly printing the same entry - I'm currently moving the contents of the data row into the group heading row to achieve the example above but I'm stumped on getting the output I really want.

    Hope that makes sense!

    Thanks

  • March 27, 2009 at 5:13 am

    #967304

    Spotted it.

    Silly me - opening the properties of the data row showed me the "hide duplicates" option which was exactly what I need.

  • March 27, 2009 at 11:27 am

    #967621

    Nice catch. Just responded to some questions about this the other day in the SSRS MSDN forums - Making a subreport problem. If you have questions about the layout of the table you can take a look at this reference - Working with Table Data Regions (there is a link on the site to switch to SQL 2008 if you need that information).

    ----------------------------------------------------------------------------------------
    Dan English - http://denglishbi.wordpress.com

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply