Are you doing this calculation in the header?

It is likely a divide by zero or a divide by something that is not actually a number.

I would suggest the same solution as burninator, except I would use this...

I would probably approach this from the dataset side. I would consolidate my prior years into a single row in the dataset so that you ended up with data...

Unfortunately column width is not something that can be controlled by expression.

However, I think you could use two tablix, one with the extra 3 columns and the other without them....

The short answer is no.

The longer answer is that you can manipulate this to a certain degree. You can choose to leave the smallest of parameters blank and have...

Now if you can only make it that far without bursting at the seams. 🙂

I saw a presentation last year at the Boston SQL Saturday on using the data profiling task to create a meta data definition that could be used later in a...

This wouldn't actually restrict them from using other formats from Report Manager but if you created a report subscription with an output format of PDF and emailed them the PDF...

Put it in the where clause of your query

WHERE age = 21

AND name = 'John'

Assuming you really don't just want to show 21 year olds named John but rather would...

It could be that I have been a little short on sleep the last few days, but your explanation still doesn't tell me why you can't use UNION.

However, your structure...

wipe out

Output your data with a tick mark in front. 'data

This will tell Excel that the data is text.

Revenant (5/8/2012)

Daniel Bowlin (5/8/2012)

Don't look now, but your age is showing. I think I am going to have that ringing in my...

Why can't you use a derived column, or a data conversion transform to change the data to like formats and types and then use your lookup or merge join?

Don't look now, but your age is showing. I think I am going to have that ringing in my head for the...