How to configure Crystal Report from Test DB to Production DB

Advertisement

Hi,
I have a VB/asp.net application that is currently using Oracle DB.
Now, I'm creating a new Crytal report that will connect using any userID, password, database, servername on runtime.
When I created the Crystal Report I used the Oracle OLE/DB connection using the test database logon information now I would like to make this  dynamic at form load event which I have my crystal report viewer configured and then pass the dataset regardless if it is coming from test or production database.
Now, at form load connection using the test database I can see the report properly which I provided with the same logon information when the crystal report was created but when I switch the login using the production database, it doesn't get the correct datasource and logon information and it still uses the test datasource.
I would appreaciate if you can give me a solution or any links of the previous threads that has similar issue with resolution or any sample that may help.
Thank you,
Ryan

Advertisement

Hi Ryan
I'd start with these samples:
csharp_win_dbengine.zip / vbnet_win_dbengine.zip
csharp_win_subreport_logon.zip / vbnet_win_subreport_logon.zip
Link to the samples and others is in this wiki: Crystal Reports for .NET SDK Samples - Business Intelligence (BusinessObjects) - SCN Wiki
Next, I find the Crystal Reports for Visual Studio 2005 Walkthroughs to be an absolute gem (and it applies to all versions of CR and VS).
And of course, the developer help files:
SAP Crystal Reports .NET SDK Developer Guide
SAP Crystal Reports .NET API Guide
Now, one thing you don't mention is which APIs you are using; CR, or RAS - both of which may be available to you depending on the version of CR and VS you are using... RAS Developer Help files are here:
Report Application Server .NET SDK Developer Guide
Report Application Server .NET API Guide
The RAS APIs are a bit more complicated, but way more powerful. And there is even a utility that will write the DB logon code for you:
KBA: 1553921 - Is there a utility that would help in writing database logon code?
Finally, don't forget to search this SCN Space. Search box is in the top right corner. I find using short search string is best. E.g.; 'crystal net logon' will return a number of KBAs (notes), wikis, blogs, etc., etc.
- Ludek
Senior Support Engineer AGS Product Support, Global Support Center Canada
Follow us on Twitter

October 11, 2015

How to configure Crystal Report from Test DB to Production DB

Hi, I have a VB/asp.net application that is currently using Oracle DB. Now, I'm creating a new Crytal report that will connect using any userID, password, database, servername on runtime. When I created the Crystal Report I used the Oracle OLE/DB con

How to invoke crystal reports from Oracle forms 11g R2 along with passing p

How to invoke crystal reports from Oracle forms 11g R2 along with passing parameter to it. how to pass parameters to crystal report, please help.how to pass parameters to crystal report, please help.This would entirely depend on crystal reports and y

How to open Crystal Reports from Business Content Ext BW

Hi friends, I have activated 0CR_FIAA_M20_Q0007 Crystal Reports from Business Content Ext BW and I have configurated BW_Publisher services in BW but I do´t see reports in /CRYSTAL/RPTADMIN. I check RFC connection and it´s ok Here I can´t get a role a

How to configure Crystal Reports 2008 and IIS7 and Windows Server 2008?

I have downloaded and installed the trial for Crystal Reports 2008 on our Windows 2008 server.  I can open Crystal Reports on the server just fine, but I get HTTP 500 errors when I attempt to view a report hosted on that server via the web. As far as

How Can I call Crystal report from R3?

Hi experts,   How Can I call Crystal report from R3?Hi Bill, Can you please be specific and could you please provide the steps Thank youRead other 5 answers

How do I open a Crystal Report from Microsoft Access?

I'm looking for step-by-step instructions on how to launch a Crystal Report from a Microsoft Access application (for a dummy like me). My Crystal Report uses a connection to the Access database as the data. I have Microsoft Access 2002 with Microsoft

How to delete all the crystal reports from SAP B1 ?

Dear Experts, I have one problem and I need to Delete all the Crystal PLD's and Crystal Reports from SAP B1. I can delete a PLD or Report using delete option from Report and layout manager or layout designer. But I need to select delete option for ea

Printing Crystal Reports from UDO form

Dear Experts, I want to open a Crystal report from an addon. I've already found [the following thread|http://forums.sdn.sap.com/thread.jspa?threadID=2039424&start=0&tstart=0] and the [mentioned blog post|http://www.sdn.sap.com/irj/scn/weblogs?blog

How to use crystal report in php

hello i need help for how to use crystal report for view the database report spacilly crosstab report i need it very much to complete my project ill be very thank full for help from farooqHello sir i am sudeep and i need to deploy crstal reports in p

How to do crystal reports in bi-7 i need  clear steps

how to do crystal reports in bi-7 i need  clear stepsHi, Please read the following documents. I am sure that this is going to help you in creating crystal reports. Regards, Subha Pls grant me points if it is found useful Use The Reporting Agent allow

Crystal report from JSP using the JRC

Hi, I am trying to call crystal report from JSP using the JRC. But i am getting the Error as 'Logon Failed'. my web.xml entry is <env-entry> <env-entry-name>jdbc/Test</env-entry-name> <env-entry-value>!oracle.jdbc.driver.OracleDriv

How to integrate Crystal Report Server and J2EE platform

Hi, It's my first time using Crystal Report, so I don't know exactly how I should start... As what i've searched around, there is a method of generating crystal report from a JSP file. By this way, everything will be handled within the application se

Open a crystal report from WAD with passing  the variables values

Hi, I need to know is there any way to link SAP WAD to crystal reports (open a crystal report from WAD)and pass the values of the variables which are entered in the Web App. (e.g. Customer id,year) should be passed to the Crystal Report. Maybe we nee

Can't view Crystal Reports from BW

Hi, I'm installing SAP Integration Kit XI 3.1 SP3 with IIS.  I am able to publish reports from BW to BOE but not able view them from BW.  I followed the documentation to use report/report_view.aspx to define the viewer application in Content Administ

Calling Crystal Reports from Oracle Forms 10G

Hi everyone, I am trying to call a crystal report from Oracle Forms 10G. I have a button on my Form which when clicked calls a Crystal Report which the uaser then wants to save as a PDf file. Can someone please send me the code to do this and also th

How do I launch report from menu using RUN_REPORT_OBJECT?

Hi all, Re: How do I launch report from menu (and have it print to the screen) using RUN_REPORT_OBJECT? I am using Oracle 9iAS on Windows 2000 and I have a similar problem with launching reports from the menu. The application should call the report v

Duplicate Object Name Error When Publishing Crystal Reports from BW to BOE

Hi, We recently upgraded our systems (all client and server) to SP2.7 in order to solve a problem with saving Crystal Reports to BW.  Now we are experiencing a new error when trying to publish a Crystal Report from BW to BOE (either all in one step f

How to run a report from oracle 10g form in .csv format

dear all, how to run a report from oracle 10g form in .csv format? i've already run in pdf & excel format. i'm using SET_REPORT_OBJECT_PROPERTY (ro_report_id, report_desformat, 'PDF'); --for pdf SET_REPORT_OBJECT_PROPERTY (ro_report_id, report_desfor

Problem opening Crystal Report from SAP GUI through VPN

Hi Everyone,   I am facing an issue with opening the crystal report from SAP BW Role menu(SAP GUI). The issue is only with the BW Users who are connecting to the Client systems through VPN. All the settings are done perfectly in the Transaction /CRYS

Show Crystal Report (from BW) in SAP EP

Hi Everybody, I am trying to show a Crystal Report in the SAP enterprise Portal. The Report resides in BW, so I do not want to go through BOE or OpenDocument command. All threads I found on SDN relate to showing a crystal report from the BOE in the S