Solved

Specifying database in URL for Crystal Web Component Server

Posted on 2004-10-26
417 Views
Last Modified: 2008-03-04
We are using the standard edition of Crystal Enterprise version 8 to deliver reports via our internet.  The reports are selected from a menu and parameters entered into a form.  This is then transformed into the appropriate URL using PHP.

I have read the documentation on "URL Commands for the Web Component Server" (ce8_url_commands.pdf) which has a section on "Logging onto your Database", but have not been able to get change the database from that which the report was originally designed with.

The documentation does specifically refer to "SQL or ODBC databases", but we are using OLEDB for our connection.

Can anyone tell me how to specify parameters in the URL that will allow me to specify a different database for OLEDB.

Thanks

H.
0
Question by:Hamlet081299
    7 Comments
     
    LVL 42

    Expert Comment

    by:frodoman
    Hamlet,

    To the best of my knowledge if the report is created with an OLEDB connection you cannot change it from the original database to a different one.  If this function is a requirement you may have to go with an ODBC connection.

    frodoman
    0
     
    LVL 5

    Author Comment

    by:Hamlet081299
    I've tried changing one of the reports to use ODBC, but I'm still not having much luck getting it to change databases through the URL.

    I've tried using both System DSNs and File DSNs, but I think I must have something wrong still.  I have two databases - one for test and one for production - "DBTest" and "DBProd".  I created system DSNs on the web server also called "DBTest" and "DBProd".

    Lets say a have a report "reportx.rpt", which has been created using "DBTest", and I want to display it using "DBProd" then I am using this URL ...
    reportx.rpt?user-DBProd.DBProd=sa&password-DBProd.DBProd=&promptex-TranType="ALL"

    Is that correct?

    H.
    0
     
    LVL 42

    Accepted Solution

    by:
    No, what I meant was that you can change the ODBC connection itself.  If changing db's is something you want to do then you'll probably want to use an ODBC connection that is specifically for this report and then you can change the ODBC connection itself to point to the new db.

    AFAIK you can't change the db through the URL itself - you'd have to manually change the odbc or run code to do so before calling the report.

    frodoman
    0
     
    LVL 5

    Author Comment

    by:Hamlet081299
    That won't quite work for me.  What I wanted is to have one set of reports that are reused against both a test and production database.  At any time different users will access the same report but for different databases, and I wanted to avoid having to make copies of every report and then change the connection.

    If you look at ce8_urlcommands.pdf, available from ...
    http://support.businessobjects.com/communityCS/TechnicalPapers/ce8_urlcommands.pdf.asp

    ... you will see that on page 11 it describes how to pass server name, database name, user and password via the url.  Maybe I'm mistaken but I took this to mean that I could CHANGE which database the report used.

    H.
    0
     
    LVL 42

    Expert Comment

    by:frodoman
    Hamlet,

    I'm very familiar with this document - unfortunately what you're looking at on page 11 is simply another way to pass the authentication credentials, it does not allow you to change the database.  That's documented here: http://support.businessobjects.com/library/kbase/articles/c2007327.asp.

    Sorry, but if you're using unmanaged reports and you want to maintain both a test and production version, you'll have to maintain two separate reports (unless of course you change the ODBC as we've already discussed but that probably won't work in this situation).

    frodoman
    0
     
    LVL 5

    Author Comment

    by:Hamlet081299
    Not the answer I wanted to hear, but probably the only answer.

    Thanks

    H.
    0
     
    LVL 42

    Expert Comment

    by:frodoman
    No problem - frodoman
    0

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT Security CISA, CISSP & CISM Certification

    Master the advanced techniques required to protect network resources from external threats with the IT Cyber Security bundle. Built around industry best-practice guidelines, the IT Cyber Security bundle consists of three in-depth courses.

    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 …
    Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    This video is in connection to the article "The case of a missing mobile phone (https://www.experts-exchange.com/articles/28474/The-Case-of-a-Missing-Mobile-Phone.html)". It will help one to understand clearly the steps to track a lost android phone.

    856 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

    11 Experts available now in Live!

    Get 1:1 Help Now