Dynamic datasource using JSP Crystal Report Viewer

[munnaabc]

Hi,

     I want to create a report using dynamic datasource. Datasource name should be passed as parameter or it should be picked up from some configuration file. Please help. Below is the content of sample crystal report viewer JSP:

<%@ page contentType="text/html; charset=UTF-8" pageEncoding="ISO-8859-1" %>

<%@ taglib uri="/crystal-tags-reportviewer.tld" prefix="crviewer" %>

<crviewer:viewer reportSourceType="reportingComponent" viewerName="CrystalReport1-viewer" reportSourceVar="CrystalReport1" isOwnPage="true">

<crviewer:report reportName="/Sample Reports/accounts.rpt" />

</crviewer:viewer>

Thanks & Regards,

Mohammed Masiuddin

[Private_Member_17892]

Hi Mohammed,

Did you get this to work ?

If so what did you do.

We need to do this as well

Regards

[former_member11696]

Hello,

Are you using our Java SDK? If so you should post to the Java SDK forum, or I'll move it.

As you know to set location to a new DB in Cr Designer you need to use the Set Location option in the Database Menu.

What this does is update the connection as well as the fully qualified table location. It can't be done dynamically, no place in the URL to do so.

If you are doing it an application then there are SDK API's to so.

Need more info.

Don