New To Reporting Services...help With Fancy Headers

Ok, I'm new to reporting services and I am wondering if this is possible for headers in a table.

I have a stored procedure that returns the text that I want to display as a header in a report. The input parameter is the database field name. I don't want to put the actual field name as the report header, but the text that I derived from passng in the field name.

I figured I could create a dataset with this stored procedure, and put the header text field that the procedure returns in the header column. However, the problem is that I need to use this same field for each header column in my table and pass in the corresponding field name based on the column that I place this field in.

Unfortunately, I don't see a way to reuse this and pass in different parameters per column, it seems like you can only call the procedure once per dataset and not reuse it per column, leaving me with passing in a single field name and getting the same header text for every column in the table.

I may be able to get around this issue by creating a different dataset for each column in the table and passing in the field name for each dataset, but this sounds like a bad way of doing things.

Does anyone have any ideas or knowledge that can help me in my situation? Basically, I need dynamically changing headers based on an input parameter...if there is another way to do this, pleas let me know, thanks.