change label caption from a stored procedure result

[iccsi]

I need change label caption on the report using Report Builder and data source from a stored procedure.

Your information and help is great appreciated,

regards,

Iccsi

[EddieLotter]

Where the data comes from is irrelevant to the report. The report will use whatever result-set you give it.

If you elaborate on what you're having difficulty with then perhaps we can get to the bottom of it.

[iccsi]

Thanks for the information and help,

I use stored procedure to return a dataset the column is like following:

Date1, Date2, Date3, Date4, Date5.... etc, because I let user to choose date range and use pivot tables to returns column heading.

I run another query to get all date information and would like to assign those date information to my column heading of the report. It seems that the Report Builder does not allow me to assign a new caption for the label.

Thanks again for helping and information,

Regards,

Iccsi,

[EddieLotter · Accepted solution]

There are at least two ways to handle this.

The first way is to pass the column headings to the report as parameters.

The second is to use a sub-report that uses a one record result-set which contains the column headings. You will need to set the sub-report's margins to zero to get things to line up properly.

[iccsi]

Thanks a million for the information and help,

I use my stored procedure to return my colum heading and have my text on the pager header to link my fields.

Regards,

Iccsi,

[EddieLotter]

You're very welcome.

Glad I could help.