Cascading prompts in Business Views

[Former Member]

Dear Community,

Right now I'm working on crystal reports 2008. I use business views as my Data source.

For my business views. I use a stored procedure which has 4 parameters in it.

Namely Hospital ID, Clinic ID, Start Date and End Date.

List of hospital Id's with discription is comming from a seperate view. Hospital id is also present is StorePocedure

Also List of Clinic Id's with description also comming from another seperate view. Clinic id is also present is StorePocedure

I have Created a seperate Business Views just to Extract List of Values from it. For the reason I need to pass dynamic values to all the parameters.

As far as I know business views LOV will take 1 ID and 1 Descriptions for Lov.

this I can assign in Data foundation of that particular parameter as existing dynamic LOV.

Now the Problem is If I select hospital in the crystal report client, Then automatically it should filter all the clinics within this hospital upon selection of Hospital ID, But I get all the clinics id's irrespective of selection.

I would like to know from all experts is it possible?

I beleave there is some concept of Casceding parameters/prompts?

will cascading parameters/prompts will support in Business views.

Can some one provide me their valuable feedbacks?

Regards

ASHFAQ

[Former Member · Accepted solution]

Business views do support cascading LoVs. Table a look at the samples in the Sample folder of the Business View Manager (BVM). Also read the "Dynamic prompts overview" from BVM's help.

HTH,

Jason