Skip to main content
Frosty
New Member
November 13, 2014
Solved

FL100C: one dataset, two charts, only one chart will display

  • November 13, 2014
  • 1 reply
  • 4386 views

I've written a custom dataset SQL query that produces me a count of how much traffic (GB) goes In/Out through our Internet link (port 16 on our FG200B) per day.  It works great.

Then I created two Charts based off this Dataset:  one is a Table format (lists the data values tabular format); the other is a Bar Graph.

Then I created a Report utilising the Charts ... and here is where it has gone pear-shaped:

If I embed the tabular data Chart by itself into the Report, it works.

If I embed the bar graph Chart by itself into the Report, it works.

If I embed BOTH of the charts into the Report, only ONE of them is displayed; the other has "No data".

I had expected that if I created a Dataset, then multiple Charts from that dataset, the FL100C would be smart enough to run the SQL query once, then reuse the results multiple times to drive the charts ... but it seems I am mistaken.

I don't really want to needlessly duplicate datasets, just so I can use that data multiple times in a report.

Suggestions welcome.

    Best answer by hzhao_FTNT

    Hi, what's your FAZ version? I didn't see this issue on my FAZ 5.0.9. I have created 4 charts(table/bar/pie/line) based on one dataset, all charts can be displayed properly in one report.

     

    regards,

    hz

    1 reply

    hzhao_FTNT
    Staff
    Staff
    November 13, 2014

    Hi, what's your FAZ version? I didn't see this issue on my FAZ 5.0.9. I have created 4 charts(table/bar/pie/line) based on one dataset, all charts can be displayed properly in one report.

     

    regards,

    hz

    Frosty
    FrostyAuthor
    New Member
    November 13, 2014

    There is another bug that I am waiting for a fix on, apparently to be resolved in v5.0.10 at the end of the month, but no reason I can't update to v5.0.9 immediately.  I'll try that and let you know.