Hello all, for a quick background on this topic, please reference: thread767-932366
After reading that thread, please proceed to my new question. Quick update: I am now using Crystal XI. There is a report format my company uses that also lists audit dates and scores from the previous two inspections in addition to the previous ones. Of course, the date formatting must still be exactly the same as from the thread referenced above. But with the scores thrown in, that changes things a little bit. The current audit information is not needed. So although the current audit information will be in the database, only the previous two are needed. Here is a desired output example:
July 13 and 14, 2005 -180-170-175-170-180 = 875
July 11 and 12, 2004 -180-185-190-165-180 = 900
The dates and respective scores do need to be on one line. I was thinking of two separate subreports to throw into the final report. That way one subreport contains the previous audit information and the other contains the one before that. I'm not sure if it's doable to have only one subreport, but either way is fine.
As the score information is also included now, I have had to add the Scores table and the Inspections table. Here are the fields included in the Scores table:
Scores.AuditInspectionID
Scores.ScoreCategory (Categories are AP, PC, OP, MS, and CP)
Scores.Score (for the individual category scores)
Scores.ScoreOrder (because of the application our auditors use, this field was used to keep the categories in a specific order - values are 1, 2, 3, 4, and 5 and those values are in the same order as the categories above; i.e., AP is 1 and PC is 2)
I also included the Inspections table for these fields (there are many other fields but I've listed the relevant ones):
Inspections.TotalScore
Inspections.OverallRating
The Inspections.OverallRating field is a string. The reason I included this is because if it was as training audit, the scores will not be listed. The value will be "Training" as opposed to the score output above. If the string states "Refused Entry" or "Cancelled", then the audit information is not to be included. The next audit down the line must be inserted. Hope that makes sense.
So I'm having much difficulties figuring this one out. If anyone could lend a hand I would be greatly appreciative. Please let me know if there are further questions.
Thanks for your time,
Chris
After reading that thread, please proceed to my new question. Quick update: I am now using Crystal XI. There is a report format my company uses that also lists audit dates and scores from the previous two inspections in addition to the previous ones. Of course, the date formatting must still be exactly the same as from the thread referenced above. But with the scores thrown in, that changes things a little bit. The current audit information is not needed. So although the current audit information will be in the database, only the previous two are needed. Here is a desired output example:
July 13 and 14, 2005 -180-170-175-170-180 = 875
July 11 and 12, 2004 -180-185-190-165-180 = 900
The dates and respective scores do need to be on one line. I was thinking of two separate subreports to throw into the final report. That way one subreport contains the previous audit information and the other contains the one before that. I'm not sure if it's doable to have only one subreport, but either way is fine.
As the score information is also included now, I have had to add the Scores table and the Inspections table. Here are the fields included in the Scores table:
Scores.AuditInspectionID
Scores.ScoreCategory (Categories are AP, PC, OP, MS, and CP)
Scores.Score (for the individual category scores)
Scores.ScoreOrder (because of the application our auditors use, this field was used to keep the categories in a specific order - values are 1, 2, 3, 4, and 5 and those values are in the same order as the categories above; i.e., AP is 1 and PC is 2)
I also included the Inspections table for these fields (there are many other fields but I've listed the relevant ones):
Inspections.TotalScore
Inspections.OverallRating
The Inspections.OverallRating field is a string. The reason I included this is because if it was as training audit, the scores will not be listed. The value will be "Training" as opposed to the score output above. If the string states "Refused Entry" or "Cancelled", then the audit information is not to be included. The next audit down the line must be inserted. Hope that makes sense.
So I'm having much difficulties figuring this one out. If anyone could lend a hand I would be greatly appreciative. Please let me know if there are further questions.
Thanks for your time,
Chris
![[yinyang]](/data/assets/smilies/yinyang.gif "[yinyang] [yinyang]")
Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10