GIVING THE SPACE

Question

Post reply

GIVING THE SPACE

cpinky01

Ten Centuries

Points: 1144
More actions
September 8, 2010 at 1:15 pm

#387746

In SSRS
I Need The display of one column to be like this (Hierarchically).
Over all
Sales
Sales1
Sales2
Sales3
Claims
Claims1
Claims2
How to give the space before the text in the column accordingly?
OVER ALL under this sales and Claims,
Sales and claims are groups.
Sales and claims should have same amount of space left before start.
Under sales sales1, sales2 and sales3 should have same space left before starting of the text
Same applies to claims
Thank you

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

LutzM SSC Guru Points: 107049 More actions · Answer 1

A totally different approach:

You might want to have a look at one of Jacob Sebastian's TSQL Challenges.

It might help to look through the various solutions...

Or, if you already know the level of the row you want to display you could use

SELECT SPACE(YourLevelColumn) + YourColumn

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

cpinky01 Ten Centuries Points: 1144 More actions · Answer 2

Hi Lutz,

Thanks for your reply. I have got the solution.

Thanks once again.

LutzM SSC Guru Points: 107049 More actions · Answer 3

Would you mind sharing your solution so others might benefit?

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

cpinky01 Ten Centuries Points: 1144 More actions · Answer 4

Hi Lutz,

select the cell that you wanted to give the space. then indent property of that column select how much indent you want like for ex 10pt. whatevr that belogs to that group will have that much indent. for the next level use same as above . foe ex keep left indent to 20pt.

thats it.

thanks

Niraj-627298 Hall of Fame Points: 3641 More actions · Answer 5

Hi...

Thanks !!

I think, it can be acheived through PADDING property. Setting the PADDING property (Space from Left) accordingly should resolve this issue. 🙂

Thanks,

Niraj