Report with criteria

[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 !

[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)

[admin]

Well done.

[kknm]

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)

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.

[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 (16.7 KiB) Viewed 2238 times

[kev1n]

"Must have at least 1 Browse Column Defined....", means you need to have at least 1 Browse Column

browse_column.jpg (31.72 KiB) Viewed 2238 times

[kknm]

Thanks it helped.

[admin]

.

[treed]

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)

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?

[kev1n]

Hi,

Where is the data that is passed to the report? (In a form, table,...?)

Also read this:
viewtopic.php?f=20&t=10517&p=21705