Post reply

GIVING THE SPACE

  • 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

  • September 8, 2010 at 1:44 pm

    #1218222

    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]

  • September 8, 2010 at 2:27 pm

    #1218247

    Hi Lutz,

    Thanks for your reply. I have got the solution.

    Thanks once again.

  • September 8, 2010 at 2:44 pm

    #1218257

    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]

  • September 8, 2010 at 9:07 pm

    #1218336

    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

  • September 8, 2010 at 10:28 pm

    #1218350

    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

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

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