I have a stored procedure that when ran, it pivots financial data into Monthly column headers. Each time the user runs it, the @StartDate and @EndDate may change thus the field names for those column headers will also change.
If I drag the fields into the details, then run the report for another date range, I get the error that "one or more fields could not be found."
Question: In formulas I can reference the values within a field, but how do I reference the field NAME so that I can use Dynamic field names?
Cross tabs will not work as I have more than just these monthly columns and have to do very complex formulas on subtotals and totals.