Skip to Content
Sep 12, 2014 at 05:24 AM

Create single LoV across many reports in crysta reports


I have previously developed many reports with dynamic cascading parameters using Crystal Reports 2008 but every time I create the parameters I used to do only in reports using Dynamic option in parameter window (As that is the only option I am aware of).. Also all reprots have same hierarchy. This was working fine...But I am unaware the fact that every time I create the dynamic paramter there will be new (DC, DF, BE and BV) are created 🤯 when I tried to check unfortunately the list was huge and it is quite unmanagable.

Then I tried to create the BV inside the Business View Manager and use that in report which was fine as I was aware of which business view and LoV I am using.. so far its working fine.. But I am struck at the point now.... There are 15 reports which use 15 different Fact tables but use same Dimension tables same set of LoVs. In this regard anyone help me with the following points in Business View Manager:

1. Can I create a single Business View with all 15 Fact tables? If yes... how can I differentiate between the fact tables to be used in report? Is there any concept of Context in BusinessView Manager as we use in Universe

2. If I need to create 15 Business Views for 15 fact tables then how can I use the same set of (LoV or more specifically Prompt group) across all business views so that deugging and managing are easy.

3.If above methods are not feasible, Experts please suggest me the efficient way to accomplish the task where there are 15 fact tables which use same set of dimension tables and same set of Paramters or LoV.

If it is a immature question I apologize.. as I am old to Crystal Reports but new to Business View Manager.

Thanks for your time