Skip to Content
author's profile photo Former Member
Former Member

Create Report out of Query a question

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Oct 07, 2005 at 06:15 AM

    Hi Indika!

    Describe us plz how PLD should behave itself to draw variable values of DocNum and Ref2 columns in the layout header?? as for me i can't imagine it 😊

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      This is exactly what I require:

      where did you create your 4 new fields? I want them to be in the "Page header" area.

      I re-tried this using your query and added a Data field in the "Page Header" but all it does is pick up the first available DocNum in the OINV table. (This is what I found using my query too.)

      what am I doing wrong?.

      Thanks,

      Indika.

  • author's profile photo Former Member
    Former Member
    Posted on Oct 10, 2005 at 05:45 AM

    Hi Indika

    As far as I know you can't create new data fields in the header area. It will grab the first available record in the table since there are no link from the layout specific tables. All your information is in the repetitive area.

    Why do you want to print from a query if you have only 1 parameter? Would it not be better to print from the Goods Issue window where you will be able to do a proper print layout?

    Regards

    Danie

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi All,

      I needed to create Invoice (smilar to Ar Invoice) using the goods issue tables. My client sometimes issues goods to his customer at zero value and as we know it is not possible on AR invoice.

      If I were to print an Invoice out of the goods issue process then I would be needing to get the Ship to and Bill to informtion from the BP Master table as well.

      As the the address information are not available in the Goods Issue screen , I wanted to use a query to extract them ( I gather the BP code in to the Ref2 field in the Goods Issue screen), wanting to keep all logic in one place.

      Because of the B1 inablity to display header fields as I wanted I had to ditch this idea, and use the modified Goods Issue report, with a formatted search populating the address information on the goods issue screen now (which is also a better solution since the user can modify the addresses).

      anyway I hope SAP will fix this issue some day, as query-reports will not be able to do complex ones.

      Thanks for the assistance.

      Indika.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.