• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 464
  • Last Modified:

Specifying database in URL for Crystal Web Component Server

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
Hamlet081299
Asked:
Hamlet081299
  • 4
  • 3
1 Solution
 
frodomanCommented:
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
 
Hamlet081299Author Commented:
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
 
frodomanCommented:
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
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Hamlet081299Author Commented:
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
 
frodomanCommented:
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
 
Hamlet081299Author Commented:
Not the answer I wanted to hear, but probably the only answer.

Thanks

H.
0
 
frodomanCommented:
No problem - frodoman
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now