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