Report in an array?

[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

[admin]

saultpastor,

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

And does the data currently sit in a table.

Steven

[saultpastor]

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

[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

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

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

[admin]

Craig,

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

Steven

[saultpastor]

email sent,

Thanks,

Craig

[admin]

Craig,

We didn't get anything.

Steven

[saultpastor]

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

Thanks,
Craig

[admin]

Craig,

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

Steven