27087 total geeks with 3528 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
sdchristebrad
<strong><a href="http:/ /www.columbi a-sportswear -outlet.com/ ">columbia jackets outlet</a></ strong> <str ong><a href="http:/ /www.columbi a-sportswear -outlet.com/ ">columbia sportwear outlet</a></ strong> <br> <strong><a href="http:/ /www.columbi a-sportswear -outle
sdchristebrad
[b][url=http ://www.asics onsale.com/a sics-womens- running-shoe s-c-11.html] asics w<strong><a href="http:/ /www.asicson sale.com/asi cs-womens-ru nning-shoes- c-11.html">a sics women's running shoes outlet</a></ strong> <br> <strong><a href="http:/ /www.asicson sale.c
sdchristebrad
<strong><a href="http:/ /www.asicson sale.com/">a sics running shoes</a></s trong> <br> <strong><a href="http:/ /www.asicson sale.com/">a sics running shoes</a></s trong> <br> <strong><a href="http:/ /www.asicson sale.com/">a sics gel kayano 20</a></stro ng> <br> <br
sdchristebrad
[b][url=http ://jpguccise llwellforu.c om/]gucci outlet[/url] [/b] [b][url =http://jpgu ccisellwellf oru.com/]dis count gucci handbags[/ur l][/b] [b][url=http ://jpguccise llwellforu.c om/]gucci on sale[/url][/ b] http://www.c heapjerseysp opular.com/ cheap nfl
sdchristebrad
[b][url=http ://www.santo rinihostels. com/nbspnbsp nbspnbspmens -apex-bionic -jackets-c-3 .html]north face men's apex bionic jacket[/url] [/b] [b][url=http ://www.santo rinihostels. com/nbspnbsp nbspnbspmens -apex-bionic -jackets-c-3 .html]new north face men's apex bi

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


News Feeds
The Register
Google absorbs
Oxford Uni boffins
in artificial
intelligence boost
quest
Something about
this really STINKS:
Rosetta probe
shoves nose under
comet"s tail
Rackspace launches
big red rack eater
Adorkable overshare
of words like
photobomb in this
year"s dictionaries
MAVEN snaps
eight-bit SPACE
INVADER
"Careful management
of headcount" for
Juniper after tepid
quarter
Boffins want to put
Quanta in
containers, after
docking
Yahoo!
Timestamps!
Now!
Block!
Facebook!
Email!
What does beating a
dead horse look
like? Look no
further than the
US TV giants vs
Samsung gets
virtual with tiny
S5 upgrade and
goggle grab
Slashdot
NY Doctor Recently
Back From West
Africa Tests
Positive For Ebola
Tracking a Bitcoin
Thief
How Sony, Intel,
and Unix Made
Apple"s Mac a PC
Competitor
SMART Begins Live
Public Robocar
Tests In Singapore
Microsoft Exec
Opens Up About
Research Lab
Closure, Layoffs
Tech Firm Fined For
Paying Imported
Workers $1.21 Per
Hour
Mark Zuckerberg
Speaks Mandarin At
Tsinghua University
In Beijing
Assange: Google Is
Not What It Seems
Leaked Documents
Reveal
Behind-the-Scenes
Ebola Vaccine
Issues
Ubuntu 14.10
Released With
Ambitious Name, But
Small Changes
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 23595 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