Hi I have a new issue now. I created a report to chow some information based on a code. First of all my report runs off of an extract created by us. what my report does is it pulls the data for last five years based on a date selected in the parameters.
I want to show the totals in the footer for all the five years that are displayed in the report. My main report is a cross tab report.
Here is a sample of the data, though it's not very clear.
Thanks
2004 2005 2006 2007 2008 Total
60 Strain; NOC 2 19 14 13 9 57
56 Strain; lifting 0 7 10 8 5 30
82 Misc; ingestion 0 6 4 6 6 22
50 Vehicle; NOC 0 8 3 2 6 19
81 Injured; struck 0 4 2 5 7 18
31 Fall; NOC 0 5 5 4 3 17
55 Strain; holding 0 7 1 3 5 16
57 Strain; pulling 0 7 3 4 2 16
90 Misc; not phys 1 4 9 2 0 16
68 Strike; object 0 3 5 1 6 15
80 Injured; others 0 3 4 2 5 14
19 Cut; NOC 0 2 2 5 3 12
53 Strain; twist 0 3 4 3 2 12
29 Fall; same lev 0 3 1 2 4 10
79 Injured; object 0 2 1 3 4 10
59 Strain; tools 0 4 3 1 1 9
70 Strike; NOC 0 2 1 4 2 9
85 Injured; animal 0 3 3 2 1 9
89 Misc; crime 0 8 0 1 0 9
75 Injured; flying 0 4 0 4 0 8