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 strongm 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. tfernand

    Migrating from Dev to prod using ODBC DSNs

    Hi Dave, If you could send me some code that will change around the schema that would be super. thanks, -- T
  2. tfernand

    Migrating from Dev to prod using ODBC DSNs

    Hi synapsevampire, You are correct about the cheat in CR 8.5 . Do you or anybody know of a corresponding cheat/utility in CR 9 ? thanks -- T
  3. tfernand

    Migrating from Dev to prod using ODBC DSNs

    So I have a bunch of reports created on a dev machine using ODBC DSNs that point to a dev environment. In order to migrate them over to our production Crystal server, I created a ODBC DSN with the exact same name on this server as the dev DSN on the dev machine. The DSN on the prod Crys server...
  4. tfernand

    Changing db connection when using commands in CR9

    Hi Geoff, Did you figure out how to do this finally. I am in a somewhat similar situation though a little bit different. I created a report using an ODBC connection that connects to a dev database and I now want to change it around to point to a production database. Any help would be much...
  5. tfernand

    Changing the database for a command in Crystal 9

    Brian, I am using ODBC. I guess I'm not explaining this right . Let me try this again. So I created a report in Crystal 9 using the "Command" feature that lets u enter complex SQLs for report generation. I created this report to run against a development database. So I created a ODBC DSN for...
  6. tfernand

    Changing the database for a command in Crystal 9

    thanks for the post Gary. How do you get it to point to a different database. When one uses tables, we use the Set Datasource Location to change the database that the report accesses. How do u do the same thing for a command ?
  7. tfernand

    Changing the database for a command in Crystal 9

    thanks mikalm, I am not using VisualBasic or any other program to interface with Crystal. I am directly using Crystal reports. I'm guessing the solution u have provided works for a programming language interface with Crystal. Thanks anyways for the input
  8. tfernand

    Changing the database for a command in Crystal 9

    Hi All, So I created a report in Crystal 9 using the "Command" feature that lets u enter complex SQLs for report generation. I created this using a development database. Now, its time to migrate it over to the production database. So i try using "Set Datasource Location" but it doesn't seem to...
  9. tfernand

    Totals across subreports

    Hi All, How do I pass a total value from a subreport to the main report. The idea is to take the totals from the subreports and total it up in the main report. If there's a better way of doing this other than what I'm thinking please let me know, thanks, -- Tony
  10. tfernand

    Changing data source efficiently

    thanks for the answers, will this util for Crystal 9 or is it too specific for Crystal 8 ?
  11. tfernand

    Changing data source efficiently

    All, When we develop in Crystal reports, we use a development database as a data source. When its time for cutover is there a fast way to change the data source to be the production database. Right now, the only thing I could think of is going into each report and changing the data source to...

Part and Inventory Search

Back
Top