Cascading prompts in Business Views
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?
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.