all groups > sql server reporting services > april 2005 >
You're in the

sql server reporting services

group:

table cell format question


table cell format question ottawa111
4/2/2005 4:26:13 AM
sql server reporting services:
Hi,
I want te format table cell with the format of dx, x is the width of
the largest number in all the cells of the same column.
What I need to do is to pad the same column with 0,so all the cells are
of the same length.
Can anyone help me? Thanks a lot
RE: table cell format question Suneet
4/2/2005 9:27:02 AM
I believe you want something like this-
2345
0567
0004
4455

So if you need this in the column please follow this-
1. In expression for Format property of that cell write this
="d" + cstr(Len(trim(max(Fields!MyField.Value))))

Here MyField is your fieldname which in the column for which you need to pad
zeros to make all numbers looking like equal length.

-Suneet Mohan



[quoted text, click to view]
Re: table cell format question ottawa111
4/3/2005 10:25:01 AM
Thanks a lot ,that solves the problem.Could you tell me where can I
find documentation of expressions used here?
[quoted text, click to view]
Re: table cell format question Andrew Watt [MVP - InfoPath]
4/4/2005 9:11:31 AM
Angela,

It's not well documented in Reporting Services Books Online.

RS uses VB.NET-like expressions. So you can get some useful
information by exploring the VB.NET documentation.

I am not aware of any standalone good documentation of RS expressions.
(I would love to be corrected!)

Andrew Watt
MVP - InfoPath

On 3 Apr 2005 10:25:01 -0700, "ottawa111" <angela_c@verizon.net>
[quoted text, click to view]
AddThis Social Bookmark Button