BAQ Report Empty-BAQ Valid-Epicor 9.05.700C

Yahoo Archive
1
Sounds like you haven't added the BAQReportResult table yet.
It can be complicated to explain without pictures but..here is a general outline of the steps I use.

1.) Verify you are connected to the correct XML file?
- From the Crystal "Field Explorer"
--- Right Click on "Database Fields"
----- Left "Click "Set Datasource Location"
--------- ReportDataSet --> Properties --> File Path? Correct if necessary...

2.) Add the BAQReportResult table
- Database menu item
--- Database Expert
------- Expand the ReportDataSet (if your version of Crystal lists multiple reportdatasets, the "pigtail" indicates which you are connected to)
---------- Move BAQReportResult to "Selected Tables"
-------------- Add Links (if your version doesn't add for you)

Good luck...
2
I've created a simple BAQ report in the designer to add filters and options for my working BAQ.  The report produces an empty page - no data - no matter what I try.  Remove all filters, remove all options, add only some ,etc.  The BAQ is fine and runs fine.  It's the report that has no data.  I've racked my mind and assume there must be something simple I"m missing to get the BAQ Report to work.  Any ideas?

Renee
EMT International, Inc.


3
Verify that after you have Designed the Crystal Report that you have Actions --> Deploy BAQ report to copy the designed report to the server.  Actions --> Test BAQ Report uses the server copy of the report and not the local copy that was Designed.
4
Sounds like you have an issue with your report. In crystal go to database expert then click the links tab and make sure your tables are linked correctly and outerjoins are set properly.  I have run into blank reports like that before when the child table returns no data. 

-Bobby
5
Thanks.  Yes, the Deploy BAQ is pointing to the server.  Still get blank report.  :(

Renee
EMT International, Inc.
6
Thanks Bobby.  I checked the links in Crystal and there is only one link and only two tables.  The company table and the BAQReportParameter table.  They are liked by Key of Company.  I created this is BAQ Report designer so assume that's why it shows the BAQReportParameter table versus the individual tables.

Thanks,
Renee
EMT International, Inc.