Unable show the values

  • Hi ,

    I have to create a report which have the Tablix inside the tablix ..

    (let say tablix1 have some set of columns,one of the column have the tablix 2)

    The text box inside the tablix have calculation like =sum(feilds!testnumber.value) if the caluclation is 0 the data in the text box is not showing in the preview mode.

    Can anybody help on this..

    Thanks in advance..

    Veeren

    Thanks & Regards,
    Veeren.
    Ignore this if you feel i am Wrong. 😉

  • Guys please give me ur ideas on this...

    Thanks

    Veeren..

    Thanks & Regards,
    Veeren.
    Ignore this if you feel i am Wrong. 😉

  • So if the Sum of the test.value is 0 then it doens't show 0 but just shows nothing?

    If that is the case then check the number tab in the textbox properties. There is an option called Show Zero as: . This let's you select (None) a blank or a -.

    This is the first thing that comse to mind though. I don't think it has anything to do with the fact that you have a tablix in a tablix.

  • Hi,

    I tried that like changing the number format and set the show zero values as "o"(English letter) but its not working...

    I need to do in the way like tablix inside a tablix:

    Because there is no way in SSRS to interlink Row group values with the Column Group values, so the only way is create a row group tablix and put one more tablix wich have column group.

    Thanks,

    Veeren.

    Thanks & Regards,
    Veeren.
    Ignore this if you feel i am Wrong. 😉

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

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