Want Data from two tables linked by order No side by side in a report

Business Central/NAV User Forum
1

Hi,

I want to generate a report which has order comments and Sales Order Line Details Side by Side.

For example…For Sales Order RT300 We have two Sales Line

Type Document No. No Description Quantity Line Amount
Item RT300 T1 Tea 50 3000
Item RT300 C2 Coffee 50 3000

And Order Comment from Sales Comment Line is
Comment Type Comments No.
Comments Comment1 RT300
Comments Comment2 RT300
Comments Comment3 RT300

So I want the result as both tables data merged with respect to RT300 in the report i.e both tables data side by side

Comment1 Item RT300 T1 Tea 50 3000
Comment2 Item RT300 C2 Coffee 50 3000
Comment3

Any Way to do this ?

Thanks in Advance
renjita

2

Hi Renjita,

There are a number of possiblities. The easiest to explain is to use a Integer loop. Declare the comments and sales line as record variables and filter them to the order needed. Set the range on the number field to be the bigger COUNT of the filtered record variables. Then in the loop print the values from the record variable.

3

Hi,

I have tried this ?. But still it is not working.if the record lines are less than 5 then it is showing in first page only.Otherwise the lines are going in the second page.

I have Dataitems used…

Sales Line
Integer

Any Solutions ?

Thanks
renjita

4

Hi Renjita,

Have you other sections e.g. footer, transfooter that are causing this?

5

Hi,

I have only header and body sections of Sales Header, Sales Line and integer.I have Shortened the section width but still the lines are showing in second page onwards.The first page is showing only header part.

Please Help…

Thanks
renjita

6

Hi Renjita,

Check the dataitems for NewPagePerRecord / NewPagePerGroup properties