27666 total geeks with 3538 solutions
Recent challengers:
 Welcome, you are an anonymous user! [register] [login] Get a yourname@osix.net email address 



User's box

Forgot password?
New account

<strong><a href="http:/ /www.pens74. ru/">montbla nc pen</a></str ong> | <strong><a href="http:/ /www.pens74. ru/">montbla nc pen</a></str ong> | <strong><a href="http:/ /www.pens74. ru/">mont blanc</a></s trong> <br> <title>Montb lanc Meisterstuck Carbon &amp; S
<strong><a href="http:/ /www.tiffany andcosilver. com/">tiffan y blue</a></st rong> <br> <strong><a href="http:/ /www.tiffany andcosilver. com/">tiffan y blue</a></st rong> <br> <strong><a href="http:/ /www.tiffany andcosilver. com/">tiffan y outlet</a></ strong> <br> <
<ul><li><str ong><a href="http:/ /www.yxypd.c om/">swiss Mechanical movement replica watches</a>< /strong> </l i><li><stron g><a href="http:/ /www.yxypd.c om/">watches price</a></s trong> </li> <li><strong> <a href="http:/ /www.yxypd.c om/">best replica watches</a>< /s
<strong><a href="http:/ /watches.wed dingdresstre nd.org/">hig h quality swiss replica watches</a>< /strong> | <strong><a href="http:/ /watches.wed dingdresstre nd.org/">wat ches</a></st rong> | <strong><a href="http:/ /watches.wed dingdresstre nd.org/">swi ss Mechan
[b]<a href="http:/ /www.shzwbg. com/">swiss rep<strong>< a href="http:/ /www.shzwbg. com/">swiss replica watches aaa+</a></st rong> <br> <strong><a href="http:/ /www.shzwbg. com/">swiss replica watches</a>< /strong> <br >

Donate and help us fund new challenges
Due Date: Oct 31
October Goal: $40.00
Gross: $0.00
Net Balance: $0.00
Left to go: $40.00

News Feeds
The Register
can hack
smartphones, says
Snowden. Again.
Potent OWA backdoor
scores 11,000
corporate creds
from single biz
used by PRINCESS
LEIA sold for just
Cisco reforms its
security disclosure
NoSQL pioneer Basho
stamps its mark on
time stamp data
with Riak TS
Linux kernel dev
who asked Linus
Torvalds to stop
verbal abuse quits
over verbal abuse
Quantum Pentium
appears on the
Google bugle sounds
patch release for
Android Stagefright
If you wanted
Windows 10, it
looks like you"ve
already installed
Fast, wireless
access to Tor? Just
EFF Joins Nameless
Coalition and
Demands Facebook
Kills Its Real
Names Policy
London Mayor Boris
Johnson Condemns
Random Uber
Space Travel For
the 1%: Virgin
Galactic"s $250,000
Tickets Haunt New
Mexico Town
What Effect Will
VW"s Scandal Have
On Robocars?
Study Finds Humans
Are Worse Than
Radiation For
Chernobyl Animals
DNA Vaccine
Sterilizes Mice,
Could Lead To
One-Shot Birth
Control For Cats,
What Non-Geeks Hate
About the Big Bang
Ask Slashdot: What
Is Your Most
Awesome Hardware
Linux Kernel Dev
Sarah Sharp Quits,
Citing "Brutal"
CodeWeavers To
Release CrossOver
For Android To Run
Windows Programs
Article viewer

List parameters from an SSRS (SQL Server Reporting Services) report into an expression.

Written by:bb
Published by:bb
Published on:2006-10-24 07:55:46
Search OSI about Dot.Net.More articles by bb.
 viewed 25964 times send this article printer friendly

Digg this!
    Rate this article :
How to get a list of parameters and their values from an SSRS (SQL Server Reporting Services) report from within an expression of the report. Its a nice way to echo out all parameters a report was run with without having to hardcode and means you can implement standard footers easily.

I found some tips for doing this on James Kovacs' Weblog. But the code wasnt there, so here it is if you wish to implement it. Another useful msdn article is here.

I am using the imported DLL mechanism of writing code for reports (rather than the inline Code section) Simply add this method to an assembly and reference it in your report. Remember to copy the dll to "C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\" to test it when previewing from Visual Studio.

To call this function put a TextBox on your report, edit the expression and add the line
=YourDll.DisplayParams(Parameters, "Param1, Param2");

The function for the assembly
using Microsoft.ReportingServices.ReportProcessing.ReportObjectModel;

/// Builds a list of SQL Server Reporting Services Parameters based on a parameter object
/// and a comma delimited string of param names
public static string DisplayParams(Parameters obj, string strParams)
    StringBuilder sbRet = new StringBuilder();
        //parameters in comma delimited list which matches
        //the name of the parameter in the collection.
        foreach (string sParam in strParams.Split(','))
            //the name of the parameter
            sbRet.Append(String.Format("{0}: ", sParam));

            //concat parmaeter values
            if (obj[sParam].IsMultiValue)
                for (int i = 0; i < obj[sParam].Count - 1; i++)
                    sbRet.Append(String.Format("{0} : ",
                sbRet.Append(String.Format("{0}", obj[sParam].Label).Trim());

            //remove any trailing commas
            if (sbRet.ToString().EndsWith(", "))
                sbRet.Remove(sbRet.Length - 2, 2);

                        // seperator for each parameter
                        sbRet.Append("; ");
    catch (Exception)
        return "Error building parameter list";

    return sbRet.ToString();

Did you like this article? There are hundreds more.

Anonymously add a comment: (or register here)
(registration is really fast and we send you no spam)
BB Code is enabled.
Captcha Number:

Blogs: (People who have posted blogs on this subject..)
ASP.NET RadioButton GroupName when inside a Repeater on Sun 10th Jun 8am
I was thankful on finding this nugget of code, which makes the groupname work out when slamming in radiobuttons in an asp.net repeater. http://www.codeguru.com/csharp/csharp/cs _controls/custom/article.php/c12371/

Your Ad Here
Copyright Open Source Institute, 2006