Graphing within reports

#1

I have checked out several plug-ins and methods for adding bar graphs in
Filemaker but they do seem to meet my needs. I have therefore worked out
a simple method of including text-resolution graphs in my reports.

First I convert the value to be graphed into a % of the maximum score.
Then I call a sub-routine that simply extracts the required number of
characters (between 0 and 100) from a string of I's (I use Arial I's
which look better than Courier since they dont have serifs):

-- Build bar ---
#Input is $$nbar, output is $$tbar
Set Variable [ $$tbar;
Value:Left("IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII IIIIIIIIIIIIIIII
IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII IIIIIIIIIIIIIIII
IIIIIIIIIIIIIIIIIIIIIIIIIIII";$$nbar) ]

I feed the result into a text field in the appropriate table. I can also
add text color at this time (for stacked bars):

--- Set field --------
Set Variable [ $$nbar; Value:Round(100*(scoring:

ole_sc/37);0) ] # %
Perform Script [ “Build bar” ] # call sub-routine
Set Variable [ $$tbar; Value:TextColor($$tbar ; RGB( 0 ; 255 ; 0 ))] #
make it green text
Set Field [ scoring::bar_total; scoring::bar_total & $$tbar ] # add to field

A sample of the results can be viewed in the PDF at:
http://members.optusnet.com.au/carsafety/5star_cht.pdf

It is a crude workaround but fulfils my needs for now.

Michael Paine
FM 8
BTW my ancient (DOS circa 1985) Open Access database had the facility to
generate graphs from found sets.

#2

In article <454fd399$0$11971$afc38c87 (AT) news (DOT) optusnet.com.au>, Michael
Paine <mpaine (AT) tpgi (DOT) com.au> wrote:

Quote:

I have checked out several plug-ins and methods for adding bar graphs in
Filemaker but they do seem to meet my needs. I have therefore worked out
a simple method of including text-resolution graphs in my reports.

First I convert the value to be graphed into a % of the maximum score.
Then I call a sub-routine that simply extracts the required number of
characters (between 0 and 100) from a string of I's (I use Arial I's
which look better than Courier since they dont have serifs):

-- Build bar ---
#Input is $$nbar, output is $$tbar
Set Variable [ $$tbar;
Value:Left("IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII IIIIIIIIIIIIIIII
IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII IIIIIIIIIIIIIIII
IIIIIIIIIIIIIIIIIIIIIIIIIIII";$$nbar) ]

I feed the result into a text field in the appropriate table. I can also
add text color at this time (for stacked bars):

--- Set field --------
Set Variable [ $$nbar; Value:Round(100*(scoring:

ole_sc/37);0) ] # %
Perform Script [ “Build bar” ] # call sub-routine
Set Variable [ $$tbar; Value:TextColor($$tbar ; RGB( 0 ; 255 ; 0 ))] #
make it green text
Set Field [ scoring::bar_total; scoring::bar_total & $$tbar ] # add to field

A sample of the results can be viewed in the PDF at:
http://members.optusnet.com.au/carsafety/5star_cht.pdf

It is a crude workaround but fulfils my needs for now.

Michael Paine
FM 8
BTW my ancient (DOS circa 1985) Open Access database had the facility to
generate graphs from found sets.

Congratulations for working out a solution for yourself, but the method
has been around for many years and is documented in many FileMaker
resource websites. You could have saved yourself a lot of time, but it
wouldn't have been as rewarding.

)

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

#3

8.5 advanced has the ability to generate bar, line & pie graphs

--

-------------------------------------------------
www.nsbtaxi.com

Captain Guy
s/v Island Time (352#277)
AICW 845.5
386-689-5088
"Helpful Harry" <helpful_harry (AT) nom (DOT) de.plume.com> wrote

Quote:

In article <454fd399$0$11971$afc38c87 (AT) news (DOT) optusnet.com.au>, Michael
Paine <mpaine (AT) tpgi (DOT) com.au> wrote:

I have checked out several plug-ins and methods for adding bar graphs in
Filemaker but they do seem to meet my needs. I have therefore worked out
a simple method of including text-resolution graphs in my reports.

First I convert the value to be graphed into a % of the maximum score.
Then I call a sub-routine that simply extracts the required number of
characters (between 0 and 100) from a string of I's (I use Arial I's
which look better than Courier since they dont have serifs):

-- Build bar ---
#Input is $$nbar, output is $$tbar
Set Variable [ $$tbar;
Value:Left("IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII IIIIIIIIIIIIIIII
IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII IIIIIIIIIIIIIIII
IIIIIIIIIIIIIIIIIIIIIIIIIIII";$$nbar) ]

I feed the result into a text field in the appropriate table. I can also
add text color at this time (for stacked bars):

--- Set field --------
Set Variable [ $$nbar; Value:Round(100*(scoring:

ole_sc/37);0) ] # %
Perform Script [ "Build bar" ] # call sub-routine
Set Variable [ $$tbar; Value:TextColor($$tbar ; RGB( 0 ; 255 ; 0 ))] #
make it green text
Set Field [ scoring::bar_total; scoring::bar_total & $$tbar ] # add to
field

A sample of the results can be viewed in the PDF at:
http://members.optusnet.com.au/carsafety/5star_cht.pdf

It is a crude workaround but fulfils my needs for now.

Michael Paine
FM 8
BTW my ancient (DOS circa 1985) Open Access database had the facility to
generate graphs from found sets.

Congratulations for working out a solution for yourself, but the method
has been around for many years and is documented in many FileMaker
resource websites. You could have saved yourself a lot of time, but it
wouldn't have been as rewarding.

)

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

#4

Well, it has the ability to generate anything you want in Flash/SVG and
display it via the Web Viewer, if that is what you mean.

"Guy" <sailor (AT) guym (DOT) com> wrote

Quote:

8.5 advanced has the ability to generate bar, line & pie graphs

#5

yes, that's what i mean... the fm web site has a simple overview-how-to and
sample files for displaying such graphs

--

-------------------------------------------------
www.nsbtaxi.com

Captain Guy
s/v Island Time (352#277)
AICW 845.5
386-689-5088
"Bill Marriott" <wjm (AT) wjm (DOT) org> wrote

Quote:

Well, it has the ability to generate anything you want in Flash/SVG and
display it via the Web Viewer, if that is what you mean.

"Guy" <sailor (AT) guym (DOT) com> wrote in message
news:bP64h.4089$ig4.1117 (AT) newsread2 (DOT) news.pas.earthlink.net...
8.5 advanced has the ability to generate bar, line & pie graphs

#6

Posting Reply to Ted's "Yet More testing" post

#7

Quote'ing ...

[quote:5ed6cf6c26="Tim Haynes <thaynes (AT) openlinksw (DOT) com>"]"Ted Thibodeau Jr" <tthibodeau (AT) openlinksw (DOT) com> writes:

Quote:

This *should* show up as a reply in both phpbb and
openlink.internal.spam-test

Let us see.

(I had to manually set the Subject as `Re: Yet more testing` -- this
should be automatic, if at all possible.)

I thought it was..

Quote:

(BBCode is set ON -- what happens to BBCode when it gateways to NNTP?)

Generally it looks ugly

~Tim
--
Product Development Consultant
OpenLink Software
Tel: +44 (0) 20 8681 7701
Web: <http://www.openlinksw.com>
Universal Data Access & Data Integration Technology Providers
[/quote:5ed6cf6c26]