asked on

Crystal Reports Return All Records

Hello,
I have a simple report, (or so I thought), that I run to see what hours our machines centers are running every day. The report works fine, except, I need to see the machine centers that do not have any time reported against them as well. What I mean is if the machine center does not run at all on any given day I need to see it on the report with zero time. There are only two tables, the machine center table that has all the specific machine center data and a labor table that shows when and how much time has been reported against it. Is what I am looking for possible? I have included a copy of the report in case that helps. Thank you.MCTR_LABOR_DATE_RANGE.rpt

Mike McCracken

Since you are filtering on the Labor table it is difficult to see machine with no labor.
Try this

Create a new report
Use just the machine table
Add a group on the machine name
Put the machine information in the group header
In the group footer add you other report as a subreport
Link the reports on the machine id

mlmcc

Dave Stone

ASKER

Thank you. I am not quite sure I understand but I will give it a try.

Mike McCracken

If you need more help just ask

mlmcc

vasto

You are using inner join and it shows just the records , which exist in both tables. Change it to left join or right join depending on the table you want to get all records. As it is on the picture bellow if you change it to left join it will include all records from tcslabor.lmctr and for tcsmctr.mctrcd you will see some empty rows ( when a matching record is missing)
If you use right join you will see all records from tcsmctr.mctrcd
User generated image

Dave Stone

ASKER

Thank you but this did not work for me.

vasto

Try left join

ASKER CERTIFIED SOLUTION

Mike McCracken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Dave Stone

ASKER

Thank you.