Skip to Content
avatar image
Former Member

Query PLD

Hi,

I have a specific requirement from my client, where i have to get the batch no. and serial no in my invoice print layout. I did this using query pld.

When i did that using query pld i'm getting result in row level. But my client requires bill to address, customer name and document id, document date should be in header level. I tried with giving link to ... but it is not working. Is there any method by which i can get the output.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Sep 29, 2008 at 07:05 AM

    Query PLD would purely print what is in the results of your query. If you want the Customer and other information..they also need to be added in your SELECT statement which forms your query

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      What more do you need..Just move the field from Page Header to R A Header (just where you see the column headings)

      Go the RA Header properties and increase the Height

      the move the col heading to the Bottom for that block and Keep your formula field on the Top

  • Sep 30, 2008 at 02:43 AM

    Hi,

    I have tested the query PLD I created by adding some fields in the header and it is excluded in the query. It is as same as your current problem. The result is not as same as standard PLD. In B1 2007A or B, it is resolved. Temporarily it must still be separated or try to use crystal report.

    Rgds,

    <http://tech.groups.yahoo.com/group/SBO_Knowledge_Village/>

    Add comment
    10|10000 characters needed characters exceeded