Solved

Passing parameters from ASP page to report viewer SSRS report

Posted on 2009-04-01
6
1,109 Views
Last Modified: 2016-02-13
1) What do I have to do to the SSRS report? (create parameters?)
2) What do I have to do on the ASP page to pass it through?
Do you have a code snippet?

I found some answers in the knowledge base, but had broken links.
Using SSRS 2005, VS 2008.
0
Comment
Question by:guspan
  • 3
  • 2
6 Comments
 
LVL 26

Accepted Solution

by:
Chris Luttrell earned 500 total points
ID: 24044105
This is the code where we load the parameters and is called by this line
rptViewer.ServerReport.SetParameters(loadKPIParameters(report))
    #region KPI Recognition Methods

    private ReportParameter[] loadKPIParameters(string reportPath)

    {

        //declaring and initializing local variables

        MyAppAccordionFilter filter = (MyAppAccordionFilter)Session["MyAppAccordionFilter"];

        ReportParameter[] rptParams = null;

        ReportServerQuery.ReportService.ReportParameter[] thisRptParams = null;

        string[] rptAuth = MyAppApplication.getMyAuthenticatedUserGroup();

        ArrayList lparamList = new ArrayList();

        thisRptParams = ReportServerQuery.ReportServerQuery.GetParametersForReport(rptAuth, reportPath);
 

        //looping through the parameters and filling in those it recognizes

        for (int i = 0; i < thisRptParams.Length; i++)

        {

            if (thisRptParams[i].PromptUser)

            {

                switch (thisRptParams[i].Name)

                {

                    case "FilterLevel": //Scorecard Parameter

                        lparamList.Add(new ReportParameter(thisRptParams[i].Name, getFilterLevel(filter)));

                        break;

                    case "FilterId": //Scorecard Parameter

                        lparamList.Add(new ReportParameter(thisRptParams[i].Name, getFilterId(filter)));

                        break;

                    case "FiscalYear":

                        lparamList.Add(new ReportParameter(thisRptParams[i].Name, getFiscalYear(filter)));

                        break;

                    case "FiscalPeriod":

                        lparamList.Add(new ReportParameter(thisRptParams[i].Name, getFiscalPeriod(filter)));

                        break;

                    case "ReportLevel":

                        lparamList.Add(new ReportParameter(thisRptParams[i].Name, getReportLevel(filter)));

                        break;

                    case "NAFD_ID":

                        lparamList.Add(new ReportParameter(thisRptParams[i].Name, getNAFD_ID(filter)));

                        break;

                }

            }

        }
 

        //creating a list of parameters to hand to the viewer

        rptParams = new ReportParameter[lparamList.Count];

        for (int i = 0; i < lparamList.Count; i++)

            rptParams[i] = (ReportParameter)lparamList[i];
 

        //returning the parameters

        return rptParams;

    }

Open in new window

0
 

Author Comment

by:guspan
ID: 24072854
From a C# Webpage?
0
 
LVL 26

Expert Comment

by:Chris Luttrell
ID: 24074349
Yes, this is from the code behind in an aspx.cs page.
0
 

Author Comment

by:guspan
ID: 24088423
Not too familiar with c#, but loadKPIparameters is a arbitrary method I name?
This isn't specific to KPI in SSAS is it?
0
 
LVL 26

Expert Comment

by:Chris Luttrell
ID: 24088654
No, not part of SSAS that is just our method name in the code I copied.
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Steps to solve SSRS SQL 2008 R2 User Access Control (UAC) Permission Error With the introduction of SQL Server 2008 R2 and Vista (Windows 7 as well) came new enhanced security features. One of the features included was User Access Control (UAC) t…
Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
This video discusses moving either the default database or any database to a new volume.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now