Post reply

SSRS 2012 expression cauing errors

  • April 30, 2015 at 3:10 am

    #398393

    After an upgrade from SSRS 2005 to SSRS 2012, one of our reports no longer renders and gives the following error:

    Microsoft.ReportingServices.ReportProcessingException: The specified operation is not valid

    I've narrowed it down to a textbox with the following expression:

    =CountDistinct(Fields!field1.Value) / (CountDistinct(Fields!field2.Value) - CountDistinct(Fields!field3.Value))

    Why would this no longer work, and is there an alternative i can use? The text box is to show a percentage and has format P1 assigned to it.

    Many thanks in advance for any help.

  • April 30, 2015 at 5:13 am

    #1794611

    Tunrs out that field3 was a calculated field. I've updated the SQL to populate field3 and all works fine now.

Viewing 2 posts - 1 through 1 (of 1 total)

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