What is the recommended way to combine multiple Queries with variables in one Crystal Report without selecting the same variable values for each query?
We have tried to do it with Crystal subreports using the SAP task bar. But for each query the same variables come up again. Is there a way to give over the variable values from one query to the other with Crystal reports features?
Is there another way to use the database assitant (MDX Queries) and to join the queries in one report to get the required result (to type in the same varable value only once)?
Some backround information:
We don't want to implement the variables in Crystal itself, because we use hierarchy variables (another problem).
We use XI 3.1 in combination with SAP BI 7.0.
Best regards
Oliver