Report in an array?

Report in an array?

Postby saultpastor » Wed Jan 13, 2016 11:05 pm

I need to submit a monthly report to the government that functions like this:
Image

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
saultpastor
 
Posts: 23
Joined: Sun Jul 19, 2015 3:34 am

Re: Report in an array?

Postby admin » Mon Jan 18, 2016 2:52 pm

saultpastor,

Is this to be a Report or a csv or excel?

And does the data currently sit in a table.

Steven
admin
Site Admin
 
Posts: 3079
Joined: Mon Jun 15, 2009 9:53 am

Re: Report in an array?

Postby saultpastor » Tue Jan 19, 2016 12:41 am

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
saultpastor
 
Posts: 23
Joined: Sun Jul 19, 2015 3:34 am

Re: Report in an array?

Postby admin » Tue Jan 19, 2016 7:55 am

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
admin
Site Admin
 
Posts: 3079
Joined: Mon Jun 15, 2009 9:53 am

Re: Report in an array?

Postby saultpastor » Wed Jan 20, 2016 12:52 am

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
saultpastor
 
Posts: 23
Joined: Sun Jul 19, 2015 3:34 am

Re: Report in an array?

Postby admin » Wed Jan 20, 2016 11:06 am

Craig,

You can export the database with phpmyadmin and email it to info@nubuilder.com if you like.

Steven
admin
Site Admin
 
Posts: 3079
Joined: Mon Jun 15, 2009 9:53 am

Re: Report in an array?

Postby saultpastor » Wed Jan 20, 2016 10:11 pm

email sent,

Thanks,

Craig
saultpastor
 
Posts: 23
Joined: Sun Jul 19, 2015 3:34 am

Re: Report in an array?

Postby admin » Mon Jan 25, 2016 1:59 pm

Craig,

We didn't get anything.

Steven
admin
Site Admin
 
Posts: 3079
Joined: Mon Jun 15, 2009 9:53 am

Re: Report in an array?

Postby saultpastor » Tue Jan 26, 2016 12:36 am

I sent it again, This time to both info@nubuilder.com and info@nusoftware.com.

Thanks,
Craig
saultpastor
 
Posts: 23
Joined: Sun Jul 19, 2015 3:34 am

Re: Report in an array?

Postby admin » Fri Feb 12, 2016 11:37 am

Craig,

I still haven't seen it, maybe try steven@nubuilder.com

Steven
admin
Site Admin
 
Posts: 3079
Joined: Mon Jun 15, 2009 9:53 am


Return to Report Writer