Adding a table to Crystal Report via Database Expert - @Parm1 Field

(0) Share

Report

Posted on by LSweeney

I'm trying to add a Vendor table to an existing Vendor - Summary report. 03670S. I want to add the address fields to the report. When I add the Vendor table, it prompts for the @Parm1. What is it looking for?

If I ignore, it prompts again when I attempt to run the report and comes back with no data.

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Brian_IL 719 on at

Like (1)

Report

That report pulls data from one SQL view - vr_03670s. When the Vendor table was added to the report, the datasource location was probably not updated to have the report pull from one datasource - steps handled in Report Designer.

Its probably easier to add the desired fields to the SQL view, since the Vendor table is already part of the view. After updating the view, the additional fields from the vendor table will be available in Report Designer, and you can drag & drop to the desired locations on the report.

Was this reply helpful? Yes No
LSweeney 65 on at

Like (0)

Report

Thank you!

Was this reply helpful? Yes No