Skip to Content

Dynamic view names with Crystal reports

Dec 29, 2016 at 10:17 AM


avatar image
Former Member

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Abhilash Kumar
Jan 02, 2017 at 07:55 AM
10 |10000 characters needed characters left characters exceeded