Crystal Reports 2008 using Universe with multiple contexts

[careymw]

Hi
I'm developing a Crystal Report (2008) based on a universe (Oracle). In this universe there are derived tables and multiple contexts being used. I'm getting errors in Crystal that I can't have multiple SQL returned. Does anyone have any suggestions on how we can resolve this issues?

 

[hilfy]

You would probably have to create multiple universe queries in the report - one for each context that you're using. If the universe is being used by Crystal only (and not for Webi reports) try going to the SQL tab in the Universe Parameters and turning off "Allow selection of multiple contexts", export and try to create the report again. This will show you which dimensions/measures are causing the issue.

-Dell

DecisionFirst Technologies - Six-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com

 

[careymw]

Thank you for the suggestion. The universe is also being used by WEBI reports. We decided to use a COMMAND in crystal to call the fields that we need. So far it is working appropriately.

 

[hilfy]

Commands are my preferred method of getting data - I've run into too many problems trying to use universes.

-Dell

DecisionFirst Technologies - Six-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com