Data from two tables Side by side in a report

renjita · 2009-01-13

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

DaveT · 2009-01-13

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.

renjita · 2009-01-15

Dear all,

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

DaveT · 2009-01-15

Hi Renjita,

Do you have a large footer section(s) ?

Try turning off the KeepWithNext property on the lines section.

renjita · 2009-01-15

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

DaveT · 2009-01-15

Hi Renjita,

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

renjita · 2009-01-15

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

DaveT · 2009-01-15

Hi Renjita,

Check the dataitems for NewPagePerRecord / NewPagePerGroup properties

Data from two tables Side by side in a report

Comments

Categories