Deploying Crystal Repoorts on many MSSQL Servers?

Posted on 2004-11-28
Last Modified: 2008-02-01
Hi, I' created some crystal reports and in my frontend I'm setting the table logon infor like:
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,
Question by:jhredd
    LVL 100

    Expert Comment

    I haven't seen the ability to use a physical server name except if you use an ADO or OLE connection.  Apparently your reports are built using a dsn connection and in that case you will need to build a dsn to all databases


    Author Comment

    How can I design the report with the physical server info so I can call it at runtime by the physical server name?

    LVL 100

    Accepted Solution


    Author Comment

    Hi, you are right of course. I had to use an ole db connection.

    Thank You,

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
    There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now