Skip to Content
0
Former Member
Jun 10, 2009 at 12:59 PM

Using a Universe in Crystal

31 Views

I don't know if this belongs under this heading, but I have created several data universes that all point to the same datasources. Each one is a different subset of tables based on the content. For example, I have an Airport universe that contains several classes and objects related to airport information...and a Vendor universe that contains several classes and objects related to vendor information, etc.

When creating a query in Crystal, each universe gets a separate query, and the end user had to know how to link those queries. In order to make this a more intuitive process, I have combined all the data universes into one. There are different contexts and alias to eliminate all loops. However, when you include objects from multiple classes in your Crystal query, you get the following error:

Query generated multiple SQL statements, however multiple SQL is not supported in Crystal Reports Query Panel

I understand that data universes are primarily for use with Webi. But we do not have Webi. So my question is, is the problem I am having in the design of my data universe, or in trying to use Crystal to create the queries?

I would appreciate any input from anyone.

Thanks,

Lee