[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Specifying database in URL for Crystal Web Component Server

Posted on 2004-10-26
7
Medium Priority
?
439 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
Comment
Question by:Hamlet081299
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 42

Expert Comment

by:frodoman
ID: 12417518
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
ID: 12417643
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:
frodoman earned 1000 total points
ID: 12422029
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
How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

 
LVL 5

Author Comment

by:Hamlet081299
ID: 12428682
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
ID: 12432423
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
ID: 12439385
Not the answer I wanted to hear, but probably the only answer.

Thanks

H.
0
 
LVL 42

Expert Comment

by:frodoman
ID: 12439732
No problem - frodoman
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Suggested Courses

650 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