Skip to Content
0
Former Member
Oct 07, 2005 at 05:40 AM

Create Report out of Query a question

29 Views

Hi,

I don't have much experiece with this one. I am using the Print Layout Designer to modify a report I created with a query.

Now all of my query results are appearing in the repetitive area1 ( the detail lines ). But there are some fields that are in the repetitive area1 that I need to move to the Page Header. But PLD does not allow me to.

I treied add a Data field and assign the table.field but it does not display value(probably becuase PLD does not know how to link that field )

Simplified query:

SELECT H.DocNum, H.Ref2, L.ItemCode FROM

OIGE H INNER JOIN IGE1 L ON

H.DocEntry = L.DocEntry

I want to display the DocNum and Ref2 on Page header and ItemCode on the repetitive area1. But all are in the repetitive area1.

I cannot use the advance Layout Designer since it does not support Parameters, and my query uses a parameter.

Thanks,

Indika.