Page 1 of 1
Report in an array?
Posted: Wed Jan 13, 2016 2:35 pm
by saultpastor
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
Re: Report in an array?
Posted: Mon Jan 18, 2016 6:22 am
by admin
saultpastor,
Is this to be a Report or a csv or excel?
And does the data currently sit in a table.
Steven
Re: Report in an array?
Posted: Mon Jan 18, 2016 4:11 pm
by saultpastor
admin wrote:
Is this to be a Report or a csv or excel?
And does the data currently sit in a table.
Steven,
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
Re: Report in an array?
Posted: Mon Jan 18, 2016 11:25 pm
by admin
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
Re: Report in an array?
Posted: Tue Jan 19, 2016 4:22 pm
by saultpastor
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.
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.
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
Re: Report in an array?
Posted: Wed Jan 20, 2016 2:36 am
by admin
Craig,
You can export the database with phpmyadmin and email it to
info@nubuilder.com if you like.
Steven
Re: Report in an array?
Posted: Wed Jan 20, 2016 1:41 pm
by saultpastor
email sent,
Thanks,
Craig
Re: Report in an array?
Posted: Mon Jan 25, 2016 5:29 am
by admin
Craig,
We didn't get anything.
Steven
Re: Report in an array?
Posted: Mon Jan 25, 2016 4:06 pm
by saultpastor
I sent it again, This time to both
info@nubuilder.com and
info@nusoftware.com.
Thanks,
Craig
Re: Report in an array?
Posted: Fri Feb 12, 2016 3:07 am
by admin
Craig,
I still haven't seen it, maybe try
steven@nubuilder.com
Steven