Post reply

Alternative Row formatting in SSRS

  • January 7, 2009 at 6:55 pm

    #198075

    Hi,

    I am feeling a bit difficult in getting alternative row formatting in SSRS.

    Please help me in this regard.

    Consider,there are 4 fields are displayed as a table in report.

    Name-- Age-- State-- City--

    A1 -- B1 -- c1-- D1

    A2 -- B2 -- c2-- D2

    A3 -- B3 -- c3-- D3

    A4 -- B4 -- c4-- D4

    There is alternative row formatting for the display of table in blue,white.

    If the A3 row wont come from database for certain filter on the query..still i have to manage the alternative row formatting with 'A3' text getting displayed(not the entire A3 row..to facilitate the user that A3 row does not have data for this filter from database).

    Any options?please help me..

    Thanks in advance,

    santhu.

  • January 7, 2009 at 7:41 pm

    #923043

    You should be able to use a Mod 2 to alternate the rows in your table. If this is a Matrix it becomes a bit more difficult, but if you google "Green Bar reports +SSRS" look for Chris Hays' blog. He has a great method there.

    If you still need to show a row for A3 even if there is no data then just use an outer join to a table that does have the a3 record and then hide all of the NULLs that will result.

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

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

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