Display certain fields in report based on parameter selection
I have a lot of fields in my table and cannot show them all on my report because the report is not long enough. I only want the few displayed in my details section based on my parameters selection. For example:
I have "Amount" fields ranging from November 2004 till August 2008 in my table, I have two parameter fields "Start Amount Date" and "End Amount Date" and only want to display the fields on the report between those field selection. This report will be used to show YTD(Year To Date) amounts but user wants to see the months values that makes up the ytd value.
Help much appreciated!