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