Page 1 of 2
Report with criteria
Posted: Mon Oct 14, 2019 3:31 pm
by mariri
Hi guys!
Is it possible to run a report with some criteria choosen by the user with the report builder ?
For example, I have a table named 'person'. I want a report which lists all the persons who were born between two dates defined by the user.
Thanks for ur help !
Re: Report with criteria
Posted: Mon Oct 14, 2019 4:57 pm
by mariri
Ok I got it ! If it helps someone, I find the solution in the user guide (
https://www.nubuilder.com/storage/pdf/n ... rGuide.pdf on page 62)
Re: Report with criteria
Posted: Thu Oct 17, 2019 12:01 am
by admin
Well done.
Re: Report with criteria
Posted: Tue Apr 28, 2020 2:04 am
by kknm
I am trying to create a form with the criteria (Start Date - End Date) based on the table zzzzsys_setup - according to the manual page 67, where it says "You do not need to fill out any other fields on the Form Screen." But when saving, the error is -
"Must have at least 1 Tab Column Defined..
Must have at least 1 Browse Column Defined..
Maybe this is because I did not create a button for the end user (manual page 63-64), because this form with criteria will be applied to many reports and users.
Re: Report with criteria
Posted: Thu Apr 30, 2020 4:16 pm
by kev1n
"Must have at least 1 Tab Column Defined..", means you need to enter a
Title and
Order.
E.g.
Main for the Title and
10 in the Order field.
tabs.jpg
Re: Report with criteria
Posted: Thu Apr 30, 2020 4:19 pm
by kev1n
"Must have at least 1 Browse Column Defined....", means you need to have at least 1 Browse Column
browse_column.jpg
Re: Report with criteria
Posted: Fri May 01, 2020 1:12 pm
by kknm
Thanks it helped.
Re: Report with criteria
Posted: Tue Jun 02, 2020 3:04 am
by admin
.
Re: Report with criteria
Posted: Sat Aug 29, 2020 8:31 pm
by treed
kknm wrote:
I am trying to create a form with the criteria (Start Date - End Date) based on the table zzzzsys_setup - according to the manual page 67, where it says "You do not need to fill out any other fields on the Form Screen." But when saving, the error is -
"Must have at least 1 Tab Column Defined..
Must have at least 1 Browse Column Defined..
Maybe this is because I did not create a button for the end user (manual page 63-64), because this form with criteria will be applied to many reports and users.
I am trying to do a similar task with nuBuilder as kknm, Print a report with input parameters. The link above is broken and when looking at the current user manual the referenced info seems to be on page 69. The problem is that the example shown appears to create an action button that just runs the report and no parameters are passed. So going back to the original posters question, how does a developer pass parameters to a report?
Re: Report with criteria
Posted: Sun Aug 30, 2020 6:41 am
by kev1n
Hi,
Where is the data that is passed to the report? (In a form, table,...?)
Also read this:
https://forums.nubuilder.cloud/viewtopic. ... 17&p=21705