Modifying the Crystal Report

  1. Open the report in Crystal in Field Explorer view.
  2. Add the cascading parameters to your report.

    See Working with Crystal Reports cascading parameters.

  3. Add the LAWSONRS_ReportAccessId variable to the report.

    See Using Reporting Services system variables to create Crystal Report parameters.

  4. Select Database > Database Expert.
  5. Create a command table with an SQL query for LAWSONRS_ReportAccessId.

    For example, this is a s query based on the country or region example in the steps above.

    SELECT DISTINCT
    Customer.`Country`,
    Customer.`Region`,
    Customer.`City`
FROM
    Customer INNER JOIN User_Country   ON
    Customer.`Country` = User_Country.`Country` AND
    Customer.`Region` = User_Country.`Region`
WHERE
   User_Country.USER_ID = '{?LAWSONRS_ReportAccessId}'
  6. Click OK. Save the report.