Search results for query: *

LB: Your solution worked perfectly! I needed to use {?Sales Rep} as the Main Report field to link to and as the Subreport field to use. Thank you so much!

Yes, ?Sales Rep is part of the selection criteria in the subreport. For example in Subreport 1, the selection criteria is: {Employee.EmployeeName} = {?Sales Rep} and {JrnlHdr.JrnlKey_Journal} = 3 and {JrnlHdr.TransactionDate} >= {?Start Date} and {JrnlHdr.TransactionDate} <...

I am using Crystal Reports 2008 with Peachtree Premium 2012, a PSQL database engine. I created a report with 2 subreports. The main report lists the sales reps and the total sales for each sales rep. Subreport 1 and 2 are copies of the main report. The main report shows the total sales for 3...

Perfect! Thank you, Ian. I did exactly what you suggested. I eliminated the {?Date Range} parameter and eliminated the selection statement {JrnlHdr.TransactionDate} = {?Date Range}. In the main report, I added the parameter {?StartDate} and added the selection statement...

I am using Crystal Reports 2008 with Peachtree Premium 2012 - PSQL is the database engine. I created a report and saved it as a new report two additional times. I opened the original report and inserted into the Report Footer A, a subreport which is a copy of the orginal. I inserted into the...

Thank you, Cospringsguy. I do need to perform the calculation even when the amount is negative, so my formula ended up as: If Sum ({@Total Testers}, {JrnlHdr.EmpRecordNumber}) = 0 then 0 else (Sum ({@Total Testers}, {JrnlHdr.EmpRecordNumber})/Sum ({@Total Sales}, {JrnlHdr.EmpRecordNumber}) * 100)

I am using Peachtree Premium 2012, Crystal Reports 2008, pervasive sql is the database engine. I am trying to create a formula to divide one field by another and eliminate the risk of dividing by 0. My formula is: (If {@Total Testers} <> 0 or if {@Total Sales} <> 0) then ({@Total...