Page 1 of 1

Best solution to create reporting

Posted: Thu Jun 14, 2018 10:08 am
by 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

Re: Best solution to create reporting

Posted: Wed Jun 20, 2018 10:36 am
by toms

Re: Best solution to create reporting

Posted: Wed Jun 20, 2018 5:03 pm
by 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)

Re: Best solution to create reporting

Posted: Thu Jun 21, 2018 8:48 am
by 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.

Re: Best solution to create reporting

Posted: Tue Jun 26, 2018 5:40 pm
by marcvander
Thanks toms I'll have a look

Re: Best solution to create reporting

Posted: Fri Jun 29, 2018 11:57 pm
by 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

Re: Best solution to create reporting

Posted: Sun Jul 01, 2018 12:13 pm
by marcvander
Thanks steven, I'll have a look