One
SQL reports often encounter a division in a table, and if the denominator is zero, an error number is usually displayed, which we can handle: (plus A/b)
=a/iif (b=0,99999999999999, B)
But we can't write this:
=IIF (b=0,0,a/b)//We can not write this, will produce bugs, as for what bugs, you can try your own
Two
We assume that the name of a lattice in the report is a, we need to refer to the value of another lattice B in a, in which case, we usually refer to the calculation formula in B again to copy in a, which is very troublesome.
We can write this directly in a:
reportitems! Name of Table B. Value
So you don't have to write the formula again.
Three
In the statement curve, if we need to change the horizontal axis, we will generally set the shaft option to automatic, but this often do not get the results we want, the following example is based on the parameters (start time and end time) of the interval dynamically change the horizontal axis style
Horizontal axis Properties "number" custom
=iif (Parameters!startime. Value=parameters!endtime. Value, "", IIf (DateAdd (dateinterval.day,-4,parameters!endtime). Value) >=parameters!startime. Value, "Mm/dd", "m/d h:mm"))
Above through three aspects to introduce the SQL report Builder reports inside the FAQ, I hope you like.