Best solution to create reporting

[marcvander]

Hey,

I need to create some reporting for my system:
-graphs
-total by filters

For graphs, so far I know how to create some and display them. But my question is for the second reporting, total by filters. What is the best solution to build a tool so that the user can enter some filters (with lookup forms/text input/dropdown choices etc.) and get some values based on this filter? (for instance, the user wants to know the total number of invoices in a particular field, in a defined period of time)

Thanks

[toms]

What about Google Charts?

https://forums.nubuilder.cloud/viewtopic. ... art#p16492

[marcvander]

I actually thought about having numbers displayed, not a chart. So far the only option I could think of is building a report (because we can have a launch form with filters)

[toms]

You can create pure tables with google charts too: https://jsfiddle.net/dlaliberte/Lw5h7c2y/

The advantage over reports is that you can display them directly on a form.

[marcvander]

Thanks toms I'll have a look

[admin]

marcvander,

By running nuJavascriptCallback() inside a Procedure and calling that Procedure from nuRunPHPHidden()

you can go to the server get an answer, and return to the browser and populate any field there.

https://wiki.nubuilder.cloud/ ... ptCallback

https://wiki.nubuilder.cloud/ ... nPHPHidden

Steven

[marcvander]

Thanks steven, I'll have a look