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 |
|
raaj
Posting Yak Master
129 Posts |
 Posted - 2008-05-27 : 10:46:26
|
| Hi,I am having a report named MyReport(in a text box) in the header of the report.Now i want that MyReport to be of fontsize 16 in the first page of the report and fontsize 10 in all the remaining pages of the report.how is it possible??i am trying to put as font= and fontsize= in the IIF statement, but its saying unidentified error.....Thanks,Raaj |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-27 : 11:20:50
|
| Have you tried giving an expression for font size property of report? |
 |
|
|
raaj
Posting Yak Master
129 Posts |
Posted - 2008-05-27 : 22:36:02
|
| Hi Visakh,thts wht i am not able to understand how to give an expression for the font size property of the report...Thanks,Raaj....... |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-29 : 07:37:22
|
quote:
Originally posted by raaj
Hi Visakh,thts wht i am not able to understand how to give an expression for the font size property of the report...Thanks,Raaj.......
Select the textbox click the properties icon on top to view properties tab for textbox. expand font property, which will have 4 subproperties - FontStyle,FontFamily,FontSize,FontWeight. Click combo on side of FontSize and select expression, expression window opens. then wrte expression for it like=IIF(Globals!PageNumber.Value=1,"16pt","10pt") |
|
|
|
raaj
Posting Yak Master
129 Posts |
Posted - 2008-05-29 : 22:24:26
|
| Thats perfect....Thanks Visakh.........Raaj...... |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-30 : 05:52:20
|
quote:
Originally posted by raaj
Thats perfect....Thanks Visakh.........Raaj......
You're welcome  |
|
|
|
|
|
|
|
|
changing the fontsize.....