Skip to Content
author's profile photo Former Member
Former Member

Automatic generation of reports from templates on the Crystal Report Server

Hello,

We are new to Crystal Report Server so please feel free to correct me.

We are investigating the possibility of the automatic generation of reports from the templates on the Crystal Report Server XI Release 2 via the automatic retrieval of the data from certain databases and inserting this into the template on the Crystal Report Server

We are planning that our Java Application Server sends a message with particular parameters to Crystal Report Server each time an instance of a particular report should be generated.

Parameterlist contains Information, which template to use, for example a templateID, SQL-query or just u201CWHEREu201D-clause of the SQL-query as a String, to retrieve data sets, and some parameters which are needed to connect to a particular database.

On the Crystal Report Server side the following steps should be executed:

1. Connect to a specified Database (we use Oracle Database)

2. execute the SQL-query

3. insert the result data sets into specified template to generate a reportinstance

After the report is generated, it should be scheduled to one or more specified printers.

Has anyone programmed something like that before? Can anyone send a code snippet?

Thank you!

Best regards

Angelika

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 23, 2008 at 09:47 AM

    Is it possible to pass somehow the SQL-Query to Crystal Report Server XI, so that it retrieves the data sets from the specified database and inserts them into the template automatically?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 22, 2008 at 09:09 AM

    Angelika, I'm not sure if I understand you correct. Do you wish to alter the query or just the where clause? If you wish to alter the where clause only you can use parameters in the reports and set the parameter values once you schedule the report.

    Please read the "How to set parameter information tutorial" in our Developer Library for further information.

    http://devlibrary.businessobjects.com/BusinessObjectsXIR2SP2/en/devsuite.htm#en/Viewers_SDK/viewerssdk_java_dg_doc/doc/viewerssdk_java_dg/Tutorials42.html#1544363

    Further information about scheduling are available in "Schedule a report to run" - Business Objects Enterprise SDK

    http://devlibrary.businessobjects.com/BusinessObjectsXIR2SP2/en/devsuite.htm#en/BOE_SDK/boesdk_java_dg_doc/doc/boesdk_java_dg/SampleCode14.html

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 22, 2008 at 03:28 PM

    Another option would be to just build the report from scratch - or you could take an existing report, and modify it by either added a dataset, and then adding the fields to the report.

    This would be done using the RAS RCAPI SDK.

    Shawn

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.