I am making a crystal report using a baq. I created the report in epicor and deployed it but the BAQReportResult table is missing so I can’t drag the fields into the report.
I read on the forums something about clicking “generate sample data” but I did not see that button and I do not remember having this issue with the other few reports I made recently. The BAQ is quite simple and was run a few times before making the crystal file.
There are no files in the sample data directory.
Did I miss a step when setting up the report? Is there something wrong with the sample data file path?
aidacra
(Nathan your friendly neighborhood Support Engineer)
2
You should be able to find the data to use for your report development in \epicorservernamegoeshere\epicordata\reports[epicorusernamegoeshere]\BAQ Reportxxxxx.xml
Once you connect to the .xml file like @aidacra described, you can click on Database - Database Expert and bring over the BAQReportResult into the Selected Tables list if it is missing. (I’d just bring over the whole Report Data Set.) It should then show up in your Field Explorer.
The “generate sample data” is no longer in the BAQ Report Designer in E10. I now generate the .xml file by clicking Actions - Test Report Form - enter the parameter values and print preview:
I believe the Sample Data Directory was the location where the “generate sample data” .xml file was normally saved but since that option no longer exists I’m not certain why you are seeing that Directory field? This is what I see under BAQ Report Options in E10.1.600:
Thank you! I checked there this morning and there were no files in there. I tested the report again just now through baq report designer and the xml file showed up!
