Discussion:
Reports as HTML
(too old to reply)
Bryan Gardner
2008-12-05 03:07:09 UTC
Permalink
Is there a simple way to have reports from InfoMaker be live links in a HTML
site and execute against the database, real time?
Terry Dykstra [TeamSybase]
2008-12-05 16:04:24 UTC
Permalink
I don't think you are answering the question.
If you want a link in a HTML page and use that to execute an InfoMaker
report, you can do it, but it requires the DataWindow ActiveX. The IM
documentation does not describe it at all, other than as a way to display a
PSR file. But you can make it completely interactive by configuring a JDBC
connection. I've done some testing in IM 9 with this feature and got it to
work using a JSP html page, but it is a pain.
--
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/
http://casexpress.sybase.com
product enhancement requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement
Hi Bryan;
Yes there is ... I am not sure about your interpretation of "simple"
though - but here is what I do for my IM users in such cases (I used the
birthday report in the IM examples for this) ...
1) Create a report object.
2) Add a Computed column (for the HTML link).
3) In the CC construct your HTML syntax
for example ....
"<a href=http://www.birthdaywish.com/" + emp_lname + ">" + emp_lname
+"</a>"
4) In the HTML properties tab for the CC, set the check box "" ON.
5) Add a CommandButton to the report as set its action to "Save As".
6) Create a Form object.
- Use a Freeform style
- Pick any column from any table (I like to have a "dummy" table in my
DB for this).
7) In the Form painter ... delete the column(s) from the display that you
chose in Step#6.
8) Add a Report object to the form and assign it the report you created in
Step#1.
9) Package the new form from Step# 6 into an EXE.
--------------- Running the IM Application
EXE --------------------------------
a) Run the IM application and choose the appropriate Form.
b) Select the CB to "Save As"
c) Instruct the users to select the option "HTML Table" for the SaveAs
type and give it a name.
d) Instruct the users open the file they created Step "c" using their
favourite browser.
- Note that the computed columns are now "live" URL links!
Note: See attachments
Notice that the active report in the web browser takes you to the Birthday
(fictitious) website and passes the name as a further qualifier.
HTH
--
Regards ... Chris
ISUG - NA RUG Director
http://chrispollach.pbdjmagazine.com
Post by Bryan Gardner
Is there a simple way to have reports from InfoMaker be live links in a HTML
site and execute against the database, real time?
Chris Pollach
2008-12-05 16:48:58 UTC
Permalink
Interesting approach too!

BTW: Deprecated in PB 11.5 and thus IM 11.5 ...
· DataWindow plug-in and window plug-in
· Window ActiveX
Post by Terry Dykstra [TeamSybase]
I don't think you are answering the question.
If you want a link in a HTML page and use that to execute an InfoMaker
report, you can do it, but it requires the DataWindow ActiveX. The IM
documentation does not describe it at all, other than as a way to display
a PSR file. But you can make it completely interactive by configuring a
JDBC connection. I've done some testing in IM 9 with this feature and got
it to work using a JSP html page, but it is a pain.
--
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/
http://casexpress.sybase.com
http://my.isug.com/cgi-bin/1/c/submit_enhancement
Hi Bryan;
Yes there is ... I am not sure about your interpretation of "simple"
though - but here is what I do for my IM users in such cases (I used the
birthday report in the IM examples for this) ...
1) Create a report object.
2) Add a Computed column (for the HTML link).
3) In the CC construct your HTML syntax
for example ....
"<a href=http://www.birthdaywish.com/" + emp_lname + ">" +
emp_lname +"</a>"
4) In the HTML properties tab for the CC, set the check box "" ON.
5) Add a CommandButton to the report as set its action to "Save As".
6) Create a Form object.
- Use a Freeform style
- Pick any column from any table (I like to have a "dummy" table in my
DB for this).
7) In the Form painter ... delete the column(s) from the display that you
chose in Step#6.
8) Add a Report object to the form and assign it the report you created
in Step#1.
9) Package the new form from Step# 6 into an EXE.
--------------- Running the IM Application
EXE --------------------------------
a) Run the IM application and choose the appropriate Form.
b) Select the CB to "Save As"
c) Instruct the users to select the option "HTML Table" for the SaveAs
type and give it a name.
d) Instruct the users open the file they created Step "c" using their
favourite browser.
- Note that the computed columns are now "live" URL links!
Note: See attachments
Notice that the active report in the web browser takes you to the
Birthday (fictitious) website and passes the name as a further qualifier.
HTH
--
Regards ... Chris
ISUG - NA RUG Director
http://chrispollach.pbdjmagazine.com
Post by Bryan Gardner
Is there a simple way to have reports from InfoMaker be live links in a HTML
site and execute against the database, real time?
Loading...