python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - ssrs-2012

SSRS Time expression filter not working with Parameter boolean value

Background: Trying to achieve a filter in dataset, if the user selects Day shift from the parameter, any data entry between 06:00:00 and 18:00:00 is filter in the report. Furthermore, any data entry b...
test-img

jaddy718

reporting-services

ssrs-2012

Votes: 0

Answers: 1

Latest Answer

I'm not sure what report designer you are using, but using the Report Designer extension for Visual Studio gives me very different errors. And it gives errors both in the output window, and the expres...
test-img

Dale K

SSRS takes out leading zero if the Customer Ref contains leading zero

I have the following situation of running SSRS report with Report Builder 3.0 (SQL Server 2012). The data field CustomerRef contains Customer Reference No which may have Cust1234 or 00001234. I want t...
test-img

dummip

ssrs-2012

Votes: 0

Answers: 1

Latest Answer

This is not tested but try this =IIF(Fields!CustomerRef.Value.Contains("Cust") , Fields!CustomerRef.Value , CStr(Cint( IIF(Fields!CustomerRef.Val...
test-img

Alan Schofield

How to convert my expressions in to an actual field without showing an error? =SUM(IIF(Fields!Actual_Duration.Value >= 10, "Intervene", "Leave"))

How to convert my expressions in to an actual field without showing an error? I am trying to create the below into a field so I can use an expression which will count the "Intervenes" =SUM(I...
test-img

EducationSRSS

reporting-services

ssrs-2008

ssrs-2012

Votes: 0

Answers: 1

Latest Answer

If your Intervene and Leave are fields in your dataset, you would use the field values liek you did with Actual_Duration. =SUM(IIF(Fields!Actual_Duration.Value >= 10, Fields!Intervene.Value, Fields...
test-img

Hannover Fist

What is wrong with this expressions? =CountRows(ReportItems!Textbox58.Value = "Intervene"). I want to count each row which says Intervene

What is wrong with this expression? =CountRows(ReportItems!Textbox58.Value = "Intervene") I want to count each row which says Intervene.
test-img

EducationSRSS

sql-server

reporting-services

ssrs-2008

ssrs-2012

Votes: 0

Answers: 1

Latest Answer

As Larnu has commented, you cannot use CountRows against the ReportItems collection. Probably what you need to do is Look at the expression in Textbox58 and see where it gets it's data from. In this e...
test-img

Alan Schofield

Posts

Questions

Blogs

Jobs