Reg : Cascading DynamicParameters in Crystal report - BO

building reports crystal reports
1

Cascading parameters will support - the listed parameter values change based on the value selected for one of the other parameters.

For example, if Country, State and City parameters are used, the user will simply:

Select the Country, this will automatically refresh the State parameter ans City Parameter list with values for the selected country.

Run the report

Usually we will do as below but i no need that :,

Select the Country, this will automatically refresh the State parameter list with values for the selected country.

Select the State, this will automatically refresh the City parameter list with values for the selected State.

Select the City

Run the report

Please do the needful.

Thanks.
YogeshKumarC

yogeshkumar (BOB member since 2010-12-29)

2

Business View Manager is the answer for you.

BO_Chief :us: (BOB member since 2004-06-06)

3

BO_Chief,

IN BVM could you please explain me how to create the dynamic Cascading for th below req.

Country(Level1) Region(Level2) City(Level3)
USA AL Huntsville

If i click the Country USA both Region and City should get updated based on the country prompt.Level 2& 3 should update based on Level 1.

Using BVM After creation the Data Connection,Data foundation,Business Element,Business view how we should add the LOV for the above req.
Please explain

yogeshkumar (BOB member since 2010-12-29)

4

If you have created BV already (hope you have selected all the columns : country, region, city in Business Elements).

Following are the steps to create an LOV.

  1. Logon to Business View Manager
  2. File --> New --> List of Values
  3. Select the Business View (on which you want to create this LOV).
  4. In the LOV Editor :
    Move country, region, city from Available fields to List of Value Fields.
  5. Give a Name and Click OK to save the LOV. It will save in the repository.

Now, to use it in a Crystal report, follow these steps:
a) Open a Crystal report in Designer Tool, (Logon the BO Enterprise to use LOV from repository )
b) Create a parameter, Give a name to it, Edit parameter.
c) Choose Dynamic, Choose Existing options
d) Select the LOV that you have saved in step (5) above.
Note : while creating parameters, if you click Country, region and City. It will insert 3 parameters into your Crystal Report)
e) Add the parameters to the report (Design window).
f) Add the correct ‘Record Selection’ formula by correctly referring Country, region and city parameters to work correctly.
g) Test the report.

If everything works fine, Export to BO Enterprise and test in Infoview.

BO_Chief :us: (BOB member since 2004-06-06)

5

Hi Guys.

We met a problem that our CR report have Cascading Dynamic Parameters and Static Parameters; When we tried to schedule the report and click EDIT button for static parameters It will take us to one Cascading Dynamic Parameter.
For example;
I want set parameter ;“A; But when we click "A;the page will go in to page for setting parameter “B”.

This error happened after we installed the package for BO XI3.1

Our BO environment is XI3.1 and use crystal report 2008.

cihtonywq (BOB member since 2011-01-04)

6

How and where can I obtain Business View Manager?

jim_chance (BOB member since 2012-03-18)