Skip to main content
iccsi
Inspiring
May 18, 2013
Answered

change label caption from a stored procedure result

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

This topic is closed to new replies. Start a new post to keep the conversation going.
EddieLotter
EddieLotterCorrect answer
Inspiring
September 17, 2013

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.

View reply

5 replies

EddieLotter
EddieLotter
Inspiring
September 17, 2013

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.

Translate
iccsiAuthor
Inspiring
September 17, 2013

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,

Translate
EddieLotter
EddieLotterCorrect answer
Inspiring
September 17, 2013

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.

Translate
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices