truckbuddy

How to do reports?!?

Discussion created by truckbuddy on Jan 14, 2015
Latest reply on Jan 15, 2015 by thong127

Hey all,

 

I'm still new at this so please bear with me.

 

I've set up my personnel database and it's working amazingly well. Now, however, I want to be able to quickly get information OUT of it.

 

Here's my relationship graph:

 

Screen Shot 2015-01-14 at 8.50.45 PM.png

 

I just want to create a report that shows me how many reviews an employee has gotten. Ideally I'd like to put a button on every employee's Reviews tab, push it, and be able to print off a report. I'd especially like to be able to print a report to see how many 5-star reviews they've gotten on Yelp or A's on Angie's List. But for now, I'd just like to figure out how to get the damn thing to work. Right now when I run through the little layout/report wizard it just gives me a list of employees with one review. I can't even get off the ground here. It seems a little bizarre that creating useful reports with a relational, multiple-table database would be such a carefully guarded secret.

 

Any help is appreciated. Thank you.

 

Chris

Outcomes