Conditional Format OR How to Use

[Shanka]

Hi,

I am trying to use conditional formatting for a visible Group section and  I want to  compare a field value.

Compare the field "InvoiceType"

Fields.InvoiceType equal "2" Or "0" then Visible the Group section

now I'm set visible : false in Group Property.

Please help to do that

Thanks.
Shanka.

[Peter]

Hello Shanka,

To set a section or an item conditionally to visible false you have to do it the other way around. First you leave the item/section Visibility property to True and then you add a new conditional formatting rule. In your case the rule has to be as the one in the following table:

Expression	Operator	Value
= Fields.InvoiceType <> "2" OR Fields.InvoiceType <>"0"	=	=True

and then you set the Style's Layout to Visible False. 

Best wishes,
Peter
the Telerik team

[Shanka]

Thank you Peter for your Help.

[Lorena]

Hi,

I am having problems with setting the visibility of a report item (a textbox). I set the Visible property of the TextBox to True, and then I defined a Conditional Formatting Rule (PageCount > 0) and un-check the "Visible" checkbox in the Style -> Layout window. This has no effect on my TextBox: it's always visible. I want the Textbox to be invisible if the report has at least one page. (of course, the scenario in my report is much more complex, this is just a simple test to show you I cannot make invisible a simple TextBox in my report). I attach a print screen with details about the above properties on my TextBox.
I am using Q2 2013 Telerik Reporting, but on another PC I installed the trial version (Q2 2014) and the result is the same.

Seems like I'm missing something or doing something wrong, but cannot find out what.

Thank's
Lorena

[Nasko]

Hello Lorena,

The PageCount global object can be used only in page header and footer. For more information, please refer to the Global Objects and Report Life Cycle help articles.

Our suggestion is to change the formatting rule expression to use a data field, or the count of the retrieved data records.

Regards,
Nasko
Telerik

 

 

[Lorena]

Hi,

thank you Nasko for the help.
I managed to hide the textbox I want (in a Table, because my scenario is related to a Table), using conditional formatting. But I want also the space to disappear, not only the content of that TextBox. I have 20 columns with values in a Table, and on the 21st column I have a comment on my set of values. But when few values are set in my DB, I want to place the comment right after the last not-null value, not at the end of the space allocated for all values.
For example I want to obtain something like in the attached picture. Is it possible to do this with Conditional Formatting or any other way, in a table?

Thank you,
Lorena

[Lorena]

I forgot to mention something: the size of each textbox value is much smaller than the size I have to set on the comment textbox (just like in the photo).

[Nasko]

Hello Lorena,

The Table item provides means to achieve a tabular layout. However, it is not suitable for the described scenario.
It might be more suitable to use text boxes and align them accordingly. For more information, please refer to the Design Considerations for Report Item Layout help article.

Regards,
Nasko
Telerik