Hi
I have a report that is first grouped by Store name and then by District number, and then store numbers; and showing the sales for each month like this:
Tops
District # 1451 Jan Feb March
Store #
1456 100 125 214
2569 125 241 1254
Total 225 366 1468
District Summary
1456 100 241 124
2569 125 314 110
Total 225 555 234
Target
District # 2451
Store #
1446 180 214 0
Total 180 214 0
District Summary
1446 180 214 0
Total 180 214 0
The problem is that they want it to only show the summary for the groups that have more than one store listed. I was told that there is a way, through VBA coding, of setting a counter, that if there is more than one store to go to the next, and the in the event tab the headers property section to out in some code that access this; but I am not sure how to do this. Also they said to look into On Group header, but I could not find anything.
If anyone can help me with this I would appreciate it.
I have a report that is first grouped by Store name and then by District number, and then store numbers; and showing the sales for each month like this:
Tops
District # 1451 Jan Feb March
Store #
1456 100 125 214
2569 125 241 1254
Total 225 366 1468
District Summary
1456 100 241 124
2569 125 314 110
Total 225 555 234
Target
District # 2451
Store #
1446 180 214 0
Total 180 214 0
District Summary
1446 180 214 0
Total 180 214 0
The problem is that they want it to only show the summary for the groups that have more than one store listed. I was told that there is a way, through VBA coding, of setting a counter, that if there is more than one store to go to the next, and the in the event tab the headers property section to out in some code that access this; but I am not sure how to do this. Also they said to look into On Group header, but I could not find anything.
If anyone can help me with this I would appreciate it.