Skip to Content

Using Parameters in Crystal 2008

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    May 27, 2011 at 11:03 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 27, 2011 at 11:18 AM

    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

    Add comment
    10|10000 characters needed characters exceeded