Focal Point
[SOLVED] Reportcaster ID variable

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/2987043186

March 18, 2016, 06:52 PM
jlsnyc
[SOLVED] Reportcaster ID variable
Is there a way to get the REPORTID variable. When you submit a schedule it give you the JOB ID like Jaac052e4j27a7j4749ja85cj40e13cb8502d How can I capture this value into an ampa variable.

I will ultimately use that variable to query the botlib table to get the version # for the schedule

This message has been edited. Last edited by: Tamra,
March 18, 2016, 07:52 PM
Dan Satchell
I suggest creating a focexec with just this one command:
-? &

Then schedule and run it via ReportCaster. Check the job log to see what amper variables are available.


WebFOCUS 7.7.05
March 20, 2016, 04:59 PM
Waz
Yes, there should be an &DS??? variable


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

March 21, 2016, 08:34 AM
CLH
&DSTJOBID and &DSTSCHEDID


Webfocus 8.0.7 on Windows
March 21, 2016, 12:38 PM
Kevin W
Or go to the Task tab and pass it as a job parameter? Although the previously provided suggestions are probably what you are looking for.


WebFOCUS 7.7.05 (Someday 8)
Windows 7, All Outputs
In Focus since 1983.
March 21, 2016, 01:00 PM
jlsnyc
I tried this from Reportcaster Scheduler -TYPE &DSTJOBID and -TYPE &DSTSCHEDID and the error A Value is missing for &DSTJOBID and &DSTSCHEID

No report to distribute


How do I access these variables?
March 21, 2016, 05:21 PM
Waz
What version of WF are you using ?

Please update your signature


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

April 05, 2016, 03:09 PM
Tamra
Hi jlsnyc,

WebFOCUS 8.1.03 contains the following variables for Report Caster:

ReportCaster Internal Variables


Also, as suggested by Waz, please update your signature. This will help us help you in the future since the product is changing with each new release.


Thank you for participating in the Focal Point Forum.

Kindest regards,
Tamra Colangelo
Focal Point Moderator - Information Builders Inc.
* Summit 2016 – June 13-17 in Reno, Nevada  - http://www.informationbuilders.com/events/summit


WebFOCUS 8x - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5