Skip to Content
0
Aug 02, 2016 at 04:32 PM

Dynamic Field Names issue

41 Views

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.