CODEWITHSUNDEEP
sql-serverreporting-servicesssrs-2008ssrs-2012
ExtremeSwat
ExtremeSwat

Reputation: 824

SSRS Not showing all column labels

I have an issue with SSRS, I cannot see some other labels

This is how it looks like on design view

enter image description here

And at preview-time

enter image description here

The code behind it

SELECT 
        SUM(CASE WHEN tr.TestOverallResult = 1 THEN 1 END) AS Failures,
        SUM(CASE WHEN tr.TestOverallResult = 0 THEN 1 END) AS Successes,
        5 as test

    FROM
        dbo.TestResults tr
    WHERE
        tr.MethodCode LIKE '%' + @MethodName + '%'

Any idea where's the problem ? Thanks

Upvotes: 0

Views: 391

Answers (1)

Randall
Randall

Reputation: 1521

It's a values group issue, change the order of the values, the label will disappear, right click to add it back, rinse and repeat for each one of your value sets. Then run the report and it will show them.

Upvotes: 2

Related Questions