Share via

Equivalent in SSRS

PhillipK 121 Reputation points
Oct 25, 2022, 1:51 PM

In Crystal I have this code

(if {?Box Number} = "< ALL >" then
not isnull({OPS_FED_PROJ_SUMMARY.STORAGE_BOX_NUM}) else
{OPS_FED_PROJ_SUMMARY.STORAGE_BOX_NUM} = {?Box Number}) and
{PM_COUNTY.PRIMARY_COUNTY_IND} = "Y"

what is the equivalent in SSRS of the ALL. In the Crystal Report, there is no other option except ALL in the Parameter. The code above is from the Record Selection. I got all the data showing but somehow some are still not displayed. It shows the First one circled in my SSRS report but the 2nd one with an X is not shown. Somehow the Crystal shows the one in X and other values.... I might have missed something

253953-image.png

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,092 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,946 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,603 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Michael Taylor 55,221 Reputation points
    Oct 25, 2022, 2:32 PM

    We really don't have enough context here to provide you any sort of insight. Where is that expression going exactly? Is it part of a query you're running to get the data to display? Is it tied to an expression you're using to show/hide a row, what?

    We also don't know what any of the values in your expression represent. Is Box_Number a parameter specified when running the report, a column in a table? It looks like a parameter to me based upon the rest of the query. If it is a parameter then how is it defined? Is it a multi-value parameter, single-value string, etc?

    Just trying to interpret your query, it appears that if no box number is selected then it returns all rows that have a box number. Otherwise it attempts to filter out all rows that don't match that box number. But in that case the primary indicator on the county must also be set. In the row you said isn't showing up it doesn't appear to have a county so I wonder if the second part of your condition is causing it to disappear.


  2. PhillipK 121 Reputation points
    Oct 25, 2022, 7:54 PM

    Somehow I cannot get the values to perform a break base on the col value change for SSRS. The one above is from Crystal.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.