I'm not sure if I'm choosing the best way to create a report for my needs and would like your help.
I'm using Crystal Reports 2008.
I need a report that is showing me the summary information for the amount of rejects by type and vendor for a given period and calculate the percentage based on the dollars spent.
I have one database that will have my rejection information and a separate database that has the vendor spend information.
I created a Vendor Issues Summary Report which uses the reject database. Then I created a Vendor Spend Subreport that sums up the spend for a given period.
I tried to put the subreport in the main report and linked on VendorID but I don't get anything to display.
Does this have something to do with where I have the summations? Or because I'm doing summaries?
After I get the total spend dollars I need to perform some calculations to display the impact %
I have attached both my main report and subreport. I also attached a word document that shows that the outcome is supposed to display when the report is finalized. (This was from an old program that we no longer use)
Is this the best way to handle this type of report?