Dynamics Community Forum Thread Details

DataSet which print a page per Transfer line.

I am creating a report for our logistics department. The report should do the following:

1. Lets say we have an Transfer document as follow

2. Now I am creating a Report which will print a INFO which mention the item description for each line

3. for the first line i have the quantity of 10 item so i need 10 pages, for the line after i have 4 item so I have 4 pages and so on.

How to achieve this in my data set, I tried to start preparing my DataSet and this how it looks like:

Is this design is correct? and in which part do I specify that I want a new page for each item in my transfer lines?

Hi Mo,

Just to confirm you would like to display the Transfer Order lines multiple times based on the Quantity and you want each instance of the Transfer Line on a separate page?

I think you need to add an Integer Data Item as a child under the Transfer Lines data Item and on the OnPreDataItem filter the Integer table to the Quantity like this:

SETRANGE(Number, 1, "Transfer Line".Quantity);

Indent the Transfer Line fields under the Integer Loop.

Now the Transfer Lines will always be repeated in your dataset as many times as the value in the Quantity field. If you need to display different things for each instance of the Transfer Line you will obviously need to write more code into the Integer Loop.

When you add the lines to the RDLC layout into a group, go to the group properties and switch to the Page Breaks tab and mark the "Between each instance of a group".

I hope this helps, let me know how it goes.

Quick Links

Leaderboard