SQL queries in a PLD report

[Former Member]

Hello experts,

I am working in a sales quotation and I need to access the table CRD1, field: Street. If I access the table (using the ALT Key in the data base field that I am creating) all the information in the report disappears, if I remove the new database field the information appears again in the report.

Is there any way to access the Business One data base tables through SQL queries from a PLD report  ?

Thanks in advance.

[Former Member · Accepted solution]

Hi,

Can you tell me on which document are you making print layout.Becos if you need the adress bill to,ship to you can directly take from the form feild no need to use crd1.

Mona.

[Former Member]

Hi,

Can you tell me on which document are you making print layout.Becos if you need the adress bill to,ship to you can directly take from the form feild no need to use crd1.

Mona.

[Former Member]

Hi Mona:

Thank you for helping me again,  I'm working with a sales quotation PLD.  Yes I see that I could use a field with name address2 in the table OQUT, but what I see is that this field joins several fields from the bussines partner ( Address tab, ship to ), and then I would like going directly to the business partner information, in these cases I would prefer to work with sql queries, by the way, could you tell me if I can work with SQL queries in  PLD reports ?

Regards.

[Former Member]

No for SQL queries you need to use query layout design to build the report.

[Former Member]

Do you refer to crystal reports ?

[Former Member]

In SAP B1 there is an option where you can use Query layout desiger to build only query based report.

In Crystal report you can use query to design a document.

[Former Member]

Mona:

I really appreciate your help, I have only 4 months working with SOP, I won a SAP BO certification recently, but there are many things that I need to know and learn.

Where are you from Mona ?