Using Parameters in Crystal 2008

[Lartey]

Hi,

I have created a report for SAP Business One 8.81 using crystal report basic 2008. The report selects draft sales invoices from my database. The source of the report is directly from the tables.

I then created a parameter to select a range of customers using the crystal token <My parameter>@from OCRD and allowed range of values.

The problem i have is that when i launch the report in Business One, the selection critiria allows suggests the customers to pick from but the output of the report disregard the selection critiria. eg. If i select customer 1000 to preview, the system displays all records for draft invoices.

How do i associate the parameter with the report so that it filters per my selection during report generation.

Regards

John

[Former Member · Accepted solution]

use the select expert record to filter your report based on the parameter eg odrf.cardcode = {?parameter}

[Former Member]

Hi,

In Menu Bar > Report > Select Expert > Record

Where new window will open , select the field which you want exact to display at run time

is equal to <parameter name>

Ok

Thanks

Kevin