Hi, im about to write a report with CR instead of WebI, because the charts are better, so the data comes from universes.
For the report i have to merge two querys, which share the same set of parameters. But when i define the two querys whith the database expert with the parameters i have to fill in values for both querys. With webI, these parameters (prompts) get merged by the Text. I tried to figure out, if and how this could be done with CR, but couldn’t find a solution.
you can create conditions in universe with @prompt and use it in report… use the same @prompt in both conditions… i have used @prompts in universe derived table to pass the same date value in two different date fields… I think a condition with @prompt will help you…
Creating prompts works fine within one query, but what i need is to merge the prompts between querys, for example i want to combine the monthly data (query 1) with the some Year-End Data (query 2), so in both querys there is the prompt “Year”. What i get is a panel asking vor “Year” of query 1 and “Year” of query two, but what i want is to provide the year only once (cause different year parameters don’t make sense).
You need to stop thinking in traditional BO methods and think in Crystal methods. What your trying to do could be achieved by bringing the monthly data into the main report and parameterising that and then bringing the year end data into a subreport then link the subreport on the year parameter. I suspect the year end stuff will just sit in a the report header.
Although doing the above method depends on how much calculation you need to do with the 2 end datasets. Sounds to me like the year end is just a summary and cant be calculated against the monthly stuff as its at a different grain (level) anyway so the above would work ok.
(BOB member since 2008-05-13)
(BOB member since 2008-08-05)
(BOB member since 2006-02-08)