Skip to Content
0
Former Member
Apr 06, 2011 at 09:48 AM

Crystal Report Server data with hidden filter parameters

102 Views

Hello SCN folks.

We are evaluating Crystal Reports Server. My question is:

Is it possible to create a Crystal report so that the data is filtered, (ideally at the SQL/database level,) by means of a parameter or field which is programmatically passed to the report viewer in such a way that the SAME report template and datasource would be shared between MULTPLE groups of users, each seeing a filtered subset of the report data? So for example a datasource has a "Company ID" high in each table's key and we want to filter each request implicitly on that but NOT allow the User to CHANGE or even see that filter parameter in any way, (I.e. passed as hidden or read only field when report is viewed and refreshed.)