Post reply

indentation

  • September 23, 2010 at 9:35 am

    #227173

    I have question order number and questions in my dataset

    Order number is 1 or 2

    Like this

    Qorder Question

    1 Question Group nameG1

    2 child questionsG1

    2 child questionsG2

    2 child questionsG3

    1 Question Group nameG2

    2 child questionsG21

    2 child questionsG22

    1 Question Group nameG3

    2 child questionsGG31

    2 child questionsGG32

    I need to have in ssrs report like this

    When Qorder=1 then the question group name has to be in bold

    If the Qorder=2 then there should be some indentation with out any bold text

    Qorder Question

    1 Question Group nameG1

    2 child questionsG1

    2 child questionsG2

    2 child questionsG3

    1 Question Group nameG2

    2 child questionsG21

    2 child questionsG22

    1 Question Group nameG3

    2 child questionsGG31

    2 child questionsGG32

    How to write an expression for this

    thank you

    i can not put indentation manually in this situation i need to write an expression

    can any one help me with this>

    thank you once again

  • September 23, 2010 at 11:51 am

    #1226506

    To make question 1 bold

    -in the Text Box Properties dialog, Font tab, click the fx button next to bold and enter

    =IIF(Fields!NameOfQuestionField.Value = 1, "Bold","Default")

    To make question 2 indent

    -in the Text Box Properties dialog, Alignment tab, click the fx button next to left and enter

    =IIF(Fields!NameOfQuestionField.Value = 2, "10pt","2pt")

    Obviously you can choose different amounts of indentation.

  • September 23, 2010 at 11:55 am

    #1226508

    Is there any relationship between the Qorder 1 items and the following Qorder 2 items or

    Qorder Question

    1 Question Group nameG1

    2 child questionsG1

    2 child questionsG2

    2 child questionsG3

    1 Question Group nameG2

    2 child questionsG21

    2 child questionsG22

    If there is, you could structure your dataset like the following

    QuestionGroup Question

    Question Group nameG1 child questionsG1

    Question Group nameG1 child questionsG2

    Question Group nameG1 child questionsG3

    Question Group nameG2 child questionsG21

    Question Group nameG2 child questionsG22

    Then you group by QuestionGroup and put the QuestionGroup in the group header for the group.

    The detail would then have the Question in the text box. You would apply left padding to the text box to indent the Question

    Russel Loski, MCSE Business Intelligence, Data Platform

  • September 23, 2010 at 12:00 pm

    #1226511

    I assumed you were grouping already, although the code I provided should work in either case. However if you are not, then Russel's suggestion to group might make it a bit easier to get the layout you want.

  • September 23, 2010 at 2:55 pm

    #1226617

    HI all,

    thanks for replying me. i did not grouped them instead gace the order 1 or 2.

    I WROTE THE EXPRESSIONS AS YOU SUGGESTED AND IT WORKED OUT.

    THANK YOU

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

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