CODEWITHSUNDEEP
crystal-reports
Bill
Bill

Reputation: 3

Set command parameter of a subreport equal to a main report parameter

In my main report, I insert a number for column ID into the selection criteria. It grabs all relevant information where the ID matches.

Now I have a subreport that uses a COMMAND with a SQL Query. Inside, there is a WHERE clause where ID = {?PM-ID}.

How can I configure my SQL Query to pull in the specific ID value I entered into the selection Criteria of the main Report?

Upvotes: 0

Views: 384

Answers (1)

Krum
Krum

Reputation: 150

Try this, right click on Subreport > Change Sub reports Links

In that window you have to match the ID with the respective column in your sql query.

Upvotes: 1

Related Questions