cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Need help navigating or using the PTC Community? Contact the community team. X

Invoking a Cognos report, and accessing the output that is generated

crosato
2-Explorer

Invoking a Cognos report, and accessing the output that is generated

We are currently creatinga new softtype of a WTDocument (called a CD), through a ChangeRequest workflow, but we're currently at a sticking point due to the fact that we are trying to create the content by running a report with Cognos. Basically the steps are:

  1. CR created.
  2. At a certain step, the user createsthe CD with all the required metadata, butminusany content.
  3. Once all the metadata is entered, we planned to use a WF expression to kick off a Cognos report. This report will use the CD's metadata to create the CD's primary content.
  4. The CD's primary content will go through reviews, and blahblahblah.

We just started looking at Cognos, literally when this project started, and the closeset thing to training was a demo months ago. The part we are currently stuck on is simply if we can invoke Cognos behind the scenes, without user input,to run the report and save the output to a temp location where we grab it and load it to the CD as the content. Is running a Cognos report behind the scenes even possible? It seems the more we look into it, that it requires user interaction at report runtime.

1 REPLY 1
jessh
12-Amethyst
(To:crosato)

It looks like you need

public void executeReport( Report report, Map params, Integer
reportFormatType, OutputStreamProxy output )
throws WTException;

in com.ptc.windchill.enterprise.report.ReportService to be a supported API.

It currently is /not /-- quite probably because OutputStreamProxy is
also not a supported API.

Chris Rosato wrote:
>
> We are currently creating a new softtype of a WTDocument (called a
> CD), through a ChangeRequest workflow, but we're currently at a
> sticking point due to the fact that we are trying to create the
> content by running a report with Cognos. Basically the steps are:
>
> 1. CR created.
> 2. At a certain step, the user creates the CD with all the required
> metadata, but minus any content.
> 3. Once all the metadata is entered, we planned to use a WF
> expression to kick off a Cognos report. This report will use the
> CD's metadata to create the CD's primary content.
> 4. The CD's primary content will go through reviews, and blahblahblah.
>
> We just started looking at Cognos, literally when this project
> started, and the closeset thing to training was a demo months ago. The
> part we are currently stuck on is simply if we can invoke Cognos
> behind the scenes, without user input, to run the report and save the
> output to a temp location where we grab it and load it to the CD as
> the content. Is running a Cognos report behind the scenes even
> possible? It seems the more we look into it, that it requires user
> interaction at report runtime.
>
>
Announcements


Top Tags