Skip to Content
author's profile photo Former Member
Former Member

Cascading prompts in Business Views

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 25, 2011 at 02:54 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.