Report Management - Professional SQL Server 2005 Reporting Services - page 454

Case “gif”
retVal = “image/gif”
Case “bmp”
retVal = “image/bmp”
Case “jpg”
retVal = “image/jpeg”
Case “jpeg”
retVal = “image/jpeg”
End Select
Return retVal
End Function
Generating Scripts
SQL Server Management Studio is a handy source for procedures and snippets of code to use in your
own scripts. Many actions can be saved as script. The scripts are complete enough to run on their
own, and run against the same RS utility. To capture a script, simply perform an action in SQL Server
Management Studio and then find the Script button. Figure 10-25 shows an example of changing a
schedule.
Figure 10-25