Post Author: NicoHennrich
CA Forum: Data Connectivity and SQL
I want to realize multi-client capability in crystal reports. Therefore I need a way to restrict the content of the dynamic parameter list. I tried different ways:
1) Using the default dynamic paramter list - but I found no possibility to filter it. Does anybody know a possibility to filter the content?
2) Filling the dynamic paramter list by a SQL Command - but I don't know how to pass the "CurrentCEUserName" ( or any other CR function) to the SQL Command
3) Filtering the data in the database. Is there a possibilty to pass CurrentCEUserName as the database login name (in BO 6.5 it is done using the @BOUser variable in the database connection)
or does there exist any other way to realize multi-client capability for CR XI?