One Crystal Report - many databases

Discussion in 'ASP .Net' started by =?Utf-8?B?QW5kcmVhcw==?=, Feb 2, 2007.

  1. Our company have one asp.net 2.0 web application using c# as code behind and
    one C++ windows application. Both applications are using Crystal Reports (v
    10) as report engine.

    The web app. just started using crystal report and can access and show the
    report but for now EACH report has to be hardcoded to one customers database.
    We would like to use same reports in the web app as the win app use which
    dynamically connect to the database with a ODBC connection.

    We have solved the problem in the win app using different startup-scripts
    for every user. The script changes the win. registry for the ODBC the report
    use. So in the report all we have to do is to set the connection to the
    database with this ODBC connection.

    The question is how do we do something similiar in our web application? As I
    understand we cannot use a ODBC on the web server.

    We cannot have the reports like this since this would require us to modify
    1300 * 50 reports for the web and just 1300 reports for the win app so please
    help us!
    =?Utf-8?B?QW5kcmVhcw==?=, Feb 2, 2007
    #1
    1. Advertising

  2. =?Utf-8?B?QW5kcmVhcw==?=

    sloan Guest

    You design the reports to work with strongly typed datasets.

    The dataset has to be consistent among customers, but you can populate it
    from any specific customer database.

    see
    http://scottonwriting.net/sowblog/posts/2148.aspx




    "Andreas" <> wrote in message
    news:...
    > Our company have one asp.net 2.0 web application using c# as code behind

    and
    > one C++ windows application. Both applications are using Crystal Reports

    (v
    > 10) as report engine.
    >
    > The web app. just started using crystal report and can access and show the
    > report but for now EACH report has to be hardcoded to one customers

    database.
    > We would like to use same reports in the web app as the win app use which
    > dynamically connect to the database with a ODBC connection.
    >
    > We have solved the problem in the win app using different startup-scripts
    > for every user. The script changes the win. registry for the ODBC the

    report
    > use. So in the report all we have to do is to set the connection to the
    > database with this ODBC connection.
    >
    > The question is how do we do something similiar in our web application? As

    I
    > understand we cannot use a ODBC on the web server.
    >
    > We cannot have the reports like this since this would require us to modify
    > 1300 * 50 reports for the web and just 1300 reports for the win app so

    please
    > help us!
    >
    >
    sloan, Feb 2, 2007
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. James Wallace
    Replies:
    0
    Views:
    1,039
    James Wallace
    Oct 17, 2003
  2. =?Utf-8?B?SmFpZ2FuZXNo?=

    Reading report content using Crystal Report Viewer XI

    =?Utf-8?B?SmFpZ2FuZXNo?=, Jan 4, 2006, in forum: ASP .Net
    Replies:
    0
    Views:
    1,157
    =?Utf-8?B?SmFpZ2FuZXNo?=
    Jan 4, 2006
  3. Learner
    Replies:
    1
    Views:
    1,092
    Richard Dudley
    Jan 11, 2006
  4. Ken North
    Replies:
    0
    Views:
    586
    Ken North
    Jul 14, 2005
  5. Comfort
    Replies:
    0
    Views:
    537
    Comfort
    Oct 18, 2004
Loading...

Share This Page