Changing the Data Source from Java program

[former_member1336169]

Dear Sir/Madam,

I have multiple data base. Created one crystal report. From java program calling that report with passing different data source information. To achieve that , how may I do that ?, if possible, pls shared any experiences.

Thank You .

[former_member1336169]

Dear Sir/Madam,

Connection Name(Optional) in Oracle JDBC have been defined as IB3K_APP in reports(.rpt file).Refer attached image for more details. Our reports are deployed in Oracle weblogic server where a Data source is defined with the same name as IB3K_APP. So during runtime , based on the datasource logon details, the reports are connected.

But we have a usecase where we need to connect to different databases based on logged in user. Is there any way to change this optional connection defined in the reports to a new name?

i.e. We'll define all possible datasource connections in weblogic. eg. IB3K_USA_DS1 , IB3K_EU_DS2, IB3K_IN_DS3. During runtime, we want the reports to have Connection Name(Optional) set to one these values which we provide

If possible, please have any idea.

Regards,

Thinzar

[junge]

To change the datasource/login settings programatically you can use something like this:

https://github.com/souvikduttachoudhury/Crystal-Reports/blob/master/src/com/businessobjects/samples/...

[former_member1336169]

Thanks Peter . Will try !

[former_member11696]

You can use CR for Eclipse which you can get from here:

https://wiki.scn.sap.com/wiki/display/BOBJ/SAP+Crystal+Reports+version+for+Eclipse+-+Downloads

[former_member1336169]

Thanks Williams