Analysis of common problems in SQL report Builder reports _mssql

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.