on 07-06-2011 4:16 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.