I have a Crystal report that pulls from a view in Dynamics GP database and an excel spreadsheet.
It pulls by salesperson.
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