I think this is pretty hard in 5.0 but I would ask Terry - maybe he's
done something for 5.0.
The "running a report without clicking" is an enhancement I coded for
6.0 Infomaker but didn't get in at the last minute. It would require
modification of the w_pbstyle_frame_ancestor in IMSTYLE6.PBL to capture
the parameters you send in.
Terry Dykstra also has a report scheduler that he's written - you might
want to check with him also. My code for IM 6.0 only runs them
myexe /r report_name // run only
myexe /rp report_name // run and print
myexe /p my_pipeline // run a deployed pipeline
One of the good things about 6.0 is we took the styles out of the
PBTYP050.DLL and placed them in a regular PBL (IMSTYLE6.PBL). If you're
a Powerbuilder developer, you can customize the template (menus,
scripting) used to build the executables for your own organization by
There are a lot of features in 6.0 that help the end user.
1. Hidden reports (so dddw edits styles and nested reports can be
hidden in the "Open Report" dialog if you don't want these run
2. Query Governor (#rows and time limit) for runtime exes.
3. Open Report/Form/Pipeline dialog has comments
Report_name1 Comment from Environment painter
Report_name2 Comment from Environment painter 2
so users can more easily pick a report by description than having to
name a report "sales_for_1997_report".
3a. Only get Open Report/Form/Pipeline icons/menu picks if you've
created the executable with one of these objects. In 3.0-5.0, you'd
always get an "Open Form" button, for instance, even if your exe had
only reports. It would bring up a blank dialog and confuse the user.
4. Deployable pipelines. It's not in the "What's New" screen but it
should be in the documentation. We created a window to run pipelines in
the deployed executable. This window also has "timed" pipelines for
delayed and delayed/recurring execution (every hour/day,etc). This
allows you to connect to databases with NATIVE drivers and pipe down to
ODBC, for instance, for small change.
5. Lots of prompts "Changes, do you want to save?" type of questions in
forms - an area that was lacking in the past. Lots of small user
interface things fixed in forms. Sort/Filter dialogs - even in 12many
and many21 forms for BOTH master and detail.
6. More consistent menus between development and runtime - esp the form
menus where we didn't even have File/Exit.
7. Help/About will now allow you do identify yourself, email, web
address, etc as the developer. You can place version and other software
info on this screen and a company logo in BMP format. It isn't as good
as I would have liked but it's better than the old "Powerlauncher"
screen we had before and delivers a more professional looking exe.
8. Runtime 'print options' dialog for reports to print, say pages 2,3 of
a 100 page report. One of the things most customers asked for.
I also coded something for forms that places the comments for each
column (from the database) in the microhelp as you tab from column to
column. This might get into 6.0.01. We were trying to make the exe
more professional looking and I think it turned out pretty well.
I hope you'll look into IM 6.0.