Skip to Content
avatar image
Former Member

Dynamic view names with Crystal reports

There are 3 types of views in my DB i.e. A, B, C. Each crystal report should have in its data source: 1 view of type A, 1 view of type B and 1 view of type C.
So, in short each Crystal report can be based on either of views: (A1, B1, C1) OR (A2, B2, C2)... OR (An, Bn, Cn)
The requirement was to create a single crystal report which can be used with any of these views at run time. This report should accept 1 parameter and on the basis of the value of this parameter, should select data from A*, B*, C* views.

I created a crystal report with one parameter in main report. This report contains a sub report which has a stored procedure as a data source. The parameter of main report is linked to input parameter of stored procedure. On the basis of the value of the parameter, the stored procedure fetches data from An,Bn,Cn views. Now the requirement is to have additional parameter in sub report on the basis of which data returned from stored procedure can be filtered. Can this be done?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 02, 2017 at 07:55 AM
    Add comment
    10|10000 characters needed characters exceeded