2 weeks or fortnight per page in SSRS report

Question

I have records for 3 weeks that needs to be displayed on an SSRS report 2 weeks per page. So my report would have 2 pages - first 2 weeks in the first page and 3rd week in the second page. How do I do this with a grouping expression?

score 1 · Accepted Answer · answered Sep 09 '14 at 04:18

1

First, have a column(in your query or stored procedure) that indicates the fortnight period.

For example, let the column name be FortnightPeriod, which can contain values like 1st fortnight, 2nd fortnight.

Then group by that column in your rdl and add page breaks for the group.

answered Sep 09 '14 at 04:18

kelsier

4,050
5
34
49

Thanks mate..That worked..I was trying to do it in the RDL which seems impossible.. – sujith Sep 19 '14 at 06:58

2 weeks or fortnight per page in SSRS report

1 Answers1