Cascading Prompts?

building reports crystal reports
1

Hi, I am trying to do a cascading prompt but I can’t seem to get it working the way I want it to. What I basically want to do it have one prompt for the filter for the next prompt. But the first prompt I don’t want all data from the table being pulled to populate it. So for example, I have 100 schools but I only want to show 15 of them. Once the school is selected I then want the next prompt to prompt the user for a sport that is offered at that school. Any ideas? Is there another way of doing this besides using cascading prompting?? Thanks.

rowemike (BOB member since 2008-07-17)

2

Hi,

 The answer for you question to show only 15 schools in the first prompt can be acheivable by just creating a view at the database side with a filter on the number of schools and building the parameter on the field from the view.

Regards

ay1224 :us: (BOB member since 2007-07-30)