Brandon Andrathy Posted December 10, 2020 Share Posted December 10, 2020 Hi! Can someone please tell me how to get the below CAR hold file into an iframe TABLE FILE CAR SUM SALES BY COUNTRY ON TABLE HOLD AS CAR FORMAT HTMTABLE END -HTMLFORM BEGIN <HTML> <HEAD> </HEAD> <BODY> <iframe id="iframe1;" src="!IBI.FIL.CAR;"> </iframe> </BODY> </HTML> -HTMLFORM END Link to comment Share on other sites More sharing options...
Manoj Chaurasia Posted December 11, 2020 Share Posted December 11, 2020 Brandon If you use this code and then create an html form with an iframe in it for the output of the fex, it should accomplish what you want. I know it is an extra step but TABLE FILE CAR SUM SALES BY COUNTRY ON TABLE PCHOLD FORMAT HTML END Link to comment Share on other sites More sharing options...
Brandon Andrathy Posted December 11, 2020 Author Share Posted December 11, 2020 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 More sharing options...
Steven Hall Posted December 11, 2020 Share Posted December 11, 2020 Is there a particular need to have the table in an <iframe>, and not just a <div> Link to comment Share on other sites More sharing options...
David Beagan Posted December 11, 2020 Share Posted December 11, 2020 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 More sharing options...
David Briars Posted December 15, 2020 Share Posted December 15, 2020 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 More sharing options...
David Beagan Posted December 16, 2020 Share Posted December 16, 2020 @david.briars good to know about the RESTful option too, hanks Link to comment Share on other sites More sharing options...
Brandon Andrathy Posted December 16, 2020 Author Share Posted December 16, 2020 thank you all for your input here! Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now