How to print data in different pages of a report based on the condition given in request form

Business Central/NAV Technical Forum
1

Hello,

I’m working on Nav 2009 R2. I have a report, where I have given Date filter in Report Request Form (Two fields- From date and To Date). My requirement is, If I give a date range of 3 or 4 months(ex: 01/01/12 to 01/04/12) the data should get filtered month wise and then should get printed in different pages. (Jan to Feb in one page, Feb to March in another and so on)

Please let me know how can I achieve this.

Thanks in advance :slight_smile:

Hareesh

2

Hi Hareesh,

I am also new to the report builder, but to get around what you want to do, you can create in report designer so that the “date” virtual table is used as a group, and in the date group, add a subgroup of maybe Sales Invoice Header (If you want to print Sales Inv Header by dates)

E.g.

Date (Date Virtual table, filtered by PeriodType=Month)

→ SalesInvHeader (This is the dataitem that you want to be printed per Month)

3

Hi Jordi,

Thanks for the reply. Certainly will try it out. Looks possible [Y]