Format on RDD not updating data in temp table or report

An RDD has “OrderStatus” with format set to X(4). So, a “CLOSED” order displays as “CLOS”. We’d like to increase this to X(12), but every time I do and hit save, run the report, the value still is limited to 4 characters. Even if I change it to X(2) I still see 4 characters. I’m seeing these 4 characters in the actual temp table (in addition to the report).

Are RDDs cached somewhere/somehow?


Capture2

You can’t update Calculated fields as far as I know. Use a formula in the SSRS to display the text you want to see.

Thanks, but the data coming from the RDD to the temp table is already truncated to (4) characters long.

Right. So use a formula in SSRS to display what you need.

Jason Woods
http://LinkedIn.com/in/jasoncwoods

What do you mean? An “IF status = CLOS, then display CLOSED”?

Exactly.

Jason Woods
http://LinkedIn.com/in/jasoncwoods