Friday, 12 October 2012

NextReports: Charts Dynamic Series

When you define your chart in NextReports Designer, you have to select what to see on X axis and on Y axis. By selecting more columns (series) on Y axis, user will be able to see comparative data.

Till version 5.4, NextReports was able to select static columns and legends. But there are situations when you want your chart to show all existing series from a specific business. For example to see the type count  for some products, but you have a dynamic list of products: some products may be removed or some may be created in the future. And you do not want to change the chart anytime a change to that list of products is done.

To establish this:
  •  user must create the chart query  in a dynamic mode (no hard-coding)  with a simple sql query or  with a procedure call (a procedure call may be more suitable in most of the cases)
  • user will leave the  Y column unselected in chart layout (also no legend has to be entered)

  • user will enter an sql (simple query or procedure) inside a  new property called "column query" which must return string pairs of {column name, column legend}

When the chart is run, the dynamic columns are computed and they are used as the series. In this way any new changes to our list of products will be automatically seen inside the chart.

This new feature will bring more flexibility to NextReports starting with 5.4 version.

1 comment:

  1. IEEE Final Year projects Project Centers in Chennai are consistently sought after. Final Year Students Projects take a shot at them to improve their aptitudes. IEEE Final Year project centers ground for all fragments of CSE & IT engineers hoping to assemble.Final Year Projects for CSE

    Spring Framework has already made serious inroads as an integrated technology stack for building user-facing applications. Spring Framework Corporate TRaining .

    Specifically, Spring Framework provides various tasks are geared around preparing data for further analysis and visualization. Spring Training in Chennai

    The Angular Training covers a wide range of topics including Angular Directives, Angular Services, and Angular programmability.Angular Training