27181 total geeks with 3531 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
timsattemme
[b][url=http ://www.links oflondonoutl etu.com/]lin ks of london <strong><a href="http:/ /www.linksof londonoutlet u.com/">link s of london outlet store</a></s trong> <br> <strong><a href="http:/ /www.linksof londonoutlet u.com/">Chea p Links Of London Jewelry Wholesa
timsattemme
[b][url=http ://www.pando rapromotions .co/]pandora j<strong><a href="http:/ /www.pandora promotions.c o/">pandora jewelry wholesale</a ></strong> < br> <strong><a href="http:/ /www.pandora promotions.c o/">pandora jewelry cheap</a></s trong> <br>
timsattemme
<ul><li><str ong><a href="http:/ /www.pandora promotions.c o/">pandora outlet stores</a></ strong> </li ><li><strong ><a href="http:/ /www.pandora promotions.c o/">pandora silver</a></ strong> </li ><li><strong ><a href="http:/ /www.pandora promotions.c o/">pandora outle
timsattemme
[b][url=http ://www.19may isfm.com/]pe n<strong><a href="http:/ /www.19mayis fm.com/">pen s</a></stron g> <br> <strong><a href="http:/ /www.19mayis fm.com/">mon t blanc pens</a></st rong> <br>
timsattemme
[b][url=http ://www.cad-e book.com/]sw iss replic<stron g><a href="http:/ /www.cad-ebo ok.com/">swi ss replica watches aaa+</a></st rong> <br> <strong><a href="http:/ /www.cad-ebo ok.com/">swi ss replica watches</a>< /strong> <br >

Donate
Donate and help us fund new challenges
Donate!
Due Date: Nov 30
November Goal: $40.00
Gross: $0.00
Net Balance: $0.00
Left to go: $40.00
Contributors


News Feeds
The Register
Azure has put new
life into Active
Directory
World"s best threat
detection pwned by
HOBBIT
Simplez: OLD SCHOOL
TECH can SAVE the
MEERKAT
DNA survives fiery
heat of re-entry on
test rocket
Citrix clambers
aboard GPU-powered
app-delivery
bandwagon
NICTA chief quits
over future
structure flap with
board
Edward Snowden:
best ... security
... educator ...
EVER!
Cryptocurrency
cruncher cranks
prime number
constellation
Chinese search
engine Baidu to
peddle SmartBike
Leaked Syrian log
files reveal
attempts to starve
rebels of
information
Slashdot
Renewables Are Now
Scotland"s Biggest
Energy Source
Researchers
Discover an "Off
Switch" For Pain In
the Brain
Ask Slashdot: Best
Drone For
$100-$150?
Scientists Develop
"Paint" To Help
Cool the Planet
Google Should Be
Broken Up, Say
European MPs
Kim Dotcom Says
Legal Fight Has
Left Him Broke
Behind Apple"s
Sapphire Screen
Debacle
Syrian Electronic
Army Takes Credit
For News Site
Hacking
Apple and Amazon
Launch Black Friday
Price War
Riecoin Breaks
World Record For
Largest Prime
Sextuplet, Twice
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 24001 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