RDD for ARForm Public Cloud

Epicor ERP 10
4

No need for the “Mr.” :slight_smile:

Not being familiar with cloud based implementations, some of what I say might not work, Especially if you’re Multi-Tenant.

  1. Open up Report Builder an make new report, select Blank Report
  2. In the new blank report, remove the default “Click to add Title” textbox, and Remove the Footer
  3. Right click Data Sources and select “Add Data Source…”
  4. Select to the Embed the datasource
  5. Click the “Build…” button
    image
  6. Enter the name of the DB server (it doesn’t always show in the dropdown list)
  7. Select the Authentication method
  8. Select the DB for the App
  9. Test the connection
  10. close the Connection Properties window
    image
    image428×568 13.6 KB
  11. Close the Data Source Properties window.
  12. Add parameters “Company” (type Text), and “PackNum” (type Int)
  13. Right click Datasets, and select “Add…”
  14. Select Use embedded dataset
  15. Select the data source created in step 4

image
image678×603 12.6 KB

  1. Click the Query Designer button

  2. Add the fields ShipHead.Company, .PackNum, .TarckingNumber

  3. Add a filter for Company

  4. Select the Parameter checkbox

  5. Repeat 18 & 19 for PackNum, then OK to close the window

    image
    image824×638 27.8 KB

  6. Your query should look like:
    image

  7. Insert a textbox, and set its value:
    image

  8. Move the text box to 0,0, and reduce the body of the report to the size of the text box.

Test it out.

You can now insert this as a subreport in your main report. Don’t forget to set the Parameters of the sub-report’s properties.