27368 total geeks with 3535 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]<a href="http:/ /www.swissro lexwatches.o rg/">ro<stro ng><a href="http:/ /www.swissro lexwatches.o rg/">rolex Yacht-Master II</a></stro ng> <br> <strong><a href="http:/ /www.swissro lexwatches.o rg/">replica watches</a>< /strong> <br >
timsattemme
<strong><a href="http:/ /www.swissro lexwatches.o rg/">watches </a></strong > | <strong><a href="http:/ /www.swissro lexwatches.o rg/">swiss replica watches</a>< /strong> | <strong><a href="http:/ /www.swissro lexwatches.o rg/">swiss rolex replicas for sale</a></st
timsattemme
[b][url=http ://www.watch esreplicalov e.com/]omega w<strong><a href="http:/ /www.watches replicalove. com/">omega watches on sale</a></st rong> <br> <strong><a href="http:/ /www.watches replicalove. com/">omega watches replica</a>< /strong> <br >
timsattemme
<ul><li><str ong><a href="http:/ /www.watches replicalove. com/">omega watches replica brand watches</a>< /strong> </l i><li><stron g><a href="http:/ /www.watches replicalove. com/">watche s</a></stron g> </li><li> <strong><a href="http:/ /www.watches replicalove. com/">
timsattemme
[b][url=http ://www.repli cawatcheslov e.com/]omega wa<strong><a href="http:/ /www.replica watcheslove. com/">omega watches on sale</a></st rong> <br> <strong><a href="http:/ /www.replica watcheslove. com/">omega watches replica</a>< /strong> <br >

Donate
Donate and help us fund new challenges
Donate!
Due Date: Feb 28
February Goal: $30.00
Gross: $0.00
Net Balance: $0.00
Left to go: $30.00
Contributors


News Feeds
The Register
Chipotle insider
trading: Disproving
the efficient
markets hypothesis
Oh, lordy! "I do
not begin to
understand the dark
cloud. LEGISLATE
NOW"
STUDENT RACK WARS:
Science and HPC ?
all the kids are
doing it these days
Earth"s soil to be
observed by
DIRTY-MINDED
satellite
Snapchat
jihadist-fearing
peers return with
LAST GASP Snoopers"
Charter demand
Grav wave tsunami
NOT caused by Big
Bang ? astro
boffins
Cuddly robots,
whipsmart laughs
and plenty of heart
in Big Hero
6
Google Now now
SLURPS data from 40
third party apps so
YOU don"t have to
Bitter Lake:
Know your enemy?
Impossible, surely,
when you don"t know
if the enem
"Boutique" ISPs:
Snub the Big 4 AND
get great service
Slashdot
OpenSSH Will
Feature Key
Discovery and
Rotation For Easier
Switching To
Ed25519
Physicists Make a
Mobius Strip From
Beams of Light
The Pirate Bay Is
Back Online,
Properly
NASA Looking At
Nuclear Thermal
Rockets To Explore
the Solar System
Inkscape Version
0.91 Released
Can Students Have
Too Much Tech?
GeForce GTX 980 and
970 Cards From MSI,
EVGA, and Zotac
Reviewed
Dell Continues
Shipping Fresh
Linux Laptops
Comcast Employees
Change Customer
Names To "Dummy"
and Other Insults
UK Sets Up
Internet-Savvy Army
Unit
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 24376 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