FusionCharts Forum / FusionCharts/FusionMaps for FileMaker / Using FusionCharts/FusionMaps in FileMaker

Tip: Missing Data and yAxisMinValue

daehl — Fri, 21 Nov 2008 09:56:42 GMT

I just wanted to pass along this tip. I prepare graphs using Fusioncharts, and frequently have to graph data series with missing values ("?"s in the data specifcations). This does not normally represent a problem, but I also have formulas that automatically choose the optimal yAxisMaxValue, yAxisMinValue, and numDivLines so that the chart is presented in a pleasing manner.

The problem is that when Fusioncharts encounters a missing value, it sometimes ignores the yAxisMinValue specification and results in a chart with unpleasing y-axis settings.

Here's an example:

[quote]?v=Free&chart=[chartType=line2D;chartWidth=600;chartHeight=320;]
&chartParams=[caption=Number of Widgits Produced;subCaption=%2525 Sold
;baseFontSize=9;animation=0;divLineDecimalPrecision=0;decimalPrecision=0;
showshadow=0;formatNumber=0;numberSuffix=%2525;
yAxisMaxValue=100;yAxisMinValue=85;numDivLines=2;numVDivLines=2;]
&labels=Week1;Week2;Week3;Week4
&data=[seriesName=Line1;showAnchors=1;showValues=1;]?;98.6;91.3;96.7
&data=[seriesName=Line2;showAnchors=1;showValues=1;]86.1;97.2;98.1;?[/quote]

(login to see pictures)
[img]http://www.fusioncharts.com/forum/Attachment586.aspx[/img]

The chart above does not honor the yAxisMinValue=85 because the first value in series 1 is missing ("?"). It instead displays a yAxisMinValue of zero, and the horizontal DivLines are not located where intended.

My workaround is to always include a dummy data series with only a single data point. I make sure the value is equal to the yAxisMaxValue that I've chosen and that the anchors and values are not displayed. So the only change required is to add that data (in bold below) which ensures that the yAxisMinValue specified is honored. [b]It must be the first data series listed in the chart code[/b]

[quote]?v=Free&chart=[chartType=line2D;chartWidth=600;chartHeight=320;]
&chartParams=[caption=Number of Widgits Produced;subCaption=%2525 Sold
;baseFontSize=9;animation=0;divLineDecimalPrecision=0;decimalPrecision=0;
showshadow=0;formatNumber=0;numberSuffix=%2525;
yAxisMaxValue=100;yAxisMinValue=85;numDivLines=2;numVDivLines=2;]
[b]&data=[showAnchors=0;showValues=0;]100[/b]
&labels=Week1;Week2;Week3;Week4
&data=[seriesName=Line1;showAnchors=1;showValues=1;]?;98.6;91.3;96.7
&data=[seriesName=Line2;showAnchors=1;showValues=1;]86.1;97.2;98.1;?[/quote]

Notice how the y-axis displays as originally intended with the correct placement of horizontal DivLines (5% bands):

[img]http://www.fusioncharts.com/forum/Attachment585.aspx[/img]

Just thought I'd pass that along in case anyone else encounters the same situation.

Changing Background Color in WIndows "Please Provide Chart Data"

dachief — Tue, 11 Nov 2008 22:20:14 GMT

Hi there,

I have a small problem with the free version of FusionChart fo Filemaker. I am using FusionCharts within iwp via FM web publsihing and everything is working quite good. There is just a slight problem for which I can't find a solution. I am using a quite dark layout for the fm database and do use quite lots of charts rendered via FusionCharts. The problem is, that no every time the database is used, every chart ist used and so the datavalues are empty (no chart can be genrated). The problem ist, that the failure message, that no chart can be generated, has a white background which is quite anoying, because of the dark layout of the db. The whole db uses a dark blue layout, and so the white window which appears ist quite anoying.

So, where or how can I change the background color of the "failure window" which appears when no chart can be generated.

Thanks in advance for any usefull hint...

Using Filemaker to generate HTML

rainmac — Mon, 10 Nov 2008 16:19:53 GMT

I have successfully generated a bar chart in Filemaker's web viewer, but I want to use Filemaker to create a stand-alone html file outside of Filemaker's web viewer. When I open FusionCharts.html in Firefox, it doesn't render the chart even though it just rendered it correctly into the web viewer. Should it render in Firefox? Do I need to do something special to get Filemaker to pass the URL parameter so I can get Firefox to display the chart?

Creating Basic Chart

BobP — Fri, 10 Oct 2008 00:10:01 GMT

Hi, I am just getting my feet wet with this product and need someone to point me in the right basic direction. I basically want to create a chart using data contained in non-repeating numeric fields within a single record. A cursory look at the samples and the online tutorial looks as though it covers either charting data contained in multiple records or a single record using repeating fields.

What I have is for each record I have five fields that I want to create a chart for. How can this be done? Is there already an example I can look at?

Thanks

FC not rendering scatter plots with more than 28 data points

FM Dvlpr Energy — Tue, 07 Oct 2008 16:41:21 GMT

Anyone have any ideas why my newly created scatter plot would only render if I'm plotting 28 data points or less?
I'm using FC Pro in FileMaker Pro 9.
Everything is fine with lots of different data series, so long as there aren't more than 28 points. My Chart is mainly ripped from FusionChartsDemo.fp7 in the Sample folder of the download.
Ideas?

Decimal Values

Optical — Fri, 01 Aug 2008 16:01:03 GMT

Hi,

I'm trying to get decimal values into my graph but it only works if i use a dot. When using a comma 2,2 becomes 22 in the graph.

Is there any way i can use a comma as decimal seperator?

Thanks in advance,

Optical

mscolum3d, xml in html

Levti — Sat, 27 Sep 2008 08:16:22 GMT

Hello,

I´m looking for an Multi-series Column 3D chart-example, where the data (xml) is sent in the html (like the ChartDataXML.html). Can anybody help?
Thanks a lot
Levti

Changing Font Weight

dachief — Thu, 18 Sep 2008 11:15:43 GMT

Hello everybody...

I am searching for the right syntax to change the weight of the fonts, used to show the numbers of the graphs. I've managed to change the size, color and the type of the font (via baseFontColor=XXXX, baseFontSize=XX, baseFont=Arial) but not the weight of the used Font. I really need the font to be bold, because the whole database uses bold fonts to mark important values. I've searched the manual all over, but was unable to find the right syntax to change from normal to bold fonts.

Who can help me ?

Printing issues - Follow Up

RschDriven — Tue, 25 Sep 2007 13:56:38 GMT

Hello,
Below are the two most recent postings regarding printing issues with a Mac. I have tried various methods -- the native printing method as well as the one described by Pallav. In fact, the one described by Pallav is the one that I was using at the beginning the first time I attempted to print a data report integrated with a chart. This has become very frustrating. I have also conducted 40-45 different experiments with various combinations of chart width, chart height, and web viewer dimensions. Then after each failed attempt to get a chart to print that was not cut off, I began deleting the web viewer used in the experiment, then flushing the cache, and then changing dimensions before another attempt -- essentially starting over each try.

I have also tried FIVE different web viewers with the same experiments. In two weeks of testing and experimentation of all available combinations, I have only one time obtained an intact chart, but too small in size to satisfy professional level requirements.

I forwarded to the support email address a message that included a detailed description of my system along with a pdf of screen snaps of the flawed output. I also asked for information regarding the browsers used to benchmark output with a Mac, but I have no support feedback other than to do what I have already done over and over with great expense of time.

Please advise what browsers have been tested with what mac systems so that I can determine, what if anything, is wrong with my system - or if the root cause is an incompatibility problem that is beyond repair regarding this operating system, etc.

Any help toward the ability to use FusionCharts with a Mac would be appreciated to avoid the expense of PC just to run an application that was advertised to be platform independent. Again, my problem is not the display of the beautifully rendered charts, it is with the mandatory integration of charts and tables for printed reports.

Thanks,

Phil

-----
Most recent messages:

9/19/2007:

Phil,

On Mac, when you dynamically resize a FusionCharts chart, it displays well on-screen. However, during print, the chart prints as per original size.
One way to tackle it would be to recompile the chart with the exact width/height of the chart that you need in your application. For example, if you're embedding a column chart with dimensions as 800x400, you can just recompile the column chart by changing the size to 800x400. Then it'll print fine on any browser at all.

Thanks,
Pallav Nadhani
FusionCharts Team

9/18/2007:

Hello,

I posted the issue about printed chart output being cut off. Sudipto's response explained the current misrendering with a Mac using Safari and Firefox for Mac. Sudipto suggested using the "right click", native print procedure with Firefox and Safari.

Update: The "native" print procedure does not work for me -- my product is one file with 170 pages of data with imbedded charts on each page. Since my Mac does not have a two button mouse, I used the alternative control key method to simulate a "right click". Additionally, my charts continue to be cut off using "right click", and efforts to find a magic combination of web viewer size and chart height and width continue to be unsuccessful.

Please advise what browsers DO support printed chart/data output with a Mac - I can afford new browser software, but I cannot afford a PC just to accurately print charts imbedded in research data. I am aware only of OmniWeb and Opera but have not used these.

What is the prognosis for resolution of the issues with Safari and Firefox.

Thank you,

Phil

Installation issue for FusionCharts for FileMaker Free

joshuachung — Tue, 26 Aug 2008 21:32:48 GMT

First of all, I have to say the issue is solved.

Actually there are two issues:

The CalculationSS, CalculationConfiguration & CalculationMS files (accessed from FusionCharts LearnerKit)did not obtain the $$CurrentDir from FusionCharts Library, which I have assigned http://myservername/fc/charts in the script InitializeFusionCharts. Once I put the same calculation formula in the CurrentDir field in these files, they worked.
The GeneratingMultiCharts had the problem to display the right hand side chart (Year-Wise Sales Chart). It worked in the non server environment. Once I added the sort record script (sort by year, without UI) before displaying the object, it worked as expected.

Sorry I have posted my issued in a wrong forum previously.

Ampersand in label

fullcity — Sun, 03 Aug 2008 20:03:48 GMT

One of the labels for some data I am trying to graph is "Sales & Marketing". I've tried using an encoding custom function to change the data to "Sales%20%26%20Marketing" but the data is still not displaying properly. Any label data after the "Sales" is not displaying at all. Any ideas what I might be doing wrong?

Thanks.

Is there a graph for Stocks?

matti — Wed, 13 Aug 2008 12:10:03 GMT

Hi all,

So far I'm very impressed by Fusioncharts for FMP.
Now I'm trying to find a way of charting stocks, and events for the stocks. Sorry that I don't know the name for this type of chart...
In chart there must be High, Low, Close (as in Excels Stock-Chart) by date.
And also what I'm looking for is some way of marking certain dates like quarterly reports and such.

First of all; Does there exist a chart in Fusioncharts that easily would do stocks for me? Even in the free version?
Secondly; How do I add these date markers with a short description text?

Best Regards,
Matti Zemack
Stockholm, Sweden

changing sort order for bars?

azazello — Tue, 05 Aug 2008 03:13:38 GMT

hi,

i'm trying to use the 'sort portal record' to change the sort order of the bars but nothing changes in the chart as the Data_Values isn't changed too;

the portal is sorted as expected though (sample file 'CalculationsSS.fp7')

any idea?

thanks

FusionChartsFree 3, FMP 9 ADV, OS 10.5.4

Can FusionCharts be used with FileMaker IWP ?

daehl — Mon, 14 Jan 2008 11:13:31 GMT

I've been able to get FusionCharts Free to work on a shared FileMaker database (shared with FileMaker Network Sharing). The only trick was to install the Charts folder locally, and edit the CurrentDir fields so they point to the local Charts folder. But I have tried the same thing with Instant Web Publishing and not been able to get it to work.

I haven't seen any mention of IWP (or Network Sharing) in the FusionCharts documentation. Is there a way to get Charts to display in databases shared via Instant Web Publishing?

yAxisMinValue not being honored

daehl — Mon, 28 Jul 2008 08:52:06 GMT

I've run into this problem a few times, and thought I should mention it as I believe it's a bug in FusionCharts. Maybe someone has a workaround, but I am unable to find one (other than changing the chart data--which is not really a solution).

I've noticed that FusionCharts ignores the yAxisMinValue when the first data point to be graphed is missing. For example, this chart displays yaxis values between 95 & 100, as indicated:

[quote]?v=free&sep=;&chart=[chartType=Line2D;chartWidth=545;chartHeight=425]&chartParams=[caption=Percent of Widgets without Defects;subCaption=7/14/2008 - 7/27/2008;baseFontSize=6;showshadow=0;showcolumnshadow=0;decimalPrecision=1;decimals=1;formatNumber=0;yAxisMinValue=95;yAxisMaxValue=100;formatNumberScale=1;canvasBorderThickness=1;numDivLines=4;numVDivLines=12;showhovercap=1;animation=0;showOnTop=1;xAxisName=Date;chartRightMargin=;chartBottomMargin=;yAxisname=Percent]&labels=7/14;7/15;7/16;7/17;7/18;7/19;7/20;7/21;7/22;7/23;7/24;7/25;7/26;7/27&data=[seriesName=Good Widgets;showAnchors=1;showValues=1;]98;;96.5;98.7;97.2;98.5;97.3;;96.8;97.5;96.7;98.7;98.2;[/quote]

However, if the first data point is instead a missing value "", the y-axis values are ignored and it plots everything between 0 & 100 (squishing the lines so they almost appear almost linear):

[quote]?v=free&sep=;&chart=[chartType=Line2D;chartWidth=545;chartHeight=425]&chartParams=[caption=Percent of Widgets without Defects;subCaption=7/14/2008 - 7/27/2008;baseFontSize=6;showshadow=0;showcolumnshadow=0;decimalPrecision=1;decimals=1;formatNumber=0;yAxisMinValue=95;yAxisMaxValue=100;formatNumberScale=1;canvasBorderThickness=1;numDivLines=4;numVDivLines=12;showhovercap=1;animation=0;showOnTop=1;xAxisName=Date;chartRightMargin=;chartBottomMargin=;yAxisname=Percent]&labels=7/14;7/15;7/16;7/17;7/18;7/19;7/20;7/21;7/22;7/23;7/24;7/25;7/26;7/27&data=[seriesName=Good Widgets;showAnchors=1;showValues=1;];;96.5;98.7;97.2;98.5;97.3;;96.8;97.5;96.7;98.7;98.2;[/quote]

Of course, the simplest workaround is to change the date/data range so that the chart never starts with a missing value. But that's not a good solution since I have a variety of charts to compare, and we'd like the ranges to be identical, regardless of whether there are missing values.

So please consider this a feature request if there is no other workaround. Even better, would be to honor the ymin & max values no matter what. Allowing it to clip charts data. That would be the ideal implementation.

Installing Fusion Charts on a network

jalz — Thu, 12 Jun 2008 09:24:40 GMT

How do I get Fusion charts working on a network. Do I need to install the charts folder on every machine, or can I install it on the server?

Charts don't appear on some PCs unless refreshed

Datavator — Thu, 05 Jun 2008 09:30:51 GMT

My FileMaker runtime charts appear correctly on most PCs but on some I get the error message saying "...there is some problem in rendering the FusionCharts object. Please check the query string". If I right-click here and select "Refresh", the chart appears. (Flash is installed on all PCs). My workaround was to include 2 scripts steps: Pause (0 sec) & Set Web Viewer - Reload, but this is not ideal and doesn't work when using a script to print the layout. I discovered that upgrading Internet Explorer 6 to 7 fixed the problem but I find it hard to believe my users will have to go to this extent. I would prefer to just include something in my installation file that does whatever this IE upgrade is doing. What is it in the IE7 upgrade that is fixing this error? I don't know much about Flash and Java so maybe it's something to do with these. Any ideas??? Thanks

Palette customization

Rabbit — Sun, 06 Apr 2008 05:28:34 GMT

hello,

I'd just like to know if there is a way to customize the 5 provided palettes in a simple way
using the Pro version

Chart Printing Problems and Workarounds...

daehl — Tue, 05 Feb 2008 12:40:34 GMT

I've recently encountered the printing problems reported elsewhere with FusionCharts for FileMaker. I have been printing my charts using the "native print method" of right/control-clicking on the chart and choosing the Print... option. And I have been creating my charts to the exact size I want them to print, so no scaling should be occurring. Nevertheless, I am encountering lots of printing problems--mainly due to lots of unexpected scaling. The charts display just fine on screen, but either scale down a little, or up a lot when printed. I can't tell what the exact cause is, but I don't think the problem is browser or platform related since I am getting the exact same behavior when I view & print the charts via IE6 for Windows, Safari2 for Mac, or Firefox2 for Mac (btw--the Fusioncharts folder is hosted on a Mac with internet sharing enabled).

So far, the key to identifying the problem appears to be the Flash plug-in. Some charts print just fine, and others scale up and are clipped during printing (even when they are built to exact same chart dimensions). At first there didn't seem to be any rhyme or reason to it, but I notice that I can now identify how the charts will print by choosing the Flash plug-in's "Show All" command in the same pop-up menu that appears when control/right-clicking on a chart.

Curiously, this strange scaling behavior can be directly affected by nothing more than the chart type choice. Here's a couple examples to illustrate this fact. The first one will not print properly (it scales to large and is clipped on the page when printed), but the second prints fine. [b]The only difference is the chart type choice[/b] (Column2D vs Column3D). This leads me to believe the problem is in the Fusioncharts code itself.

[b]Example 1:[/b] (This will not print properly)

[quote]?v=free&sep=;&chart=[chartType=[b]Column2D[/b];chartWidth=518;chartHeight=400]
&chartParams=[caption=Widgets Produced;subCaption=During last 22 shifts;
baseFontSize=9;formatNumber=0;yAxisMinValue=0;yAxisMaxValue=10;rotateNames=1;showhovercap=1;animation=0]
&labels=1/24;1/25;1/26;1/27;1/28;1/29;1/30;1/31;2/1;2/2;2/3
&data=[seriesName=AM;showname=1;showAnchors=1;showValues=1]0;1;1;2;4;2;3;4;6;2;4
&data=[seriesName=PM;showname=1;showAnchors=1;showValues=1]1;3;0;2;6;2;4;5;3;1;2
[/quote]

[b]Example 2:[/b] (But this does print okay)

[quote]?v=free&sep=;&chart=[chartType=[b]Column3D[/b];chartWidth=518;chartHeight=400]
&chartParams=[caption=Widgets Produced;subCaption=During last 22 shifts;
baseFontSize=9;formatNumber=0;yAxisMinValue=0;yAxisMaxValue=10;rotateNames=1;showhovercap=1;animation=0]
&labels=1/24;1/25;1/26;1/27;1/28;1/29;1/30;1/31;2/1;2/2;2/3
&data=[seriesName=AM;showname=1;showAnchors=1;showValues=1]0;1;1;2;4;2;3;4;6;2;4
&data=[seriesName=PM;showname=1;showAnchors=1;showValues=1]1;3;0;2;6;2;4;5;3;1;2
[/quote]

Both of these charts are displayed in FMP web viewer objects sized to exactly 518x400, so there should be no scaling. Yet, I find interesting to note that the top example scales up to about 115% when choosing the "Show All" command, whereas the bottom example scales down to about 92% respectively. So it seems that the problem is somehow behind the scenes, and not controllable by settings in the URL parameter. My guess is there is a problem in the Fusioncharts java code somewhere that is not setting some scaling value properly--but that is a total hunch since I know nothing of java or flash code.

Anyway, after examining the Fusioncharts chart specifications, I decided to try adding some space to the chart margins in order to see if I could fudge a workaround. Sure enough, by adding extra padding, and chosing the "Show All" command, I could get the charts to print how I wanted, even though they display a bit display smaller on screen.

[b]Example 3:[/b] (Same chart as Example 1, but it prints a lot better--though it displays a bit smaller on screen)

[quote]?v=free&sep=;&chart=[chartType=Column2D;chartWidth=518;chartHeight=400]
&chartParams=[caption=Widgets Produced;subCaption=During last 22 shifts;
baseFontSize=9;formatNumber=0;yAxisMinValue=0;yAxisMaxValue=10;rotateNames=1;showhovercap=1;animation=0;
[b]chartRightMargin=80; chartBottomMargin=60[/b]]
&labels=1/24;1/25;1/26;1/27;1/28;1/29;1/30;1/31;2/1;2/2;2/3
&data=[seriesName=AM;showname=1;showAnchors=1;showValues=1]0;1;1;2;4;2;3;4;6;2;4
&data=[seriesName=PM;showname=1;showAnchors=1;showValues=1]1;3;0;2;6;2;4;5;3;1;2
[/quote]

Notice how the only change from the first example was the addition of:

[b]chartRightMargin=[/b]80; [b]chartBottomMargin=[/b]60

I arrived at these number by trial an error, maybe I'll find more of a correlation as I continue testing, but it appears that you can at least tame some of these out of control charts by adding some chartRightMargin & chartBottomMargin space.

I also noticed if a chart resizes (after chosing the contextual "Show All" command), it can be restored to it's original display size by selecting the "Rewind" contextual command, or by reloading the page when viewed in a web browser. Since I can't get this to occur with any other Flash objects, again I feel this points to Fusioncharts as the originator of this problem.

It would be nice if there was some definative answer as to why these charts resize when printed.
Can anyone on the Fusioncharts team investigate this further?

[b]UPDATE[/b]- After some experimentation, it seems that there are specific chart sizes that do not rescale when printed. So far I have identified the following:

[b]Bar2D[/b] ( width >= 400, height = 450 ) or ( width = 400, height >= 450 )
[b]Column2D[/b] ( width >= 450, height = 350 ) or ( width = 450, height >= 350 )
[b]Column3D & StackedColumn2D[/b] ( width >= 565, height = 420 ) or ( width = 565, height >= 420 )
[b]Line2D[/b] ( width >= 565, height = 420 ) or ( width = 565, height >= 420 )
[b]Pie2D[/b] & [b]Pie3D[/b] ( width >= 350, height = 350 ) or ( width = 350, height >= 350 )

So for example, a Column2D chart sized to chartWidth=450;chartHeight=350 will display and print properly, but a Column2D chart of chartWidth=440;chartHeight=350 will shrink slightly when printed, and a Column2D chart of chartWidth=460;chartHeight=350 will become larger when printed.

Ghantt charts

andries — Wed, 14 May 2008 14:53:12 GMT

Is it possible to use Ghantt charts in the FusionCharts for FileMaker free version? I found that it is included in the free version for just FusionChart...

Conditional Coloring for bar charts

bradenex — Wed, 23 Apr 2008 10:33:17 GMT

I am new to Fusion charts and I am really excited to start using it. But I am not sure if it can output the charts I need. Is it possible to change the color of a bar in a chart based on its value? More specifically, I have a field that has a parameter and if the value for the bar is above that parameter then the bar would be green, otherwise it would be red. Is that possible?

Thanks.

How to make FusionCharts work in a FM runtime solution

lxu — Mon, 21 Apr 2008 17:18:18 GMT

I need help to guide me how to make the FusionChart work in a FM file when creating a runtime solution application. Thank you very much.

Help please for my question 4/21, it's urgent!!!

lxu — Thu, 24 Apr 2008 07:45:14 GMT

:exclamation:I am waiting for the help for almost a week by email direct to the techsupport team and for 4 days by posting a note here. Up to now, I did not get any answers?

If FusionChart cannot be used for the Filemaker Pro runtime solution, please let me know, so I can search for other software or tools to complete my task. If it can, please tell me how to construct the runtime solution with FusionCharts.

Thanks.

Using Fusion Charts with Visual Studio

SlaughterU — Tue, 15 Apr 2008 19:19:12 GMT

I can get the charts to show on my local machine however when I publish to the web it can't find the InfoSoftGlobal import. Below you will see the instruction I received off the net. I don't appear to have the infosoftglobal.fusioncharts or fushionchart.vb files it mentions. Please let me know what I need to do.

To plot a Chart that consumes this data, you need to include the HTML code to embed a Flash object and then provide the requisite parameters. To make things simpler for you, we've put all this functionality in an ASP.NET class named as InfoSoftGlobal.FusionCharts. This class is contained in Download Package > Code > VB_NET > bin. And, the source FusionCharts.vb is present in Download Package > Code > VB_NET > src. So, whenever you need to work with FusionCharts in ASP.NET, just use the defined functions in this class and then you can work with FusionCharts very easily.

Ideas? Where would I put the refrence? below you will see the error I am getting.

Server Error in '/' Application.

Compilation Error

Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: BC30451: Name 'FusionCharts' is not declared.

Source Error:

Line 34:         xmlData.Append("<set label='Dec' value='960' />")Line 35:         xmlData.Append("</chart>")Line 36:         TextBox2.Text = FusionCharts.RenderChartHTML("appdata/charts/line.swf", "", xmlData.ToString, "linegraph", "600", "300", False)Line 37:         Return FusionCharts.RenderChartHTML("appdata/charts/line.swf", "", xmlData.ToString, "linegraph", "600", "300", False)Line 38:     End Function

Source File: D:\inetpub\myequityplanonline\elife\calc\testgrap.aspx Line: 36

Show Detailed Compiler Output:

c:\windows\system32\inetsrv> "c:\windows\microsoft.net\framework\v1.1.4322\vbc.exe" /t:library /utf8output /R:"c:\windows\assembly\gac\system.web\1.0.5000.0__b03f5f7f11d50a3a\system.web.dll" /R:"c:\windows\assembly\gac\system\1.0.5000.0__b77a5c561934e089\system.dll" /R:"c:\windows\assembly\gac\system.web.services\1.0.5000.0__b03f5f7f11d50a3a\system.web.services.dll" /R:"c:\windows\assembly\gac\system.xml\1.0.5000.0__b77a5c561934e089\system.xml.dll" /R:"c:\windows\assembly\gac\system.drawing\1.0.5000.0__b03f5f7f11d50a3a\system.drawing.dll" /R:"c:\windows\assembly\gac\system.web.mobile\1.0.5000.0__b03f5f7f11d50a3a\system.web.mobile.dll" /R:"c:\windows\assembly\gac\system.data\1.0.5000.0__b77a5c561934e089\system.data.dll" /R:"c:\windows\assembly\gac\system.enterpriseservices\1.0.5000.0__b03f5f7f11d50a3a\system.enterpriseservices.dll" /out:"C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET Files\root\349663f6\462ebbce\ep36dwvt.dll" /D:DEBUG=1 /debug+ /win32resource:"C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET Files\root\349663f6\462ebbce\ep36dwvt.res"  "C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET Files\root\349663f6\462ebbce\ep36dwvt.0.vb"Microsoft (R) Visual Basic .NET Compiler version 7.10.7017.4for Microsoft (R) .NET Framework version 1.1.4322.2407Copyright (C) Microsoft Corporation 1987-2002. All rights reserved.C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET Files\root\349663f6\462ebbce\ep36dwvt.0.vb(14) : error BC30466: Namespace or type 'InfoSoftGlobal' for the Imports 'InfoSoftGlobal' cannot be found.Imports InfoSoftGlobal        ~~~~~~~~~~~~~~D:\inetpub\myequityplanonline\elife\calc\testgrap.aspx(36) : error BC30451: Name 'FusionCharts' is not declared.        TextBox2.Text = FusionCharts.RenderChartHTML("appdata/charts/line.swf", "", xmlData.ToString, "linegraph", "600", "300", False)                        ~~~~~~~~~~~~                                                                                                   D:\inetpub\myequityplanonline\elife\calc\testgrap.aspx(37) : error BC30451: Name 'FusionCharts' is not declared.        Return FusionCharts.RenderChartHTML("appdata/charts/line.swf", "", xmlData.ToString, "linegraph", "600", "300", False)               ~~~~~~~~~~~~

Show Complete Compilation Source:

Line 1:    '------------------------------------------------------------------------------Line 2:    ' <autogenerated>Line 3:    '     This code was generated by a tool.Line 4:    '     Runtime Version: 1.1.4322.2407Line 5:    'Line 6:    '     Changes to this file may cause incorrect behavior and will be lost if Line 7:    '     the code is regenerated.Line 8:    ' </autogenerated>Line 9:    '------------------------------------------------------------------------------Line 10:   Line 11:   Option Strict OffLine 12:   Option Explicit OnLine 13:   Line 14:   Imports InfoSoftGlobalLine 15:   Imports Microsoft.VisualBasicLine 16:   Imports SystemLine 17:   Imports System.CollectionsLine 18:   Imports System.Collections.SpecializedLine 19:   Imports System.ConfigurationLine 20:   Imports System.DataLine 21:   Imports System.Data.OleDbLine 22:   Imports System.IOLine 23:   Imports System.TextLine 24:   Imports System.Text.RegularExpressionsLine 25:   Imports System.WebLine 26:   Imports System.Web.CachingLine 27:   Imports System.Web.SecurityLine 28:   Imports System.Web.SessionStateLine 29:   Imports System.Web.UILine 30:   Imports System.Web.UI.HtmlControlsLine 31:   Imports system.web.ui.pageLine 32:   Imports System.Web.UI.WebControlsLine 33:   Line 34:   Namespace ASPLine 35:       Line 36:       <System.Runtime.CompilerServices.CompilerGlobalScopeAttribute()>  _Line 37:       Public Class Testgrap_aspxLine 38:           Inherits System.Web.UI.PageLine 39:           Implements System.Web.SessionState.IRequiresSessionStateLine 40:           Line 41:           Private Shared __autoHandlers As IntegerLine 42:           Line 43:           Line 44:           #ExternalSource("D:\inetpub\myequityplanonline\elife\calc\testgrap.aspx",46)Line 45:           Private __control2 As System.Web.UI.HtmlControls.HtmlGenericControlLine 46:           Line 47:           #End ExternalSourceLine 48:           Line 49:           Line 50:           #ExternalSource("D:\inetpub\myequityplanonline\elife\calc\testgrap.aspx",54)Line 51:           Protected TextBox2 As System.Web.UI.WebControls.TextBoxLine 52:           Line 53:           #End ExternalSourceLine 54:           Line 55:           Line 56:           #ExternalSource("D:\inetpub\myequityplanonline\elife\calc\testgrap.aspx",50)Line 57:           Protected form1 As System.Web.UI.HtmlControls.HtmlFormLine 58:           Line 59:           #End ExternalSourceLine 60:           Line 61:           Private Shared __initialized As Boolean = falseLine 62:           Line 63:           Private Shared __stringResource As ObjectLine 64:           Line 65:           Private Shared __fileDependencies As System.Collections.ArrayListLine 66:           Line 67:           Line 68:           #ExternalSource("D:\inetpub\myequityplanonline\elife\calc\testgrap.aspx",10)Line 69:           Line 70:       Line 71:    Line 72:       Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)Line 73:           Line 74:           Dim Graph As New ObjectLine 75:          Line 76:           'Call GetMonthlySalesChartHtml()Line 77:           Line 78:       End SubLine 79:       Public Function GetMonthlySalesChartHtml() As StringLine 80:           Dim xmlData As StringBuilder = New StringBuilderLine 81:           xmlData.Append("<chart caption='Monthly Unit Sales' xAxisName='Month' yaxisName='Units' ahowValues='0' formatNumberScale='0' ahowBorder='1'>")Line 82:           xmlData.Append("<set label='Jan' value='462' />")Line 83:           xmlData.Append("<set label='Feb' value='857' />")Line 84:           xmlData.Append("<set label='Mar' value='671' />")Line 85:           xmlData.Append("<set label='Apr' value='494' />")Line 86:           xmlData.Append("<set label='May' value='761' />")Line 87:           xmlData.Append("<set label='Jun' value='960' />")Line 88:           xmlData.Append("<set label='Jul' value='629' />")Line 89:           xmlData.Append("<set label='Aug' value='622' />")Line 90:           xmlData.Append("<set label='Sep' value='376' />")Line 91:           xmlData.Append("<set label='Oct' value='494' />")Line 92:           xmlData.Append("<set label='Nov' value='761' />")Line 93:           xmlData.Append("<set label='Dec' value='960' />")Line 94:           xmlData.Append("</chart>")Line 95:           TextBox2.Text = FusionCharts.RenderChartHTML("appdata/charts/line.swf", "", xmlData.ToString, "linegraph", "600", "300", False)Line 96:           Return FusionCharts.RenderChartHTML("appdata/charts/line.swf", "", xmlData.ToString, "linegraph", "600", "300", False)Line 97:       End FunctionLine 98:   Line 99:       Protected Sub TextBox1_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs)Line 100:  Line 101:      End SubLine 102:  Line 103:          #End ExternalSourceLine 104:          Line 105:          Public Sub New()Line 106:              MyBase.NewLine 107:              Dim dependencies As System.Collections.ArrayListLine 108:              If (ASP.Testgrap_aspx.__initialized = false) ThenLine 109:                  ASP.Testgrap_aspx.__stringResource = System.Web.UI.TemplateControl.ReadStringResource(GetType(ASP.Testgrap_aspx))Line 110:                  dependencies = New System.Collections.ArrayListLine 111:                  dependencies.Add("D:\inetpub\myequityplanonline\elife\calc\testgrap.aspx")Line 112:                  ASP.Testgrap_aspx.__fileDependencies = dependenciesLine 113:                  ASP.Testgrap_aspx.__initialized = trueLine 114:              End IfLine 115:              Me.Server.ScriptTimeout = 30000000Line 116:          End SubLine 117:          Line 118:          Protected Overrides Property AutoHandlers As IntegerLine 119:              GetLine 120:                  Return ASP.Testgrap_aspx.__autoHandlersLine 121:              End GetLine 122:              SetLine 123:                  ASP.Testgrap_aspx.__autoHandlers = valueLine 124:              End SetLine 125:          End PropertyLine 126:          Line 127:          Protected ReadOnly Property ApplicationInstance As System.Web.HttpApplicationLine 128:              GetLine 129:                  Return CType(Me.Context.ApplicationInstance,System.Web.HttpApplication)Line 130:              End GetLine 131:          End PropertyLine 132:          Line 133:          Public Overrides ReadOnly Property TemplateSourceDirectory As StringLine 134:              GetLine 135:                  Return "/elife/calc"Line 136:              End GetLine 137:          End PropertyLine 138:          Line 139:          Private Function __BuildControl__control2() As System.Web.UI.ControlLine 140:              Dim __ctrl As System.Web.UI.HtmlControls.HtmlGenericControlLine 141:              Line 142:              #ExternalSource("D:\inetpub\myequityplanonline\elife\calc\testgrap.aspx",46)Line 143:              __ctrl = New System.Web.UI.HtmlControls.HtmlGenericControl("head")Line 144:              Line 145:              #End ExternalSourceLine 146:              Me.__control2 = __ctrlLine 147:              Dim __parser As System.Web.UI.IParserAccessor = CType(__ctrl,System.Web.UI.IParserAccessor)Line 148:              Line 149:              #ExternalSource("D:\inetpub\myequityplanonline\elife\calc\testgrap.aspx",46)Line 150:              __parser.AddParsedSubObject(New System.Web.UI.LiteralControl(""&Microsoft.VisualBasic.ChrW(13)&Microsoft.VisualBasic.ChrW(10)&"    <title>Untitled Page</title>"&Microsoft.VisualBasic.ChrW(13)&Microsoft.VisualBasic.ChrW(10)))Line 151:              Line 152:              #End ExternalSourceLine 153:              Return __ctrlLine 154:          End FunctionLine 155:          Line 156:          Private Function __BuildControlTextBox2() As System.Web.UI.ControlLine 157:              Dim __ctrl As System.Web.UI.WebControls.TextBoxLine 158:              Line 159:              #ExternalSource("D:\inetpub\myequityplanonline\elife\calc\testgrap.aspx",54)Line 160:              __ctrl = New System.Web.UI.WebControls.TextBoxLine 161:              Line 162:              #End ExternalSourceLine 163:              Me.TextBox2 = __ctrlLine 164:              Line 165:              #ExternalSource("D:\inetpub\myequityplanonline\elife\calc\testgrap.aspx",54)Line 166:              __ctrl.ID = "TextBox2"Line 167:              Line 168:              #End ExternalSourceLine 169:              Line 170:              #ExternalSource("D:\inetpub\myequityplanonline\elife\calc\testgrap.aspx",54)Line 171:              __ctrl.Height = System.Web.UI.WebControls.Unit.Parse("429px", System.Globalization.CultureInfo.InvariantCulture)Line 172:              Line 173:              #End ExternalSourceLine 174:              Line 175:              #ExternalSource("D:\inetpub\myequityplanonline\elife\calc\testgrap.aspx",54)Line 176:              __ctrl.TextMode = System.Web.UI.WebControls.TextBoxMode.MultiLineLine 177:              Line 178:              #End ExternalSourceLine 179:              Line 180:              #ExternalSource("D:\inetpub\myequityplanonline\elife\calc\testgrap.aspx",54)Line 181:              __ctrl.Width = System.Web.UI.WebControls.Unit.Parse("892px", System.Globalization.CultureInfo.InvariantCulture)Line 182:              Line 183:              #End ExternalSourceLine 184:              Line 185:              #ExternalSource("D:\inetpub\myequityplanonline\elife\calc\testgrap.aspx",54)Line 186:              AddHandler __ctrl.TextChanged, AddressOf Me.TextBox1_TextChangedLine 187:              Line 188:              #End ExternalSourceLine 189:              Return __ctrlLine 190:          End FunctionLine 191:          Line 192:          Private Function __BuildControlform1() As System.Web.UI.ControlLine 193:              Dim __ctrl As System.Web.UI.HtmlControls.HtmlFormLine 194:              Line 195:              #ExternalSource("D:\inetpub\myequityplanonline\elife\calc\testgrap.aspx",50)Line 196:              __ctrl = New System.Web.UI.HtmlControls.HtmlFormLine 197:              Line 198:              #End ExternalSourceLine 199:              Me.form1 = __ctrlLine 200:              Line 201:              #ExternalSource("D:\inetpub\myequityplanonline\elife\calc\testgrap.aspx",50)Line 202:              __ctrl.ID = "form1"Line 203:              Line 204:              #End ExternalSourceLine 205:              Line 206:              #ExternalSource("D:\inetpub\myequityplanonline\elife\calc\testgrap.aspx",50)Line 207:              Me.__BuildControlTextBox2Line 208:              Line 209:              #End ExternalSourceLine 210:              Dim __parser As System.Web.UI.IParserAccessor = CType(__ctrl,System.Web.UI.IParserAccessor)Line 211:              Line 212:              #ExternalSource("D:\inetpub\myequityplanonline\elife\calc\testgrap.aspx",50)Line 213:              __parser.AddParsedSubObject(Me.TextBox2)Line 214:              Line 215:              #End ExternalSourceLine 216:              __ctrl.SetRenderMethodDelegate(AddressOf Me.__Renderform1)Line 217:              Return __ctrlLine 218:          End FunctionLine 219:          Line 220:          Private Sub __Renderform1(ByVal __output As System.Web.UI.HtmlTextWriter, ByVal parameterContainer As System.Web.UI.Control)Line 221:              __output.Write(""&Microsoft.VisualBasic.ChrW(13)&Microsoft.VisualBasic.ChrW(10)&"    <div>"&Microsoft.VisualBasic.ChrW(13)&Microsoft.VisualBasic.ChrW(10)&"   ")Line 222:              Line 223:              #ExternalSource("D:\inetpub\myequityplanonline\elife\calc\testgrap.aspx",52)Line 224:              __output.Write(getmonthlysalescharthtml())Line 225:              Line 226:              #End ExternalSourceLine 227:              __output.Write(""&Microsoft.VisualBasic.ChrW(13)&Microsoft.VisualBasic.ChrW(10)&"    </div>"&Microsoft.VisualBasic.ChrW(13)&Microsoft.VisualBasic.ChrW(10)&"     ")Line 228:              Line 229:              #ExternalSource("D:\inetpub\myequityplanonline\elife\calc\testgrap.aspx",54)Line 230:              parameterContainer.Controls(0).RenderControl(__output)Line 231:              Line 232:              #End ExternalSourceLine 233:              __output.Write("<br />"&Microsoft.VisualBasic.ChrW(13)&Microsoft.VisualBasic.ChrW(10)&"   "&Microsoft.VisualBasic.ChrW(13)&Microsoft.VisualBasic.ChrW(10)&"    ")Line 234:          End SubLine 235:          Line 236:          Private Sub __BuildControlTree(ByVal __ctrl As System.Web.UI.Control)Line 237:              Dim __parser As System.Web.UI.IParserAccessor = CType(__ctrl,System.Web.UI.IParserAccessor)Line 238:              Line 239:              #ExternalSource("D:\inetpub\myequityplanonline\elife\calc\testgrap.aspx",1)Line 240:              __parser.AddParsedSubObject(New System.Web.UI.LiteralControl(""&Microsoft.VisualBasic.ChrW(13)&Microsoft.VisualBasic.ChrW(10)&"<!DOCTYPE html PUBLIC ""-//W3C//DTD XHTML 1.0 Transitional//EN"" ""http://www.w3.o"& _ Line 241:  "rg/TR/xhtml1/DTD/xhtml1-transitional.dtd"">"&Microsoft.VisualBasic.ChrW(13)&Microsoft.VisualBasic.ChrW(10)&Microsoft.VisualBasic.ChrW(13)&Microsoft.VisualBasic.ChrW(10)))Line 242:              Line 243:              #End ExternalSourceLine 244:              Line 245:              #ExternalSource("D:\inetpub\myequityplanonline\elife\calc\testgrap.aspx",1)Line 246:              __parser.AddParsedSubObject(New System.Web.UI.LiteralControl(""&Microsoft.VisualBasic.ChrW(13)&Microsoft.VisualBasic.ChrW(10)&Microsoft.VisualBasic.ChrW(13)&Microsoft.VisualBasic.ChrW(10)&"<html xmlns=""http://www.w3.org/1999/xhtml"" >"&Microsoft.VisualBasic.ChrW(13)&Microsoft.VisualBasic.ChrW(10)))Line 247:              Line 248:              #End ExternalSourceLine 249:              Line 250:              #ExternalSource("D:\inetpub\myequityplanonline\elife\calc\testgrap.aspx",1)Line 251:              Me.__BuildControl__control2Line 252:              Line 253:              #End ExternalSourceLine 254:              Line 255:              #ExternalSource("D:\inetpub\myequityplanonline\elife\calc\testgrap.aspx",1)Line 256:              __parser.AddParsedSubObject(Me.__control2)Line 257:              Line 258:              #End ExternalSourceLine 259:              Line 260:              #ExternalSource("D:\inetpub\myequityplanonline\elife\calc\testgrap.aspx",1)Line 261:              __parser.AddParsedSubObject(New System.Web.UI.LiteralControl(""&Microsoft.VisualBasic.ChrW(13)&Microsoft.VisualBasic.ChrW(10)&"<body>"&Microsoft.VisualBasic.ChrW(13)&Microsoft.VisualBasic.ChrW(10)&"    "))Line 262:              Line 263:              #End ExternalSourceLine 264:              Line 265:              #ExternalSource("D:\inetpub\myequityplanonline\elife\calc\testgrap.aspx",1)Line 266:              Me.__BuildControlform1Line 267:              Line 268:              #End ExternalSourceLine 269:              Line 270:              #ExternalSource("D:\inetpub\myequityplanonline\elife\calc\testgrap.aspx",1)Line 271:              __parser.AddParsedSubObject(Me.form1)Line 272:              Line 273:              #End ExternalSourceLine 274:              Line 275:              #ExternalSource("D:\inetpub\myequityplanonline\elife\calc\testgrap.aspx",1)Line 276:              __parser.AddParsedSubObject(Me.CreateResourceBasedLiteralControl(0, 544, true))Line 277:              Line 278:              #End ExternalSourceLine 279:          End SubLine 280:          Line 281:          Protected Overrides Sub FrameworkInitialize()Line 282:              SetStringResourcePointer(ASP.Testgrap_aspx.__stringResource, 544)Line 283:              Me.__BuildControlTree(Me)Line 284:              Me.FileDependencies = ASP.Testgrap_aspx.__fileDependenciesLine 285:              Me.EnableViewStateMac = trueLine 286:              Me.Request.ValidateInputLine 287:          End SubLine 288:          Line 289:          Public Overrides Function GetTypeHashCode() As IntegerLine 290:              Return 1284192673Line 291:          End FunctionLine 292:      End ClassLine 293:  End NamespaceLine 294:

FileMaker Web Viewer Not Rendering Charts in Preview Mode

drewwesley — Thu, 17 Apr 2008 23:47:44 GMT

I've created a simple report that uses FusionCharts in a web viewer object on the 2nd page in preview mode. The only way to get the chart to render correctly is if I go back to the 1st page, and return to 2nd page. But for some reason, my first attempt at going to the chart results in a blank space, or the first frame of the graph's animation. Any suggestions?

Clicking on a map to run a FileMaker Script

miraklemax — Sun, 13 Apr 2008 09:08:17 GMT

I'd like a user to be able to click a country on a map and have that click event run a FileMaker script that finds all records in the database related to that country. Is that possible? If so, how do I set it up?

Pop up window

darshan — Tue, 25 Mar 2008 09:10:20 GMT

Hi Support,

Is there any option to open the pop up window, on click on pie-chart slice..?? by the following code, i am able to open the page, but not in pop up.

Compatibility with FileVault (Leopard)

BF-H — Thu, 21 Feb 2008 15:43:48 GMT

Is FusionCharts Free for FileMaker compatible with FileVault under Leopard?

On my Mac runnning FileMaker Pro 9 Advanced under Leopard without FileVault turned off, SampleChart 1 displays the graph properly.

On my other Mac running FileMaker Pro 9 Advanced under Leopard [i]with FileVault turned on[/i], SampleChart 1 displays [i]without[/i] the graph; the web viewer is empty. Likewise for the other sample .fp7 files that come with FusionCharts Free for FileMaker.

I opened WebViewer Example.fp7 that comes with FileMaker Pro 9 Advanced. All web viewers in that file all displayed [i]properly[/i].

Thus, the problem I'm experiencing with FusionCharts evidently is specific to Web Viewer in FusionCharts rather than a general problem with Web Viewer.

Thanks in advance!

FileMaker Server / FusionCharts setup

fmpros — Mon, 08 Oct 2007 18:20:31 GMT

On a filemaker network where the database file resides on the server and the clients are remote and running regular FileMaker, where should I place the "Charts" folder and / or initialize the FusionCharts engine path?

How was "months" field in "MultipleSeriesScript" sample file configured?

BF-H — Mon, 03 Mar 2008 17:24:59 GMT

In the sample file "MultipleSeriesScript," the Month field is configured with 12 repetitions and it is a member of the value list "MonthList."

For each of the two records in this sample file, the Month field displays with 12 repetitions, each repetition contains the name of a month, and in Browse view the repetitions are not editable (if you click it, nothing happens) even though that field is configured to allow user to override during data entry.

I have tried replicating this in a brand-new fp7 without any luck. The months field is empty and I can click in it, even though I have created a value list and configured the months field as a member of that value list.

I have inspected everything I can think of and can access in "MultipleSeriesScript" to find out what's different in it versus my brand-new fp7 without any luck.

Can you please tell me how come my fp7's months field is behaving differently than the corresponding field in "MultipleSeriesScript" as described above?

Thanks in advance!

How come portal must be clicked before loading chart?

BF-H — Wed, 27 Feb 2008 15:59:32 GMT

Hi,

Although I have been using FileMaker Pro for about a decade, I am an end user rather than a developer and my programming skills admittedly are weak.

Here is the URL that I built for a column 3D chart in a fp7 that someone else built for me. The developer is unavailable for consultation and has provided very little documentation in the fp7 regarding the design and logic.

"?v=" &UI::version& "&sep=" &$$delimiter& "&chart=[chartType=" & $chartType &$$delimiter& "chartWidth=" &$chartWidth &$$delimiter& "chartHeight=" &$chartHeight& "]&chartParams=[caption=" &$caption& $$delimiter& "subCaption=" &$subCaption& $$delimiter& "formatNumberScale=4" &$$delimiter& "showValues=1" &$$delimiter& "decimalPrecision=0" &$$delimiter& "numberPrefix=]"

The attached screen captures show the symptom; if I load the chart without clicking in the portal first, the chart shows the value and x-axis label for the first record only. If I click in the portal before loading the chart, then the chart displays all the proper values.

[b]Is this what you would expect?[/b]

If not, how can I fix the problem so that my audience will not need to be instructed to click in the portal before displaying the chart?

Many thanks in advance!

Version number?

BF-H — Thu, 21 Feb 2008 14:40:49 GMT

How can I determine what is the version number of the FusionCharts for FileMaker that I've downloaded?

How can I determine what is the version number that currently is available for download?

I would like to find out whether the currently available version is the same as the one I've already got, or is a newer one.

Thank you!

Problem in FusionCharts Library

Ryan — Thu, 06 Dec 2007 13:18:34 GMT

I just got the Pro version and started to read the documents. I found several places in the scripts of FusionCharts Library seems wired.

(1) In both AppendChartParmaeterToFCURL and AppendChartConfigToFCURL, the statement
Set Cariable [$WebAddress; Value::$$FusionChartsFDilePath] should be placed right after if statement block, not before it. It seems to me before it, the script won't work if $$FusionChartsFDilePath is not initialized.

(2) I don't understand the following statement in BuildAndAppendSSDataParams-FrontRepetition

Set Variable [ $data; Value:$data & If($LoopCounter ≠ 1;$delimiter;"") & GetRepetition ( [u]Evaluate(""&$DataFieldName)[/u]; LoopCounter )

Why to use Evaluate statement and why to use ""& (to get a expression?) ?

(3) the following statement seems to be useless in the script BVuildAndAppendSSDataParams-BySummingValuesInLayout
Set Variables[$currentValue; Value:0]
(just after "End If" statement, and 3 lines above the "End Loop")

Suggestions:
all the pre-requisites for the scripts should be added to the scripts themselves as comments instead of only in the documents.

Fusion Charts Free for Filemaker Not Working

daehl — Mon, 17 Dec 2007 16:59:37 GMT

I am quite new to Fusion Charts. I downloaded the demos on a few Macs where I work to begin learning how to use it in FileMaker Pro 9 Advanced. I am just trying to get the demos to work so I can begin with the tutorial. They worked for me originally, but then started giving me a "File Doesn't Exist" error message. But I can't get them to work anymore. I've rebooted, reinstalled and all I get is "File Doesn't Exist". It happens on three different Macs (two are running 10.4.11 and the third was running 10.4.7). I tried reinstalling Flash (version 9,0,115,0) but that has no effect.

I'm checking the FusionChartsURL fields in the sample FMP databases, and they all appear valid. I've installed the demos on my second partition so the url is:

file://Storage/Samples/BasicExamples/Charts/FusionCharts.html?v=free ...

There are no spaces in the path name (if that's a concern) and yet I continue to get the message "File Doesn't Exist" in the web browser instead of a graph.

So I'm a bit puzzled. I've done searches in this forum, and in the FAQs and have been unable to find any advice that applies to this problem. I did have these working before, but just can't figure out what's wrong now.

I'd appreciate any help or advice anyone can offer...

Using Percent (%) as numbersuffix

daehl — Mon, 28 Jan 2008 14:38:39 GMT

I'm having problems with using a percent (%) as a numberSuffix chartParam.

I'm using fusioncharts free for Filemaker (on Mac OS X 10.4.11 and Filemaker 9 Adv) and find that the URL works fine in Filemaker, but not in a web browser (Safari2 or Firefox2 or IE6 for Windows). I have tried the following using the FusionChartsDebug.html:

[url]
?v=Free&chart=[chartWidth=620;chartHeight=400]&chartParams=[numberSuffix=%25];&data=10;20;30;40&labels=Label 1;Label 2;Label 3;Label 4[/url]

The above URL works in Filemaker, but fails when used in the FusionChartsDebug text input field. It results in an "Invalid XML Data" error.

I searched the forums and found another post where it was suggested to use '%25', but that doesn't work either:

[url]?v=Free&chart=[chartWidth=620;chartHeight=400]&chartParams=[numberSuffix='%25'];&data=10;20;30;40&labels=Label 1;Label 2;Label 3;Label 4[/url]

It does display the chart, but the following appears as the numberSuffix: '26apos;

so, for example the y-axis labels are:

50.00'26apos;
40.00'26apos;
30.00'26apos;
20.00'26apos;
10.00'26apos;
0.00'26apos;

I also tried using '%' and that results in the same as above (using '%25').

Anyone know how I can properly encode a percent symbol into the URL?

Can I change the color of the column in 2d or 3d?

D1132 — Thu, 24 Jan 2008 01:02:11 GMT

How to make the bar with solid color without the shallow effect at the bottom of bar?

Where i can find more description of control about the chart property?

Gantt Chart?

Jerremy — Thu, 27 Dec 2007 07:51:23 GMT

Hi,

Just purchased FusionCharts - and they are great.

Is there a way to create a Gantt chart with the FileMaker version of the charts?

If not, will there soon be a Gantt chart available?

Thanks,

Jerremy

How to hide the number display on top of each column?

D1132 — Thu, 03 Jan 2008 04:07:58 GMT

I purchased the filemaker fusion chart and try to hid the number display in each of the top of column or bar?

I can just use color or font to try minimize their apperance. but is there is any better solution?

Is there aby method to have 1 set of data showing area and 1 set of data showing bar or column?

D1132 — Thu, 03 Jan 2008 04:12:26 GMT

I have a table with one budget column and one expenditure column.

I want to show the budget over 12 month by area effect while the expenditure over 12 month is in bar or column effect. Can it be done?

Multi-Series Area2D chart fill-colors question

maestro2020 — Sun, 09 Dec 2007 15:03:54 GMT

I have set up a multi-series Area2D chart.
The default colors and alpha settings are blue and orange (not sure about the default alpha settings though).

I would like to be able to control these for each data set diplayed in the chart.
I am currently executing chart creation using the script method.
Here are the two key variable settings that I thing will show what I am currently doing..

[b]All the parameters that are used to configure the chart[/b]
[quote]"?v="
&DemoTable::version&
"&sep="
&$$delimiter&
"&chart=[chartType="
& $$chartType
&$$delimiter&
"chartWidth="
&$$chartWidth
&$$delimiter&
"chartHeight="
&$$chartHeight&
"]&chartParams=[caption=Calories"
&$$delimiter&
"rotateNames=1"
&$$delimiter&
"baseFontSize=9"
&$$delimiter&
"subCaption="
&$$delimiter&
"formatNumberScale=0"
&$$delimiter&
"showValues=0"
&$$delimiter&
"decimalPrecision=0"
&$$delimiter&
"numberPrefix=]"[/quote]

And [b]The data used to draw the chart - the Amount field value[/b]
I'm using one variable for each series.
[quote][b]$$weightedValues[/b]
Substitute(List(main for 4 weeks::sevenDay_calories);"¶";$$delimiter)[/quote]
[quote][b]$$rawValues[/b]
Substitute(List(main for 4 weeks::daily_calories);"¶";$$delimiter)[/quote]

[b]Text which contains the data parameters[/b]
[quote]"&labels=" &$$labels&
"&data=[seriesName=weighted]" &$$weightedValues &
"&data=[seriesName=raw]" &$$rawValues[/quote]

The issue I cannot seem to figure out is how and WHERE in all this to set the Multi-Series fillcolor and alpha settings?

Can you please help?

Thank you.