Post reply

Matrix Report

  • April 18, 2011 at 5:11 am

    #238788

    How to display all month name in matrix report.

    i add row group with Month name in matrix ..

    The month name not dispalyed even if no data's are there for the month..

    how to display the month......... please any one give suggestion for this

    thanks in advance

  • April 18, 2011 at 6:55 am

    #1312719

    Make sure your dataset shows a result for all months, even if the result is zero.

  • April 18, 2011 at 7:07 am

    #1312723

    Also make sure to have the month number in the dataset so you can sort by that column.

  • April 18, 2011 at 10:26 pm

    #1313164

    thanks for your reply... There is no record for the month(eg :March has no record) means how to display the month in matrix report

  • April 18, 2011 at 10:26 pm

    #1313165

    thanks for your reply... There is no record for the month(eg :March has no record) means how to display the month in matrix report

  • April 19, 2011 at 5:39 am

    #1313261

    You need a calendar table.

    The final query should be select from calendar left join (dataset)

    That will make sure you get all the dates available.

  • April 19, 2011 at 5:41 am

    #1313262

    Thanks For your Reply.....

Viewing 7 posts - 1 through 6 (of 6 total)

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