Post reply

two conditions

  • September 20, 2011 at 10:35 am

    #1383999

    When you say output window, you mean the window when i click preview correct?

  • September 20, 2011 at 10:40 am

    #1384002

    lcarrethers (9/20/2011)

    When you say output window, you mean the window when i click preview correct?

  • September 20, 2011 at 10:44 am

    #1384005

    Duhhhhhhhhhhhh

    [rsAggregateOfMixedDataTypes] The Value expression for the textrun ‘textbox35.Paragraphs[0].TextRuns[0]’ uses an aggregate function on data of varying data types. Aggregate functions other than First, Last, Previous, Count, and CountDistinct can only aggregate data of a single data type.

    Preview complete -- 0 errors, 1 warnings

  • September 20, 2011 at 10:48 am

    #1384009

    use this instead SUM(Fields!Untstopy.Value) and remove the first sum.

    If that doesn't work google around a little bit, should be easy to fix now that you know the real issue.

  • September 20, 2011 at 10:54 am

    #1384011

    Thanks

  • September 20, 2011 at 12:03 pm

    #1384072

    =sum(Iif(trim(Fields!payrolcd.Value) = "SALARY" and trim(Fields!PAYRCORD.Value) = "SALARY", cint(Fields!Untstopy.Value),0))

    Ok when i put the cint in front it gives me numbers now, but it rounds them. Is there a way i can stop the rounding.

  • September 20, 2011 at 2:20 pm

    #1384150

    cint converts to int.

    cdbl converts to double.

  • September 21, 2011 at 3:20 pm

    #1384849

    This doesn't return anything when I put the like expression in it.

    =sum(Iif(trim(Fields!PYRLRTYP.Value) = 2 AND trim(Fields!SFRFEDTX.Value) = 0 AND TRIM(Fields!payrolcd.Value) LIKE "SMED%", CDbl(Fields!UPRTRXAM.Value),CDbl(0)))

    Is there a work around.

  • September 21, 2011 at 3:22 pm

    #1384851

    I got it. I replace the % with * and it works

  • September 21, 2011 at 3:48 pm

    #1384870

    I lied it didn't work

  • September 21, 2011 at 4:48 pm

    #1384885

    Please define "not working".

  • September 22, 2011 at 7:06 am

    #1385123

    It returns zero's

  • September 22, 2011 at 7:14 am

    #1385128

    I can't debug this for you. You need to restart from the begining and add 1 thing at a time and make sure it works at all steps.

  • September 22, 2011 at 7:29 am

    #1385141

    I got it to work this way

    =(Iif(trim(Fields!PYRLRTYP.Value) = 2 AND trim(Fields!SFRFEDTX.Value) = 0 AND TRIM(Fields!payrolcd.Value) LIKE "*[SMED]*", CDbl(Fields!UPRTRXAM.Value),CDbl(0)))

  • September 22, 2011 at 7:31 am

    #1385143

    Thanks for the feedback, hopefully it'll help someone else in the future.

Viewing 15 posts - 16 through 30 (of 36 total)

You must be logged in to reply to this topic. Login to reply