Skip to Content
avatar image
Former Member

Crystal-Universe XI R2

1. How do I know my report is connected to the right Universe? On CMC it says Universe Query as Data Source. But it doesn't say which Universe it is connected to.

Even when I import the report to Crystal Client, it doesn't say which Universe it is connected to. It only gives the login Info.

2. How can I add new columns to the report that is connected to Universe?

When I update the universe query - Crystal Set Data source, it is asking for all list of Objects and I have to manually choose the objects. What if the report has many columns?

Besides manual selection of Objects and matching them, updating the data source is affecting the crrent report Parameters. I have to recreate them after the re-point.

Is there any workaround?!!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Nov 15, 2010 at 09:38 PM

    Open the report in Crystal Designer

    Go to Database Expert

    Right click on the command in the right pane and select Edit Command

    The Universe Name should be at the top of your object list in the left pane

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello,

      The query I included above does show universes associated with a Crystal Report (in my case SI_LOGON_INFO >> SI_LOGON1 >> SI_SERVER). I however only tested on XI 3.1.

      Also, a Select * probably returns much more information than you need/want.

      I don't believe there is any other method to pull this information.

      Best,

      Srinivas

  • Oct 13, 2010 at 09:50 PM

    Moved to Universe Designer forum

    Add comment
    10|10000 characters needed characters exceeded