PLD Report does not show data from Query

[Former Member]

Hello,

SAP b1 9.0 PL08 on MSSQL 2008 and I get data on the query, but when the PLD prints, it shows nothing. Is there a way to filter the data that the PLD shows? Does PLD have its own SQL script it uses b/c its not showing data from the query.

Thanks,

Nick

[Former Member]

Hi Nicholas,

Please check below links.

How to Make a Print Layout (PLD) Report from a SBO Query | SBOnotes.com

http://www.tegrous.com/wp-content/uploads/2011/07/HowTo_QPrintLs_88.pdf

Hope this help

--

--

Regards::::

Atul Chakraborty

[kothandaraman_nagarajan]

Hi,

How did you assign query to PLD? Did you select system PLD?

Thanks & Regards,

Nagarajan

[Former Member]

Nag,

How do you assign a query to a PLD?

Thanks,

Nick

[kothandaraman_nagarajan]

Hi,

1. Create query without parameter under query generator

2. Save it under query manager

3. Open query manager and select saved query and then choose create report

4. Highlight base template and click OK

To run this report, Go to Tools---User queries---Query print layout

Thanks & Regards,

Nagarajan

[Former Member]

Hi Nicholas

I assume this is a PLD added to a query? Did the query change after the PLD layout was created? Any changes to the query stored in the query manager DO NOT copy to the PLD. You need to create a new PLD every time the query changes.

Let me know if this is the issue.

Kind regards

Peter Juby

[Former Member]

Peter,

I did change the query after the PLD was created. I was hoping someone would say I could change the sql script assigned to it somehow.

Thanks,

Nick