Sensa
Sensa

Reputation: 393

How to map parameters with database in crystal report to show only required data

I am confused in using parameter in Crystal Reports

I have mapped the required table and fields and design a report too. and created 3 parameters: BranchCode, FromDate and ToDate

Need to display all records from BranchCode During the seleted period (From & To date)

Note: So for i have designed and passed the parameter from code to crystal report.

Now let me know how to show only the records which matching to these parameters ?

Note: I didn't use query. Just add required field from table to crystal report.

Expecting your valuable reply. regards, Sensa.

Upvotes: 0

Views: 4268

Answers (1)

craig
craig

Reputation: 26262

Create the following record-selection formula:

{table.branch_code} = {?BranchCode}
AND {table.date_field} IN {?FromDate} TO {?ToDate} 

Upvotes: 0

Related Questions