Hi
I am trying to have a reports query parameters set via a form. However, I am unsure how to get the following:
I want to show statistics against states for a defined year. The state names stay the same, as I have a column for each state name, but I want the report user to be able to define the year to be queried. So far in the query I have the following
Feild Name- NSW: IIf([state/div]="NSW",([2001-02]))
This provides me with all the Statistics assigned against NSW, however, how do I change the year from 2001-02 to 2000-01 via a form parameter?
Any suggestions would be appreciated.
Thanks
I am trying to have a reports query parameters set via a form. However, I am unsure how to get the following:
I want to show statistics against states for a defined year. The state names stay the same, as I have a column for each state name, but I want the report user to be able to define the year to be queried. So far in the query I have the following
Feild Name- NSW: IIf([state/div]="NSW",([2001-02]))
This provides me with all the Statistics assigned against NSW, however, how do I change the year from 2001-02 to 2000-01 via a form parameter?
Any suggestions would be appreciated.
Thanks