Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal Reports 2008 using Universe with multiple contexts

Status
Not open for further replies.

careymw

IS-IT--Management
Oct 8, 2010
41
US
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?
 
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
 
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.
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top