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
Abhilash Kumar replied
I'm going to answer you question in the title first. You can and ideally should (as a best practise) create LOVs that can be shared across reports.
If there are 15 reports that use the same LOV, you should create them in the Business View Manager and simply point the 'Dynamic Prompt' that you create in the report to this LOV. To do this, just click the 'Existing' radio button in the prompt screen and select the LOV from the drop-down.
1) You can add the 15 fact tables and the one dimension table in a Data Foundation. You can then create individual Business Elements off of this one Data Foundation (E.g: Sales BE, Orders BE, Bookings BE etc). These Business Elements can then be consumed in a Business View which eventually exposes these Busienss Elements to the report developer.
So a report designer interested in reporting Sales info only needs to select the 'Sales BE'.
Since CR doesn't support 'Contexts' unlike WebI, the Business View Manager doesn't support this too.
2) You don't need to create 15 separate Business Views - you just need 15 separate Business Elements and 1 Business View.
For easy maintenance of the LOV, I recommend creating another Business View that has just the one field from the dimension table. You might want to create a separate folder for storing all the objects related to this LOV for easy access and maintenance.
Another easy way to setup prompts, if you do not wish to waste time in creating all the objects in BVM is by creating a blank report > adding a dynamic prompt that points to the database field > saving the report to the repository (maybe your personal folder or favourites). This creates all the required objects for you that you can easily manage.
Hope this helps.