none
rdlc group filter RRS feed

  • Question

  • Greetings, im just wondering why in rdlc report when i try to set a filter to group, then and/or column is disabled, i need to set my 2 expressions to or and by default is set to and, is this a normal behavior thx!
    Wednesday, October 21, 2009 10:21 PM

All replies

  • Have you already got an solution for your and/or problem?

    I am sticking on the same issue.

    Friday, March 19, 2010 11:26 AM
  • You could always write a filter condition like this:

    Filter expression:    =(conditition A)  OR  (condition B)
    Filter operator:       =
    Filter value:            =True

     

    HTH,
    Robert


    Robert Bruckner   http://blogs.msdn.com/robertbruckner
    This posting is provided "AS IS" with no warranties, and confers no rights.
    Saturday, March 20, 2010 4:12 AM
    Moderator
  • Thanks for your answer, thaught on that also, but it didn't work.

    Filter expression = (("*" & Cstr(Fields!StatusZNRwhereFORPart.Value) & "*" = "**") OR (Cstr(Fields!StatusZNRwhereFORPart.Value) = "Freigegeben"))
    Filter operator    =
    Filter value        = True

    What is wrong?

    Regards
    Franz

    Thursday, March 25, 2010 5:27 PM
  • Are you intending to use a LIKE comparison instead of an exact comparison in the first condition?

    (("*" & Cstr(Fields!StatusZNRwhereFORPart.Value) & "*" = "**")

    If so, instead of using = you have to use the keyword LIKE. More information on the LIKE operator is available here: http://msdn.microsoft.com/en-us/library/swf8kaxw(VS.71).aspx

    HTH,
    Robert


    Robert Bruckner   http://blogs.msdn.com/robertbruckner
    This posting is provided "AS IS" with no warranties, and confers no rights.
    Saturday, March 27, 2010 11:02 PM
    Moderator
  • I am interested in = because I was unable to detect an empty Fields!...value therefore I put * in front and behind the inspected value and got now ** if the string in the center would be empty.
    I guess the error is comming from the OR because when I am using each filter separately it would work fine.

    Regards
    Franz

    Monday, March 29, 2010 10:45 AM