Welcome to the nuBuilder forums!
Please register and login to view forums and other content only available to registered users.
Please register and login to view forums and other content only available to registered users.
Report in an array?
-
- Posts: 42
- Joined: Sat Jul 18, 2015 8:04 pm
- Has thanked: 1 time
Report in an array?
I need to submit a monthly report to the government that functions like this:
I realize there probably isn't an easy way, maybe someone could suggest a work around etc. I can't avoid the report and I would like to take the data that already exists and avoid hand transferring it each month.
Thanks,
Craig
I realize there probably isn't an easy way, maybe someone could suggest a work around etc. I can't avoid the report and I would like to take the data that already exists and avoid hand transferring it each month.
Thanks,
Craig
-
- Site Admin
- Posts: 2791
- Joined: Mon Jun 15, 2009 2:23 am
- nuBuilder Version: 4.5
- Been thanked: 4 times
Re: Report in an array?
saultpastor,
Is this to be a Report or a csv or excel?
And does the data currently sit in a table.
Steven
Is this to be a Report or a csv or excel?
And does the data currently sit in a table.
Steven
-
- Posts: 42
- Joined: Sat Jul 18, 2015 8:04 pm
- Has thanked: 1 time
Re: Report in an array?
Steven,admin wrote:
Is this to be a Report or a csv or excel?
And does the data currently sit in a table.
Ideally this would be a report generated by nuBuilder. Currently we run a report for training and response and plug the data (by hand, no csv) into a spreadsheet template.
The data resides in 3 Tables: employee, training, response. Both 'training' and 'response' use the employee tables primary key as a foreign key, each row listing a unique employee and the date. The the query would search the 'training' and 'response' tables for dates, put them across the top of the report in sequence. Then all active employees would be listed in the column on the left side and the grid would indicate present under each date that the employee attended.
I recently built a report that compiles all the volunteer hours for each member and prints out a letter on our letterhead for their volunteer tax credit. It is a big hit with our officers (we are a volunteer fire department) so if I can come up with a way to do this report it would ensure 100% buy in for the new "computer system".
To all the devs, thanks for this great platform, your hard work is amazing and appreciated.
Craig
-
- Site Admin
- Posts: 2791
- Joined: Mon Jun 15, 2009 2:23 am
- nuBuilder Version: 4.5
- Been thanked: 4 times
Re: Report in an array?
saultpastor,
I have a few questions.
Why are these columns in an odd order? .. tra_date res_date res_date tra_date res_date tra_date
Where is the date used.
If you send me a zipped sample of your database I can take a quck look.
Steven
I have a few questions.
Why are these columns in an odd order? .. tra_date res_date res_date tra_date res_date tra_date
Where is the date used.
If you send me a zipped sample of your database I can take a quck look.
Steven
-
- Posts: 42
- Joined: Sat Jul 18, 2015 8:04 pm
- Has thanked: 1 time
Re: Report in an array?
The columns are in an odd order because lets say there is a training night every Wednesday, but before the next Wednesday arrives there are two responses. So the columns of the report would be the possibles dates for attendance for the month in ASC order. The rows of the report would be the employees. This is why I called it an array, but I may not be using the correct terminology.admin wrote:
I have a few questions.
Why are these columns in an odd order? .. tra_date res_date res_date tra_date res_date tra_date
Where is the date used.
If you send me a zipped sample of your database I can take a quck look.
Sorry, I'm not sure how to send the DB file. It's not a problem sending it to you, It just has information I wouldn't want to post on the forum.
Craig
-
- Site Admin
- Posts: 2791
- Joined: Mon Jun 15, 2009 2:23 am
- nuBuilder Version: 4.5
- Been thanked: 4 times
Re: Report in an array?
Craig,
You can export the database with phpmyadmin and email it to info@nubuilder.com if you like.
Steven
You can export the database with phpmyadmin and email it to info@nubuilder.com if you like.
Steven
-
- Posts: 42
- Joined: Sat Jul 18, 2015 8:04 pm
- Has thanked: 1 time
-
- Posts: 42
- Joined: Sat Jul 18, 2015 8:04 pm
- Has thanked: 1 time