Is this format of reporting possible in SSRS

  • Hi All,

    I am trying to mimic an excel report in SSRS using VS. Please see the below screen shot. Can I exactly mimic this in SSRS?  Will it be a tabular or matrix and how can I get the Qtr1 Qtr2 Qtr3 and Qtr4 fields. I have a date field in the dataset. Your help is greatly appreciated.

    Thanks

    Capture

  • To get the quarter you can use a calendar table that has the quarter specified for each day(if you have one).

    Or something like this.

    SELECT

    CASE MONTH(GETDATE())

    WHEN 1 THEN 'Qtr1'

    --etc

    WHEN 7 THEN 'Qtr3'

    --etc

    END

    To present the quarter in your report you should try merging the 3 cells.

    Good luck

    • This reply was modified 4 months, 3 weeks ago by  Chrissy321. Reason: typo
  • Thanks. I will try this and will let you know.

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

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