cancel
Showing results for 
Search instead for 
Did you mean: 

QLD - Name & Address of the customer should get reflected.

Former Member
0 Kudos

Dear all,

My issue is the parameters which i have assigned for example From Customer to To Customer, I want the name of the customer & address should get reflected on the header part of the QLD.

Regards-

Monica.

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

issue solved

Former Member
0 Kudos

Hi Mona,

IF you need to print the Customer Name and Address will display in header.

Try this,

Note: All SELECT statement fields will be Stored and Display in Repetetive Area1. and

Parameter Fields are in Repetetive Area0 so you can Try to Copy & Paste the Field_ID's to Repetetive Area Header (or) Repetetive Area Footer.

for example.

Try this,

->> Open the QPLD and Goto Field index Window, then

->> Select the Repetetive Area Header & Repetetive Area Footer increase the Height on Properties Window.

->> Create the Formula fields in Repetetive Area Header & Repetetive Area Footer.

->> Which Field you want to print in header or footer. Drag the Field ID(in Repetetive Area) Copy & Paste to Formula Field.

for example,


SELECT CardCode, CardName, BilltoAddress FROM OPOR WHERE CardName BETWEEN '[%0]' AND '[%1]'

-> in Repetetive Area(CardName, Bill to Address) require field ID Copy & Paste to Formula Field in Repetetive Area Header.

->> Select the Repetetive Area 1 on Field Index Window.

->> Goto the Print Layout Designer on Tool bar.

->> Click Repetetive Area. -> Sort...

->> Open the Sort Widnow and Select the Requrie fields by sort.

ELSE Try this,

->> Click the Repetetive Area Footer 1.

->> then, Right Click in Repetetive Area Footer 1.

->> Choose the GROUP -> 1. then,

->> Create the Formula Fields in Repetetive Area Footer 1 and copy paste field ID's from Repetetive Area 1.

->> Select the Repetetive Area 1 on Field Index Window.

->> Goto the Print Layout Designer on Tool bar.

->> Click Repetetive Area. -> Sort...

->> Open the Sort Widnow and Select the Requrie fields by sort.

Ex.

->> Select Field Name, Sort by, Order, Summary, New Page.

1st you can Select Field Name (Sort by) -> CardCode (or) CardName

Sort Type - Alpha.

Order -> Descending (or) Ascending.

Summary -> Select the Tick Mark.

New Page -> UnCheck the Tick Mark because if you need the second page Print of GROUP BY.

You can select the Tick Mark in New Page.

SAVE IT and see the Print Preview. it will be get exact Print. .

Check the thread. you will be get idea or solution.

Regards,

Madhan.

Former Member
0 Kudos

Hello

Unable to meet this requirement as standard.

The alternatives are 2:

- Add variable input as the address (though clearly not have a direct connection to the SN)

- Use once listed the query, the Filter Tool SAP Business One, so to filter by address (thinking that in the list are these reports).

Best regards

Former Member
0 Kudos

Dear Monica,

From Customer to To Customer would be a range of customers. How could you possibly print their names and addresses out on the header?

Thanks,

Gordon