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
0
Comments
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.
Dynamics Nav Add-ons
http://www.simplydynamics.ie/Addons.html
We have used the Integer as DataItem in the Report .The Functionality is working Fine.But in the Report if we give more than 5 item in the order , the all Lines are displaying from the Second page.Only header part is showing on the First page.
Please help me out.
Thanks in Advance
Renjit
Do you have a large footer section(s) ?
Try turning off the KeepWithNext property on the lines section.
Dynamics Nav Add-ons
http://www.simplydynamics.ie/Addons.html
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
Have you other sections e.g. footer, transfooter that are causing this?
Dynamics Nav Add-ons
http://www.simplydynamics.ie/Addons.html
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
Check the dataitems for NewPagePerRecord / NewPagePerGroup properties
Dynamics Nav Add-ons
http://www.simplydynamics.ie/Addons.html