I found an answer. Use a Rectangle at the bottom of each SubReport after all Tablixes and other rendering Objects. Then set its “PageBreak” property to “End”. When the SubReport is finished with the Tablix and/or other data objects, the Rectangle forces a page break. Also, a cool feature, if the SubReport returns no rows … Read more
IIf will always evaluate both results before deciding which one to actually return. Try =IIf(Fields!SomeField.Value = 0, 0, Fields!SomeOtherField.Value / IIf(Fields!SomeField.Value = 0, 1, Fields!SomeField.Value)) This will use 1 as the divisor if SomeOtherField.Value = 0, which does not generate an error. The parent IIf will return the correct 0 for the overall expression.
There is a way to move columns through the designer: insert the number of blank columns you want to move in your destination spot shift-left-click on the cells (NOT the header column) you want to move right-click and select the Cut command right-click on top of the destination columns and select Paste delete the now … Read more
It appears that SSRS has an issue(at leastin version 2008) – I’m studying this website that explains it Where it says if you have two columns(from 2 diff. tables) with the same name, then it’ll cause that problem. From source: SELECT a.Field1, a.Field2, a.Field3, b.Field1, b.field99 FROM TableA a JOIN TableB b on a.Field1 = … Read more
The problem here is that if there are too many data bars the labels will not show. To fix this, under the “Chart Axis” properties set the Interval value to “=1”. Then all the labels will be shown.