This may be the case...

There are so many quirks in SSRS that we just have to find out and then find a work around - Don't get me started on justified text 🙁

Hi Steve, 

Why would that make a difference only when exporting to excel ?

There are no blanks rows on the report - They only appear when I export to excel 🙂

I'm getting blank rows not blank columns

I've just figured the problem out - if I include blank cells in my table in the main report 

------------------------------------------------
|          |    SUB -...

It makes you wonder - if training companies can get a course together you'd think Microsoft could sort out the books / exams - surely easier for them as they...

Hi Jeff,

You say to get the books - But unless I'm going blind there aren't any books yet are there - Heppy to be proved wrong 🙂

Thanks for that - I'll take a look at them both 🙂

I just added

AND 13 * b.n / c.n = CAST( 13 * b.n / c.n AS int)

AND g.n * h.n / i.n = CAST(g.n * h.n / i.n...

Screen shots attached

Try something like this

=IIf(IsNothing(Parameters!MinimumSaleDate.Value), "", "Products Sold Since " & IIf(IsNothing(Parameters!MinimumSaleDate.Value), "", Parameters!MinimumSaleDate.Value.ToString))

I know this looks daft but it evaluates all of the code regardless - So even though...

Try either of these in Format for the cell

##0.00%

or

P2 (this will format with a space before the % sign)

Hope this helps

Andy

Not sure what I was thinking here - I just set the Row Visibility - much easier 🙂

Something like this - You need to have the customerNum in a dataset

=IIF((left(Fields!Customernum,1) = "0" or left(Fields!Customernum,1) = "1")

and (Fields!Customernum <> "0XY'

and Fields!Customernum <> "111"

and Fields!Customernum <> "133"

and...