Crystal Reports How To — Pre-Filter Dynamic Parameters

Crystal Reports How To — Pre-Filter Dynamic Parameters

If you would like to pre-filter dynamic parameters do the following: Create command and link the command to the table.

Scenario:

I would like to view only processes related to the Sales Ledger module I.e. modulesysref = 1 Create a command with select * from processtable where modulesysref = 1

Link in Crystal Reports using the normal filter — Report | Selection Formulas | Filter.

Reference: https://archive.sap.com/discussions/thread/1538031