I made a crystal report which pulls data from 4 tables: "OCPR", "OCRD", "OQUT" and a UDT "_Custom_Table".
The links are
"_Custom_Table"."U_CardCode" -> "OCRD"."CardCode", Inner Join "_Custom_Table"."U_CntctCode" ->"OCPR"."CntctCode" Inner Join "_Custom_Table"."U_Quot_ID"->"OQUT"."DocNum" Inner Join
When I preview the report in Crystal Reports it works without issues, same when I use the "Preview External Crystal Reports File" function.
When I import the .rpt file as a report layout and click the PDF button it does not work unless I remove any fields from the OQUT table. It generates a pdf with blank values in place of the Database Fields. When I remove the OQUT fields it works without issues.
I changed the OQUT link to Full Outer Join and that caused all the fields from the other tables to be populated. The fields I need from OQUT remain empty.
This caused me to believe that for some reason B1 cannot retrieve the data so I copied the SQL query from Crystal and I ran it in the Query Generator. All the values were correctly returned.
So in short, the report works in Crystal and "Preview External", it does not work when generating PDF.
This has me completely stumped, any ideas would be greatly appreciated.