Rebuild the report writer to be more user friendly and allow for more custom report and names. 20 reports is just not enough spaces.
by: Loren B. | over a year ago | Other
Votes
28
Report Writer
by: Loren B. | over a year ago | Other
Comments
When creating a calculated field to add to a report the calculation doesn't work properly.
Example:
I have 2 formulas to combine into one calculation
Formula 1 Sums the totals of a group of related payroll calculations if the timecard lines aren't related to a Job or equipment (Note: I had to use the cost code field hear because the calculated field can't accept the IF statement referencing 2 fields with zero or null values)
(IF(tmcdln.cstcde = 0 )THEN([Select Sum(Tmcddd.Amount) From Tmcddd Where (Tmcddd.ClcNum = 8 OR Tmcddd.ClcNum = 9 OR Tmcddd.ClcNum = 10 OR Tmcddd.ClcNum = 11 OR Tmcddd.ClcNum = 41 OR Tmcddd.ClcNum = 63 OR Tmcddd.ClcNum = 67) And Tmcddd.RecNum = {PayRec.RecNum}])ELSE(0))
Formula 2 Calculates the number of none job/equipment hours as a subset of the total hours for the time card
([SELECT tmcdln.hrswrk FROM tmcdln WHERE tmcdln.cstcde = 0]) / (tmcdln.hrswrk)
Each of these calculations works separately and provides the correct answer for the test data. But when I combine them into a single calculation where I divide Formula 1 by Formula 2, I get a zero result even though the result should be a positive number.
This is just one example of the difficulty in working with this report writer.
The calculated fields should be able to handle this simple calculation but it can't. The SQL statement option doesn't work any better. I can create a query in SSMS that does exactly what I want, but I can't use the query as a SQL statement in the calculated fields because it doesn't have the functionality to do most of the basic stuff SSMS can do.
This is just another example of why the report rewriter needs to be rewritten or better yet add a crystal runtime to the program to allow crystal reports to be run from Sage 100 Contractor.
The report writer is very limiting.