The only place that I can get the information to pull from the spreadsheet is in the section that has the Gross Profit calculation.   However, it does not pull the information from the spreadsheet if that Sales Person does not have any sales or Cost of Sales.   Also, if the Gross Profit is 0.00, it prints the section twice, so I added a suppress statement to suppress if 0.  But even if I take that off, it still does not print the spreadsheet field if the salesperson does not have any Sales or Cost of Sales.

 

The spreadsheet only has two fields,  employee id and salarary amount.

 

It is linked on employee id to the salesperson.

 

I need to get it to pull in the salary for that salesperson, even if they do not have any sales or cost of sales.

 

Any ideas?

 

Thanks

Is the salesperson info in one table in the database and the sales/cost of sales in another?  If that is the case, this has nothing to do with spreadsheet and everything to do with how your tables are joined together.  You need to join FROM the salesperson table TO the sales data table.  Then right-click on join and set it to a "Left Outer" join.  This way you'll get the sales person info even if there is no sales data.

 

-Dell

Any other ideas?

 

-Dell