cancel
Showing results for 
Search instead for 
Did you mean: 

Crystal report parameters from user table

Former Member
0 Kudos

Hi expert,

I need to design a Crystal report for get data from an user table ( [@myTable] )

Im Crystal report designer y design a report with one parameter:

"key@ select a,b from [@myTable]"

(I know that if parameter were "key@ select itemcode,itemname from oitm" ...its work fine.... because get values from oitm...so i required get data from [@myTable] )

SAP 8.8 PL20

Crystal Report basic for SAP Business One Version 12.1.3.1028

SQL 2008

Thanks in advanced

regards,

Alejandro Moran

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Alejandro

Change the parameter to include a cross join to the OADM table

key@select t2.a,t2.b from OADM T1 INNER JOIN "@myTable" t2

Hope this helps

Rob

fbio_bilicki
Active Contributor
0 Kudos

Hello,

put the table name with double quotes

Example, i have the table user UPP_OAUT, containing two fields, code and object.

In the Crystal Reports, use the command above.

select code, object from "@UPP_OAUT"

Regards,

Fabio