Post reply

Inserting blank row of diff colour between 2 rows in MSRS report

  • November 27, 2008 at 12:04 am

    #215888

    Hi,

    I have a report that contains multiple data. One of the column is a date column. I want to segregate records on the basis of date column such that records for a particular month should be separated from other with a blank row in between. That row should be of diff colour.

    any suggestions please.

    Thanks

  • November 27, 2008 at 5:08 am

    #904252

    Hi Swati...

    Well...jst wanted to confirm this...whether you are grouping the data based on Date Column or not...??

    B'coz we can applying grouping concept to sort the records Monthwise..and with in this...we can insert an additional row with desired color code...so as to differentiate the data in between...(that too month wise...)...

    So..jst let me knw clearly...whether this is the actual requirement..of yours..???

    Thanks 🙂

    Niraj

  • November 27, 2008 at 10:23 am

    #904419

    You should use GROUP in the Table/Matrix, that's what it's created for

    Then you can just leave the Group Footer blank to have your blank row

    SQLServerNewbieMCITP: Database Administrator SQL Server 2005

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

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