Report Builder Tablix - How to avoid data being expanded

Hi rtran ,

Forgot to add some steps.

1. 

2. add a filter of your table (format of "24 hours" is integer)

3. Repeat the above steps

Result:

Hope that's what you were looking for.

Best Regards,

Yuna

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi rtran ,

Let me explain my steps again after modifying some of them.

1. click the value of Hours and change data type as "number".

2. right-click table and select "Tablix Properties"

3. create a filter and enter "=1" in the value expression

Result:

Hope that's what you were looking for.

Best Regards,

Yuna

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.