Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dodaniel
Starting Member
11 Posts |
 Posted - 2012-08-13 : 16:30:14
|
| In BIDS I have a textbox that contains Dept_Name in my page header. When my report runs for all departments (by leaving a parameter field blank) I would like for the Dept_Name in the page header to change to match the department that goes with the records on that page of the report. Right now it prints the first department name on all pages of the report. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-08-13 : 16:45:43
|
| you should be including it in body of report them inside a table. the table should be mapped to your dataset. if you want additional details to be included you can apply group on department in table and add department name into its header. you can include other fields inside its detail section------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Change Field Value in Page Header