26998 total geeks with 3514 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
<strong><a href="http:/ /www.timberl andoutletco. com/">timber land boot outlet</a></ strong> <br> <strong><a href="http:/ /www.timberl andoutletco. com/">timber land outlet</a></ strong> <br> <strong><a href="http:/ /www.timberl andoutletco. com/">timber land shoes</a
timsattemme
[b][url=http ://www.tiffa nymotorsale. com/]sterlin g silver tiffany[/url ][/b] [b]<a href="http:/ /www.tiffany motorsale.co m/">tiffany outlet store</a>[/b ] ant pain of fibromyalgia and / or arthritis, can be quick in order to disagree. At present, many skille
timsattemme
[b][url=http ://www.faker eplicaomega. com/]rep<str ong><a href="http:/ /www.fakerep licaomega.co m/">replica watch</a></s trong> <br> <strong><a href="http:/ /www.fakerep licaomega.co m/">replica watches</a>< /strong> <br >
timsattemme
<ul><li><str ong><a href="http:/ /www.copyfak ewatches.com /">omega watches</a>< /strong> </l i><li><stron g><a href="http:/ /www.copyfak ewatches.com /">watches</ a></strong> </li><li><st rong><a href="http:/ /www.copyfak ewatches.com /">new style watches</a>< /strong>
MaxMouse
It's Friday... That's good enough for me!

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


News Feeds
The Register
Security rEsrchRs
find nu way 2 spot
TXT spam
SHARE "N" SINK:
OneDrive corrupting
Office 2013 files
Singapore slings
18k fine at
text-spam-spaffing
biz owner
Apple, FBI probe
nude celeb hacks
South Korea"s top
wireless carrier
builds Internet of
Eels
Microsoft changes
cert test
providers, hints at
fun new exams
Epiphany hits
Raspberry Pi
founders, users
Sex-in-space geckos
killed by frigidity
Transparency by
Telstra: a good
start but not
enough
Cisco climbs aboard
containerisation
cloudwagon, with
security
reservations
Slashdot
Finland"s Nuclear
Plant Start Delayed
Again
Ask Slashdot:
Linux-Friendly
Desktop x86
Motherboard
Manufacturers?
Hidden Obstacles
For Delivery Drones
Hackers Behind
Biggest-Ever
Password Theft
Begin Attacks
Tox, a Skype
Replacement Built
On "Privacy First"
Net Neutrality
Campaign To Show
What the Web Would
Be Like With a
"Slow Lane"
New Computer Model
Predicts Impact of
Yellowstone Volcano
Eruption
Raspberry Pi Gets a
Brand New Browser
Power Grids: The
Huge Battery Market
You Never Knew
Existed
Radioactive Wild
Boars Still Roaming
the Forests of
Germany
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 23230 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