KoolReport's Forum

Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines

Report Variables #16

Open Nick opened this topic on on May 25, 2017 - 12 comments

Nick commented on May 25, 2017

Hi,

I can't find a simple way of placing report variables into a report, like https://www.koolreport.com/examples/reports/cube/sales_by_quarters/index.php which allows you to select the year.

Is this something in koolreports, or do we hand craft this part?

Many thanks

Nick

Peter Williams commented on May 25, 2017

Hi Nick,

Could you please check this wiki How to insert parameters to KoolReport?

Please let us know if the wiki has not been clear to you so I can explain further.

Regards,

Peter

Nick commented on May 25, 2017

Hi Peter,

I tried that, but it didn't render anything on the page - so I just assumed this was a fixed parameter - not one which creates an input field.

If it is then I am doing something wrong?

KR

Nick

Peter Williams commented on May 25, 2017

In general, a report is just an object which is able to receive parameters/inputs at its creation. Those parameters will be available in setup() method so that we can pull data, process them or display them accordingly.

Could you please post me some code here so I may know what went wrong.

Peter Williams commented on May 27, 2017

Hi Nick,

Are you able to get it done? The "year"=>2005, please make a simple <input> for user to enter year when you can transmit the variable to the report.

Regards,

Peter

Hallie Gromek commented on Jun 27, 2017

Can you show me how I should set up a report that uses the KoolSuitePHP combo box? I have a database list I need to be variables (choice of customers). Not sure if <input> can be a session_variable, also not sure how it should look aesthetically, to the left or on top. All the examples show they are manually created variables.

KoolReport commented on Jun 29, 2017

You just make a <form>, put a <select> with options created by the the list you get from database. In the params of KoolReport, catch the $_POST value and insert into it. To make things easier, we are making a small package called inputs which will facilitate this processes. If you can wait abit then I will create examples for you.

Hallie Gromek commented on Jun 29, 2017

Do you have a timeline for this? I think the input package will work best for me. Curious how the package will look, I am very excited for these reports, and this inputs are key for me. Will it include a SORTABLE FIELD option? for example I have Customer, Client, items, I would love to give people the option to decide what they want to show and in what order! Thanks

KoolReport commented on Jun 30, 2017

Can you tell me more details of SORTABLE FIELD options? If you can include a simple image to show, that will be awesome.

Hallie Gromek commented on Jun 30, 2017

Just my two cents!

so our out-dated system that we currently run reports out of (that hopefully we can replace by KoolReport) has a screen like this. I can't see that working well with the look we are going for on KoolReport, I kinda picture more like a "create what a pivot report will look like", for implementing it could be more like Order1 [dropdown choice] Order2 [dropdown choice] order3 [dropdown choice] and this would be the order of the Pivot dimensions "row".

I am so curious how you are going to make the inputs looks - popup, opening screen, no the same report screen?

KoolReport commented on Jun 30, 2017

Hi Hallie,

Thank you for your comments with image. That helps me understand better. The inputs package will contain set of input controls such as text-input, checkbox, radios, dropdownlis so that you can put them into your report. Those inputs are bound to params of report.

Hallie Gromek commented on Jul 1, 2017

can't wait! thanks

KoolReport commented on Jul 7, 2017

Hi Hallie,

Just to let you know that we have release the KoolReport 1.32.8 and also the Inputs package.

Regards,

KoolPHP Inc

Build Your Excellent Data Report

Let KoolReport help you to make great reports. It's free & open-source released under MIT license.

Download KoolReport View demo
None yet

None