Welcome to the nuBuilder forums!

Please register and login to view forums and other content only available to registered users.

Report in an array?

Post Reply
saultpastor
Posts: 39
Joined: Sat Jul 18, 2015 8:04 pm

Report in an array?

Unread post by saultpastor »

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
admin
Site Admin
Posts: 2778
Joined: Mon Jun 15, 2009 2:23 am
nuBuilder Version: 4.5

Re: Report in an array?

Unread post by admin »

saultpastor,

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

And does the data currently sit in a table.

Steven
saultpastor
Posts: 39
Joined: Sat Jul 18, 2015 8:04 pm

Re: Report in an array?

Unread post 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
admin
Site Admin
Posts: 2778
Joined: Mon Jun 15, 2009 2:23 am
nuBuilder Version: 4.5

Re: Report in an array?

Unread post 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
saultpastor
Posts: 39
Joined: Sat Jul 18, 2015 8:04 pm

Re: Report in an array?

Unread post 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
admin
Site Admin
Posts: 2778
Joined: Mon Jun 15, 2009 2:23 am
nuBuilder Version: 4.5

Re: Report in an array?

Unread post by admin »

Craig,

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

Steven
saultpastor
Posts: 39
Joined: Sat Jul 18, 2015 8:04 pm

Re: Report in an array?

Unread post by saultpastor »

email sent,

Thanks,

Craig
admin
Site Admin
Posts: 2778
Joined: Mon Jun 15, 2009 2:23 am
nuBuilder Version: 4.5

Re: Report in an array?

Unread post by admin »

Craig,

We didn't get anything.

Steven
saultpastor
Posts: 39
Joined: Sat Jul 18, 2015 8:04 pm

Re: Report in an array?

Unread post by saultpastor »

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

Thanks,
Craig
admin
Site Admin
Posts: 2778
Joined: Mon Jun 15, 2009 2:23 am
nuBuilder Version: 4.5

Re: Report in an array?

Unread post by admin »

Craig,

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

Steven
Post Reply