Crystal off multiple BEx Queries: How to consolidate multiple prompts into one for same field?
Posted on 2014-03-25
I have 3 BEx queries feeding one Crystal Report. Each of the BEx query has two prompt (variable) for time periods and City. I want Crystal to only prompt once for time period and City, and when user enters values… I want those values to feed all 3 BEx prompts.
How can I go about achieving this? Do I need to create prompts at Crystal level…. Or is there a workaround that can be used so that user sees only ( one prompt for time period and one for City) instead of 3 prompts for ‘time period’ and 3 prompts for ‘City’.
Please note that each BEx query is coming from a separate DSO.
Tool: Crystal Reports 2011