Report viewer displaying Values instead of label in Parameter

[Danyelle]

I am using Report Viewer to get SSRS reports. When the report is displayed it is showing the values in two of my parameters, instead of the labels. 

Pay Groups should be showing The Pay Group Names and not the pay group ids.

Code:

  @(Html.Bold().ReportViewer("viewer")
                           
                             .ReportServiceUrl("/api/ReportViewer") 
                            .ReportServerUrl("https://server/reportserver").Parameters(param =>
                            {
                                param.Name("UserName").Values(new List<string>() { model.EmployeeLoginName.ToString() }).Add();
                               
 
                            }).SizeToReportContent(true).EnableParameterBlockScroller(false)
            .ReportPath("/Reports/Individual Tool Budget").IsResponsive(true)
)

[Muthuramana Sankaranarayanan]

Hi Danyelle, 

Thanks for contacting Bold Reports Support. 

Could you please share the issue reproducible report with us as it will be helpful for us to further validate the reported issue from our end. 

Regards, 

Muthu Ramana S 

[Danyelle]

There appears to be an issue with cascading parameters. Both the Pay Group and the Employee parameters are cascading parameters. When this report is opened a hidden parameter named username is passed into the report. Based on the user name the Pay group(s) will be selected. Next, the Employees are selected based on the Pay Groups. 

I have made sure that the bold reports NuGet package is updated.

Controller Code:

 private UserViewModel SessionUser => Session["User"] as UserViewModel;

        

        [Route("Reports/EmployeeToolBudget")]

        public ActionResult EmployeeToolBudget()

        {

            ViewBag.parameterSettings = new BoldReports.Models.ReportViewer.ParameterSettings();

            ViewBag.parameterSettings.DateTimeFormat = "d/M/yyyy h:mm tt";

            ViewBag.parameterSettings.TimeDisplayFormat = "HH:mm";

            ViewBag.parameterSettings.TimeInterval = 60;

            return View(SessionUser);

        }

        [Route("Reports/ToolTransactionsByEmployee")]

        public ActionResult ToolTransactionsByEmployee()

        {

            return View(SessionUser);

        }

        [Route("Reports/ToolBudgetDetails")]

        public ActionResult ToolBudgetDetails(string employeeId)

        {

            return View(SessionUser);

        }

[Danyelle]

I have figured out that the control does not work well with shared datasets. In our reports from reporting services, I was getting the pay groups and employees from a shared dataset. Once I moved the queries for the pay groups and employees into the report the parameters are now working. However, I have a hidden parameter in my report that is populated by joining the values of the pay group parameter that is now working which is causing the report to not be able to run.

This shows where the PayGroupId's parameter is populated by joining the values selected in the PayGroup parameter into a string. In SSRS this works fine. 

When rendering the report through bold report control it loads correctly but when I change the pay group it does not update the hidden parameter so the report can not be run.

[Danyelle]

I fixed this by allowing the hidden parameters to be null since I didn't need them in this case. However, doing this causes the report to not return results. 

In the below screenshot I have made the parameter EmpID visible and set it to null. This shows what happens to the parameter when it is hidden and I try to filter the report. There should be results. 

[Muthuramana Sankaranarayanan]

Hi Danyelle, 

We have created a separate incident for this issue. We suggest you to have follow up regarding this using the incident that we created for you. Please find the incident in your Direct trac account. 

Regards, 

Muthu Ramana S