jhredd
asked on
Deploying Crystal Repoorts on many MSSQL Servers?
Hi, I' created some crystal reports and in my frontend I'm setting the table logon infor like:
CrystalReport.SetAllTables LogOnInfo( GLO:DSN,GL O:DSNDB,GL O:DSNUser, GLO:DSNPas sword,true )
where I am first priming the GLO:Variables.
IF this format does not look familiar it's because my front end app is developed with Clarion 5.5 Anyway it's looking for a DSN name but I want to be able to use a physical server name? We have about 30 servers in this intranet and I really don't want to have to create DSN's for them all. All of the servers are running MSSQL 2000 and all DB's have the same name and tables.
What is the best practices method of distributing my reports across the intranet? How should I approach this for the best solution.?
Many Thanks,
James
CrystalReport.SetAllTables
where I am first priming the GLO:Variables.
IF this format does not look familiar it's because my front end app is developed with Clarion 5.5 Anyway it's looking for a DSN name but I want to be able to use a physical server name? We have about 30 servers in this intranet and I really don't want to have to create DSN's for them all. All of the servers are running MSSQL 2000 and all DB's have the same name and tables.
What is the best practices method of distributing my reports across the intranet? How should I approach this for the best solution.?
Many Thanks,
James
ASKER
How can I design the report with the physical server info so I can call it at runtime by the physical server name?
Thanks
James
Thanks
James
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi, you are right of course. I had to use an ole db connection.
Thank You,
James
Thank You,
James
mlmcc