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

Articles

GEEK

User's box
Username:
Password:

Forgot password?
New account

Shoutbox
dkagundyshari
<ul><li><str ong><a href="http:/ /www.cheapmo nclersjacket sales.org/"> moncler sale</a></st rong> </li>< li> <a href="http:/ /monclerjack etsoutlet549 .webs.com">m oncler sale</a></li ><li><strong ><a href="http:/ /www.cheapmo nclersjacket sales.org/"> moncler jackets</a
omentomikel
<ul><li><str ong><a href="http:/ /www.samsung info.net/">h igh quality replica watches</a>< /strong> </l i><li><stron g><a href="http:/ /www.samsung info.net/">w atches</a></ strong> </li ><li><strong ><a href="http:/ /www.samsung info.net/">s wiss Mechanical movement re
omentomikel
<strong><a href="http:/ /www.beadedw atches.net/" >high quality swiss replica watches</a>< /strong> | <strong><a href="http:/ /www.beadedw atches.net/" >watches</a> </strong> | <strong><a href="http:/ /www.beadedw atches.net/" >swiss Mechanical movement replica wa
omentomikel
[b]<a href="http:/ /www.penmont blanc.net/<s trong><a href="http:/ /www.penmont blanc.net/"> pens</a></st rong> <br> <strong><a href="http:/ /www.penmont blanc.net/"> mont blanc pens</a></st rong> <br>
MaxMouse
It's Friday... That's good enough for me!

Donate
Donate and help us fund new challenges
Donate!
Due Date: Dec 31
December Goal: $40.00
Gross: $0.00
Net Balance: $0.00
Left to go: $40.00
Contributors


News Feeds
The Register
Hipsters ahoy! Top
Ten BOARD games for
festive family fun
No Santa, no Irish
boozers and no
regrets: life in
Qatar
HP"s shareholder
settlement deal
over Autonomy
merger DENIED ?
again
NORKS: FBI"s Sony
Pictures" hacking
allegations are
"groundless
slander"
FURY erupts on
streets of Brussels
over greedy USA"s
data-slurping
appetite
TRAGEDY STRIKES
Vulture News
Central but details
remain scrambled
Apple"s DIRTY
SECRET isn"t that
secret, or that
dirty
Why the chemistry
between Hollywood,
physics and maths
is so hot right now
Alfa Romeo
Giulietta
Quadrifoglio Verde:
Fun, but not for
all
Big Eyes
falls short on the
big question of
popular art
Slashdot
NASA "Emails" a
Socket Wrench To
the ISS
Seattle Police Held
Hackathon To Redact
Footage From Body
Cameras
Ask Slashdot: Is an
Open Source
.NET Up To
the Job?
Study: Red Light
Cameras Don"t
Improve Safety
Behind the Scenes
With the Star Trek
Fan Reboot
Google Sues
Mississippi
Attorney General
For Conspiring With
Movie Industry
New Record Set For
Deepest Dwelling
Fish
North Korea Denies
Responsibility for
Sony Attack, Warns
Against Retaliation
What Happens To
Society When Robots
Replace Workers?
Boeing and
BlackBerry Making a
Self-Destructing
Phone
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
Topic:Dot.Net
Search OSI about Dot.Net.More articles by bb.
 viewed 24158 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();
    try
    {
        //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} : ",
                            ((string[])obj[sParam].Label)[i]).Trim());
            else
                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.

Comments:
<none>
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..)
bb
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