July 11, 2024 at 4:32 pm
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
July 12, 2024 at 2:30 pm
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
July 12, 2024 at 2:56 pm
Thanks. I will try this and will let you know.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy