Report Caster Drilldowns using MRE Development

August 22, 2008, 06:12 PM

Mighty Max

I have been trying to get drilldowns to work in report caster reports distributed by email.
After doing some searching on the forums it was mentioned that you need to use:

SET FOCEXURL=http://servername/ibi_apps/WFServlet

I tried that but still nothing working.
Then after some more searching and reading there was someone stating that the fexes cannot be in MRE and need to be on the data server.
For clarity can someone tell me if this is true.
You cannot have drilldowns in report caster distributed reports if your fexes are in MRE.

Regards,
Max

August 22, 2008, 06:30 PM

susannah

Mighty
absolutely not true
fexes from mre can exec drilldowns from mre in Caster all the time
i use a pre-processing fex that
SET FOCEXURL ... exactly as you're doing.
when you send yourself the first car fex, with the drilldowns, crack it open (view source) and look at the exact form of the hyperlink on the drilldown.
This info should be very informative...
It should be a full url with the domain name of the source fex, and that's the same domain the drilldown fex should be in;
here's an example:
HREF="http://servername.nyumc.org:8080/ibi_apps/WFServlet?IBIF_webapp=/data&IBIC_server=EDASERVE&IBIWF_msgviewer=OFF&IBIMR_drill=X,dpmffina/dpmffina.htm&IBIF_ex=finpm_test2

..if you have images in your fex, add
SET BASEURL=
to that pre-processing condition, to locate your images...

This message has been edited. Last edited by: susannah,

August 25, 2008, 09:47 AM

Mighty Max

It seems like I am getting an incomplete url.
Here is the url from the emailed html report.

HREF="http://server-name/ibi_apps/WFServlet?IBIF_ex=app/cardrill.fex&CLICKED_ON=&COUNTRY=ENGLAND"

Here is the main report.

SET FOCEXURL=http://server-name/ibi_apps/WFServlet
TABLE FILE CAR
SUM
     COUNTRY
     CAR
     MODEL
BY COUNTRY NOPRINT
ON TABLE NOTOTAL
ON TABLE SET PAGE-NUM OFF
ON TABLE SET STYLE *
     UNITS=IN,
     PAGESIZE='Letter',
     LEFTMARGIN=0.250000,
     RIGHTMARGIN=0.250000,
     TOPMARGIN=0.250000,
     BOTTOMMARGIN=0.250000,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='ARIAL',
     SIZE=10,
     COLOR='BLACK',
     BACKCOLOR='NONE',
     STYLE=NORMAL,
$
TYPE=DATA,
     COLUMN=N2,
     FOCEXEC=app/cardrill.fex (COUNTRY = COUNTRY),
$
ENDSTYLE
END

Here is the drilldown.

-DEFAULT &COUNTRY = 'FOC_NONE'
TABLE FILE CAR
PRINT
	COUNTRY
	CAR
	MODEL
WHERE COUNTRY EQ '&COUNTRY';
ON TABLE SET PAGE-NUM OFF
ON TABLE SET STYLE *
     UNITS=IN,
     PAGESIZE='Letter',
     LEFTMARGIN=0.250000,
     RIGHTMARGIN=0.250000,
     TOPMARGIN=0.250000,
     BOTTOMMARGIN=0.250000,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='ARIAL',
     SIZE=10,
     COLOR='BLACK',
     BACKCOLOR='NONE',
     STYLE=NORMAL,
$
END

Is the syntax incorrect for

SET FOCEXURL=http://server-name/ibi_apps/WFServlet

Also within MRE I have to comment out in the main fex

SET FOCEXURL=http://server-name/ibi_apps/WFServlet

in order to get the drilldown to run properly otherwise I get this error : WebFOCUS was called with an invalid request.
Should this be happening?

Regards,
Max

August 25, 2008, 10:16 AM

susannah

make sure you give full url of servername and sometimes you need port#
you don't need that comment in mre
you need it in a separate little fex that sits up on your baseapp (always on path)
I call mine SETBATCH.fex
and it contains all the little things i need for report caster to run
and the first line is the SET FOCEXURL
here our servername would be
http://dbrpt01.nyumc.org:8080/ibi_apps etc.
So take a look at the way your full servername displays itself in a regular drilldown from mre
and make sure, then, that your SET FOCEXURL
in your reportcaster preprocessing condition looks the same.
You'll get it..

August 25, 2008, 12:00 PM

Mighty Max

Susannah,

I followed your directions.

1. Created a fex with

SET FOCEXURL=http://servername/ibi_apps/WFServlet

placed it in the baseapp.
2. Edit the Report Caster job to have it pre-process the newly created fex.
3. However, I still get the incomplete url.

http://server-name/ibi_apps/WFServlet?IBIF_ex=app/cardrill.fex&CLICKED_ON=&COUNTRY=ENGLAND

4. What am I doing wrong?

Some more questions.

1. Is there a way to look up the full server name that SET FOCEXECURL needs?
2. Do I have to include the webfocus system variables for the data server, mre domain, etc? In the SET FOCEXECURL.
3. You said, "you don't need the comment in mre".
Does this mean that if I run the main fex in MRE (no Report Caster) with the SET FOCEXURL uncommented that the drilldown should still work?
Because the drilldown only works in MRE if I comment SET FOCEXURL out. Is this another problem that needs to be looked at?

August 25, 2008, 12:46 PM

susannah

max,
my preprocessing condition runs this:

SET FOCEXURL = http://dbrpt01.nyumc.org:8080/ibi_apps/WFServlet

SET BASEURL = http://dbrpt01.nyumc.org:8080/

my castered report looks like this when i crack open the table from outlook -- it generates all the gibberish for me..

<span class='x10'>[URL=http://dbrpt01.nyumc.org:8080/ibi_apps/WFServlet?
IBIF_webapp=/data&IBIC_server=EDASERVE&IBIWF_msgviewer=OFF&IBIMR_drill=X,
dpmffina/dpmffina.htm&IBIF_ex=finpm_test3&CLICKED_ON=&LAUNCH=LIVE
&WFFMT=HTML&RAND=-1889&sh_dtl=0.&MYFUND=ALL]month[/URL]
</span>

don't put the SET FOCEXURL in your fex
put it as a preprocessing condition in your caster process. i have a feeling you're not doing that..
go to caster. edit the task, click the ADVANCED tab, click off the parms tab onto the PROCEDURES tab, and there put in the name of your preprocessing fex(you have slots for up to 2 preprocessing fexes), making sure its in the default app path.

This message has been edited. Last edited by: susannah,

August 25, 2008, 01:52 PM

Mighty Max

Susannah,
Thanks for being patient with me.
I am using SET FOCEXURL as a preprocessing condition in Report Caster.
The setbatch.fex is in my baseapp folder.
It looks like I am doing everything properly but there is a setting or configuration for MRE that is missing.
I see that you are using 7.66 could this be a 5.33 issue? Anyone?
Also, I moved both the main fex and the drilldown to the baseapp folder.
Then I modifed my Report Caster job to point to the new location and I also set the preporocessing condition to setbatch.fex.
Everything worked perfectly.
So this seems to be an MRE configuration issue.
The MRE system variables are not being added to the url which is why the drilldown is not working.

Regards,
Max

August 25, 2008, 06:03 PM

susannah

max, that's just too freaky for words.

crack open(view source) one of your emails and copy and paste here the exact drilldown...

here is a LINK to an article that suggests its complicated for older releases, but i swear i've used this since 524..i hated 53 and never went to it...

I searched on FOCEXURL and found some stuff, there's more than just this article.

This message has been edited. Last edited by: susannah,