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

How to get the schedule report using Java sdk ?

Hello.

Problem

In my one requirement ,I want to schedule the report using Java sdk.

For that I made one sample application and write some code for the schedule.\

Snippet - infoStore.schedule (webiDocs);

Using these I am getting the message report has been scheduled ,

But I want in which location report is stored ? How to get that schedule report using java sdk ,

my requirement is to display scheduled report into the JSP , also want Excel and PDF formant .

Please help me asap

Thanks and Regards,

Amit Patel

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on May 20, 2013 at 04:41 PM

    Hi Amit,

    When you schedule a report through java sdks or through Infoview/CMC, the scheduled instance is stored tin the OutputFileRepository and can be seen in the Instancemanager in the CMC or under the report's history.

    Now if you want the information related the scheduled report in to your .jsp, then you have to use a query in the .jsp something like

    "select * from ci_infoobjects where si_instance=1 and si_parentid=<Main report id>"

    - The above query will get get all the scheduled report instances for that particular report whose id we have used as parent id.

    - After which you can process the instances according to your need.

    - If you fire the same query in the query builder, you will get a list of all the report instances.
    - In the properties, there is a property SI_PATH which will let you know the physical location where the instance is saved.


    Let me know in case you require more information.

    Thanks,
    Prithvi

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 21, 2013 at 09:38 AM

    Hi Amit,

    I guess you are scheduling the report using Java SDKs and unable to see the same instance of the report which is scheduled from the code.

    If I understood it correctly then we need to check the Schedule frequency of the report ,Time needs to execute the report, to display the instance of the same report from the same code.

    Assumming the report is scheduled to run as Now and it's execution time is less, you would need to check below steps in your code

    1. Call Schedule method to schedule the report

    2. Use some Java logic to keep the thred waiting till the time report gets scheduled.

    3. Either you can retrive the latest instance of the report as mentioned by Prithviraj or you can use URL reporting to display the lates instance of the report.

    Please let me know if it helps.

    Thanks,

    Swati

    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.