Load SQL Function in SSRS Header or Footer

Today I had an interesting problem that I believe is common with SSRS so I wanted to share my solution.  I had a new requirement to display the result of a SQL function into the header of a report.  Quickly, I found out that you cannot drag a dataset item into the header.  To solve this problem I created a new internal parameter that obtains its default value from the dataset I wanted to display on the header.

In this example I have an Id that is passed into the report as a parameter. I call a SQL function in a dataset that displays a different identifier based on the criteria inside the SQL function.    Below is an image that displays the setting I used for the internal parameter.

image

Once this parameter exist I was able to use the following code in the header section to display your data returned from the SQL function.

Parameters!ConflictReportId.Value

Microsoft is coming to Wheeling AITP Meeting

This month’s meeting of the Greater Wheeling Chapter of AITP  is titled Virtualization with Hyper-V and will be held at The White Palace in Wheeling Park on Wednesday, February 11, 2009.   

 

Ian Lindsay will present Virtualization with Hyper-V.  Ian is a Account Technology Specialist with the Microsoft Corporation located in Pittsburgh, PA.

 

Virtualization with Hyper-V presented by Microsoft.  How does virtualization fit into Microsoft?  What is the virtualization capability with Windows Server 2008?  Through this meeting you will be able to understand licensing for virtualization and also determine what investments and resources are needed.  Ian will also welcome questions and answers through the session. 

 

Ian had been in the IT industry for over 20 years, with the last nine (plus) spent at Microsoft Corporation.  As an Account Technology Specialist, Ian is responsible for providing solutions and architectural guidance to core healthcare and financial services customers in Microsoft’s Pittsburgh Account group.  Ian’s experiences range from software development on UNIX to designing enterprise network infrastructures using the latest technologies.  Prior to joining Microsoft, Ian was Operations Manager with Actium Corporation (now Idea Integration).  He was responsible for the Actium network infrastructure, as well as running the Actium Training organization and providing training on all of Microsoft’s BackOffice products. 

 

Social hour will start at 5:30.  Dinner will be at 6:15.  Meeting/presentation will follow dinner.  Cost for the evening is $18.00 for AITP members, $10.00 for AITP student members, and $23.00 for guests, which includes a buffet dinner at Wheeling Park.

Please reply to this e-mail message or e-mail Karen at kkovacs@dwc.org, or go to the Greater Wheeling Chapter’s website at http://www.aitp-wheeling.org  to make reservations.  Reservations are essential to ensure there is sufficient food and seating available for our group.  Please respond early to give the restaurant ample time to prepare.  No shows will be billed for the reserved meal. 
 

 

My First Post.

Being an IT professional with a focus on the legal industry I am glad to say that I have a place on the web.  With Justin Siebert and Ted Cromwell pleading WordPress I am joining the dark side and leaving the Microsoft stack for this blog.  I am primarly a ASP.NET developer and a SQL Server guru. I look forward to communicating with several IT professionals through this site.