Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (17.6k points)
edited by

 I have an SSRS report where I am try to group the table with system name. In the dropdown, when I click on ALL it shows the report system wise. Basically the problem is in the stored procedure. System name is showing as Douglas County and system id as 62

The system will show as 621 in the parameters - Douglas County
How can I write the expression in ssrs

="System Name: " + Fields!SystemID.Value + Fields!SystemName.Value

1 Answer

0 votes
by (47.2k points)

Properties of many report items can be set to an expression. Generally, Expressions help you control the content, design, and interactivity of your report. 

You can try using this:

="System Name: " + Fields!SystemID.Value + " - " + Fields!SystemName.Value 

Check out Msbi certification training that enables you to master MSBI tools like SSIS, SSRS, and SSAS using SQL Server. 

Related questions

0 votes
1 answer
asked Jan 31, 2020 in BI by Vaibhav Ameta (17.6k points)
0 votes
1 answer
asked Feb 6, 2020 in BI by Vaibhav Ameta (17.6k points)
0 votes
1 answer
asked Jan 31, 2020 in BI by Vaibhav Ameta (17.6k points)
0 votes
1 answer
asked Feb 3, 2020 in BI by Vaibhav Ameta (17.6k points)
0 votes
1 answer
...