-
1. Re: change label caption from a stored procedure result
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.
-
2. Re: change label caption from a stored procedure result
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,
-
3. Re: change label caption from a stored procedure result
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.
-
4. Re: change label caption from a stored procedure result
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,
-