Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

Hi! Can someone please tell me how to get the below CAR hold...


Brandon Andrathy

Recommended Posts

Hey Chuck, thanks for your response. The trouble there is managing all the parameters within the html form which i was hoping to not have to do. If thats the easiest/best solution then I guess well run with that. thank you.

I figured out another solution but figured itd still be worth it to see if there was a way to do it for my own knowledge in the future.

Link to comment
Share on other sites

I was able to get it to work like this:

TABLE FILE car

SUM SALES

BY COUNTRY

ON TABLE HOLD AS foccache/car FORMAT HTML

END

-HTMLFORM BEGIN

<html>

<head>

</head>

<body>

<iframe id="iframe1" src="/ibi_apps/run.bipBIP_REQUEST_TYPE=BIP_RUN&|BIP_folder=IBFS%253A%252FEDA%252FEDASERVE%252Ffoccache&|BIP_item=car.htm" height=100%>

</iframe>

</body>

</html>

-HTMLFORM END

Link to comment
Share on other sites

Nice technique/model David!

I knew about parking data in FOCCACHE, but didnt know about parking a report there, and then being able to call it with a URL.

At our site we use WebFOCUS RESTful Web Services to make our calls back to WebFOCUS. So, I changed the BIP request to a RESTful request.

-SET &RANDOMNUMBER = RDUNIF(D5) * RDUNIF(D5) * 10000;

-SET &SRC = '/ibi_apps/rs/ibfs/EDA/EDASERVE/foccache/HLDCAR.htmRANDOM=' || &RANDOMNUMBER;

-SET &COUNTRY = 'FRANCE';

-*

TABLE FILE CAR

"Yet Another CAR Report"

"As of &DATE at &TOD"

SUM SALES/D12C

BY COUNTRY

IF COUNTRY NE &COUNTRY

ON TABLE SET HTMLCSS ON

ON TABLE HOLD AS FOCCACHE/HLDCAR FORMAT AHTML

ON TABLE SET STYLE *

INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/deflt1.sty, $

ENDSTYLE

END

-RUN

-HTMLFORM BEGIN

<html>

<head>

</head>

<body>

I hope you like this report.

<hr>

<iframe id="iframe1"

src="!IBI.AMP.SRC;" height=75% width=75%>

</iframe>

</body>

</html>

-HTMLFORM END

 

 

Up to now, Ive only called a separate focexec (report) in my iframe src tags.

Once again, many thanks.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...