Lollipop   

Welcome to PcCare.com

Epicor9 Baq based Crystal Reports


Create a baq containing the reports tables. This example uses baq aa-Test.

screen image of boot menu

Executive Analysis->Business Activity Management->Setup->Business Activity Query->analyze->Test->Verify data meets report requirements.

Executive Analysis->Business Activity Management->General Operations->Baq Report Designer->File->New Report Definition->Report ID->Test->Baq ID->aa-Test->Crystal Report->Test.rpt

Executive Analysis->Business Activity Management->General Operations->Baq Report Designer->File->New->Option Field->JobMtl.JobNum->Actions->Generate Sample Data->Save Report Directory in message box

Executive Analysis->Business Activity Management->General Operations->Baq Report Designer->Actions->Baq report actions->Local Reports Directory->save for later

Start Crystal Reports->File->New->Blank Report->Database Expert->Create new connections->Ado.net->File Path->Enter sample Data directory from above->C:\_BAQ Reports\Reports\SampleData\Test_Data.xml

Crystal Reports->Database Expert->Report Dataset->Press >> to move dataset to right pane->OK->OK->Ignore message "Your current link configuration contains multiple starting points"

Crystal Reports->Field Explorer->Baq Report Result->Drag and drop fields into report detail section.

Crystal Reports->File->Save as->save into file path from above steps

Epicor->Executive Analysis->Business Activity Management->General Operations->Baq Report Designer->Actions->Deploy Baq Report->

Epicor->System Management->Security Maintenance->Menu Maintenance->Choose menu to add report->File->New Menu->MenuId->Use value similar to other menu items in same group->Program type->Baq Report->Report->Test->Save->close

Epicor->System Management->Security Maintenance->Menu Maintenance->Choose menu to add report->File->New Menu->MenuId->Use value similar to other menu items in same group->Program type->Baq Report->Report->Test->Save->close

Close epicor application and restart to load new menu item

Close epicor application and restart to load new menu item
DISCLAIMER: It is assumed that users are familiar with the operating system they are using and comfortable with making the suggested changes. PcCare.com will not be held responsible if changes you make cause a system failure.

Please review our Terms of Service and Privacy statement before initiating service or using this site. Microsoft® and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. PcCare Site Map. About Us

PcCare.com is owned and operated by TechnoChill Inc.