Databases
StackOverflow2013
Postsdbo
POms SSRS 2008 R2: Display Computed Values #Error
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POms SSRS 2008 R2: Display Computed Values #Error
    primarykey
    data
    text
    <p>The Report will display Two Columns Foo and Bar</p> <p>Some Rows of Foo are Empty Some have a numerical Value:</p> <pre><code> Foo: +----+ | | +----+ |10.0| +----+ </code></pre> <p>then There is the Bar Column, this column will take the Values from Foo and add 10 to them, the report should yield Results like this:</p> <pre><code> Foo: Bar: +----+----+ | | | +----+----+ |10.0|20.0| +----+----+ </code></pre> <p>Thats the Expression i use to determine whether Foo is numeric inside Bar:</p> <pre><code>=IsNumeric(ReportItems!FooBox.Value) </code></pre> <p>And this is the Result that Expression will Yield:</p> <pre><code> Foo: Bar: +----+-----+ | |False| +----+-----+ |10.0|True | +----+-----+ </code></pre> <p>Okay, thats exactly the way i want it so far, thus i write My Expression that way:</p> <pre><code>=IIf(IsNumeric(ReportItems!FooBox.Value), ReportItems!FooBox.Value +10, "") </code></pre> <p>This will Yield the Following Results:</p> <pre><code>Foo: Bar: +----+------+ | |#Error| +----+------+ |10.0|20.0 | +----+------+ </code></pre> <p>And most Bizare, when i remove the little addition in the Truepart of the IIf, it will execute: </p> <pre><code>=IIf(IsNumeric(ReportItems!FooBox.Value), ReportItems!FooBox.Value, "") Foo: Bar: +----+------+ | | | +----+------+ |10.0|10.0 | +----+------+ </code></pre> <p>It's almost as if the "wrong" part of the Ternary operator gets executed Anyway, thus generating this castError or whatever it might be.</p> <p>How can i convert the Values properly in order to Show the Results as Explained before?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USDaniel Jawna
    plurals
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COpossible duplicate of [SSRS hide #Error displayed in cell](http://stackoverflow.com/questions/9144312/ssrs-hide-error-displayed-in-cell) I voted to close: your question is essentially a duplicate of several others asked before.
      singulars
      1. POms SSRS 2008 R2: Display Computed Values #Error
      1. USJamie F
    2. COAnother answer: http://stackoverflow.com/questions/1204179/does-the-iif-function-compute-both-paths-in-ssrs-or-is-it-short-circuited
      singulars
      1. POms SSRS 2008 R2: Display Computed Values #Error
      1. USJamie F
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload