October 22, 2007, 11:11 AM
MichealHTML format problem - Web Services, Report Caster
Hello,
I'm using Web services to return a report that has been run by Report Caster and stored in the Report Library. I have set the report format as HTMTABLE and made sure HTMLCSS is set to OFF. When I run the report from Developer Studio it returns the HTML that I want. However, when I call the report from my web page using web services it returns HTML, HEAD and BODY tags etc. This is not really acceptable as I am embedding the report into an existing HTML page.
In Report Caster, the report Format that I have selected is HTML - Web Page (*.htm, *.html) under the task tab. Is it this thats causing the problem? I can't see a option for returning just the HTMTABLE.
Any help or advice on this would be appreciated.
Thanks
Micheal
October 22, 2007, 04:22 PM
FernandoMicheal,
Yes the selection of HTML in Caster is causing the problem. Think of it as if caster is copying your fex and replace the on table hold with it's own on table hold.
Options
1) Live with HTML
2) Create a NFR and wait for ibi to put it in
3) use FORMAT ALPHA and build the HTML yourself
Why do you need HTMLTABLE?
Fernando
October 23, 2007, 04:14 AM
Michealquote:
Fernando
Hello Fernando
Thanks for the reply. I would like to use HTMTABLE as this just returns the table HTML not the HTML, HEAD, BODY tags etc. As I want to embed the report into an existing HTML page I only want the table HTML.
I'll have a look at FORMAT ALPHA.
Regards
Micheal
October 23, 2007, 08:29 AM
Tony AMichael,
Instead of accepting RCs output options, just force the issue by FILEDEFing the resultant output to a location on your Client machine (the one with IIS on it) and then have ON TABLE HOLD AS filedefd_name FORMAT HTMTABLE.
Refer to the held file within your existing Web page.
FILEDEF myhtml DISK somewhere_on_your_client_server
-RUN
TABLE FILE filename
PRINT some stuff
BY etc.
ON TABLE SET HTMLCSS ON
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE HOLD AS myhtml FORMAT HTMTABLE
ON TABLE SET STYLE *
your style code
ENDSTYLE
END
This should work but I haven't tried it.
T
October 23, 2007, 09:06 AM
FernandoMichael,
Tony's anwser, gave me an idea. Report caster looks for the last hold to replace. You may want to try doing your hold to a HTMTABLE using a filedef and then another query after that. Report Caster may do the first hold then use the second as the output of the email, etc.
By the way, I would still ask for the New Feature. However, it would not be Format HTMTABLE, it would be something like "no change" (In other words, don't change what the developer was done).
Fernando