penfold1992
Registered User.
- Local time
- Today, 16:20
- Joined
- Nov 22, 2012
- Messages
- 169
I have a report which has a parameter.
The parameter returns between 1 and 5 results and gives out a report for each result (as expected)
each result will contain a number between 1 and 3 which I was to display as a colored block. (1 = red, 2 = yellow, 3 = green).
normally with a report you would state the field you wish to view but in this case I dont want to show the number, just use the number to display a color.
as there is a parameter, and the fact that the number could change for each result of the report, I dont think I can set up a macro in the reports "open" macro.
does anyone know how I can do this?
in conclusion. On open, I want to get out some numbers, and color some blocks depending on the numbers.
The parameter returns between 1 and 5 results and gives out a report for each result (as expected)
each result will contain a number between 1 and 3 which I was to display as a colored block. (1 = red, 2 = yellow, 3 = green).
normally with a report you would state the field you wish to view but in this case I dont want to show the number, just use the number to display a color.
as there is a parameter, and the fact that the number could change for each result of the report, I dont think I can set up a macro in the reports "open" macro.
does anyone know how I can do this?
in conclusion. On open, I want to get out some numbers, and color some blocks depending on the numbers.