Ok, I've experimented with a the GROUP by function and can get the YEAR to show on all columns, but below the column header (State Aid, Local Receipts, Other Revenue,...

Hello,

Sorry for the late repsonse. Didnt check this much over the weekend. I apologize, you are correct about the 2011 showing to the RIGHT on the report....

Only filtered through a couple of the resposnes, but I like this one the best. Adding datasets is always a simple solution around problems like these. I use...

Awesome, worked like a charm. I ened up switching the WHERE clause to read;

WHERE (A_6.FISCAL_YEAR IN (:Year)) AND (A_6.NAME IN (:Community)) AND ((F."Population" BETWEEN...

Here's the WHERE clause:

WHERE (A_6.FISCAL_YEAR IN (:Year)) AND (A_6.NAME IN (:Community)) AND (F."Population" BETWEEN (:MinimumPopulation) AND (:MaximumPopulation))

Forget about the :Year and :Community clauses, I'm focused on...

yes, yes very useful. Thanks for the links. Rather than set ranges for each parameter, I simply used a BETWEEN clause and I'm allowing the user to define...

I wouldnt call myself a programmer just yet haha.

Sorry, I'm a bit confused myself. I could paste into the text box so I included a screenshot on a word doc. Hopefully it helps.

The screenshot shows...

Ok, thanks for your help. I already ahve two additional parameters on this report, and I'm almost positive I have them set up in the correct location. I...

Hmmm, I'm not sure I follow. I have a total of 11 ranges I need to set parameters for. I would like to see them all under the...