FlexCharts on FlexReports

FlexCharts on FlexReports

Posted by: connellyj on 2 May 2018, 11:07 am EST

• 

  connellyj

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 2 May 2018, 11:07 am EST

  I a report that was working in C1Reports. I pulled it into FlexReports and it behaves differently. I have a parent child relationship in my datasource. I want to print the data and present the grouped data in a line chart below the data. The data groups properly. But the Chart after each grouped set is a graph of all the data not the grouped data. I have the chart in the GroupFooter.

  How dow I tell the Chart to use the Group data? I see no filter property. I did set Y1Expression to my filter request but it had no effect.

• 

  esha.dhir

  

  • Post Options:
  • Link
    Copy

  Posted 3 May 2018, 1:24 am EST

  Hello,

  We tried to convert a C1Report with grouping based chart to a FlexReport and it turned out to be correct (see “ChartInGroupFooter.zip”). The only difference is that the chart is a Legacy ChartField rather than a FlexChart.
  
  However, even on using a FlexChart, we can add grouping based data to the same. For this, set XExpression and YExpression properties under Series along with the XLabelExpression property. A demo report showing the same is attached (“Products_ChartGrouping.zip”).
  
  The reports are bound to C1Nwind.mdb shipped with the product.
  
  Let us know if you need further assistance.

  Best Regards,
  
  Esha

  ChartInGroupFooter.zipProducts_ChartGrouping.zip

• 

  connellyj

  • Post Options:
  • Link
    Copy

  Posted 3 May 2018, 7:14 am EST

  Thanks!

• 

  connellyj

  • Post Options:
  • Link
    Copy

  Posted 1 November 2018, 12:30 pm EST

  This did not actually help. I still get all the data in the chart in each group footer.
  
  Do I need to change the datasource? It is not working with the group subset of data.

• 

  esha.dhir

  

  • Post Options:
  • Link
    Copy

  Posted 2 November 2018, 5:50 am EST

  Hi,

  Can you please modify the previously attached report and share it back with the issue?
  
  This will help me understand where the issue exactly occurs and thus, I will be able to assist you in the right direction.

  Regards,
  
  Esha