How to configure Crystal Report from Test DB to Production DB
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.
October 11, 2015
View Thread Other 7 Replies on scn.sap.com
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.
Senior Support Engineer AGS Product Support, Global Support Center Canada
Follow us on Twitter
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 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
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
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
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
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
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
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
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 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
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
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
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
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
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
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
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
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
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
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