Auto export

[thysonj]

We have client requesting that they be able to open up their reports directly in an Excel or PDF format. This presents the problem that the reports must first be generated and then exported. Does anyone know how we could go about this. Essentially they want to be able to click a link that currently generates a report and have it generate it it then export it and display the exported report all in one transparent process. We are running Enterpise 9 to generate the reports via the web.

Any Ideas/Gudiance????

 

[Turkbear]

Hi,
If they are willing to have it mailed to them on a regular schedule, you can set it up in the CMC to E-mail it in the desired format.
If they want to run it whenever they want, use the URL method of calling it like:

[URL unfurl="true"]http://<YourCeSeverName>/viewrpt.cwr?id=179&apsname=Guest&apsauthtype=secEnterprise&promptex-EmpNbr=00000000&CMD=EXPORT&EXPORT_FMT=U2FPDF:0[/URL]

This passes the authentication over the web, so use a limited account - Pass the ReportID and any parameter values, if any are needed.( in the example that is the &promptex- part)

A shortcut to the URL will generate a PDF of the report when clicked..

 

[thysonj]

I had just discovered the EXPORT&EXPORT_FMT=U2FPDF:0 param when you answered. I now need to know if it possible to do the same thing but export to an Excel file.

 

[Turkbear]

Hi,
I believe so, but I do not have the EXPORT_FMT specs handy at the moment, but the docs should have it..