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!

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

Search results for query: *

  1. JeffAnderson

    CR9 Changing Datasource Location on Rpt w/SQL Command

    Just wanted to let you know that I figured it out and to thank you for your help. This was caused be two things, both related to the repository: 1. Some of the SQL commands had been connected to my repository. Even if I disconnected before sending them to the client, they still thought they...
  2. JeffAnderson

    CR9 Changing Datasource Location on Rpt w/SQL Command

    Unfortunately, no. The reports I created that do not use SQL commands access the exact same set of tables, and they can be loaded without problem. It only occurs when trying to set datasource location for reports containing SQL commands.
  3. JeffAnderson

    CR9 Changing Datasource Location on Rpt w/SQL Command

    Yes he does have CR9 on his desktop.
  4. JeffAnderson

    CR9 Changing Datasource Location on Rpt w/SQL Command

    Do you put this statement inside the SQL command before the query? Thanks again.
  5. JeffAnderson

    CR9 Changing Datasource Location on Rpt w/SQL Command

    I created reports for a client on a local copy of their Oracle database. Some reports contains SQL commands and some did not. When I sent them to the client, there were no problems setting datasource location on those without SQL commands. However, when they try this on the reports with SQL...
  6. JeffAnderson

    CR9: Trying to Set Datasource Location /w rpt containing SQL Command

    I recently wrote several reports in CR9 using SQL commands. I wrote them on a direct copy of the client DB, so the schema I used is identical. I sent the reports to my client , who the tried to open on his network and use 'Set Datasource Location'. When the report attempts to establish...

Part and Inventory Search

Back
Top