I am trying to hide a table based on data. Are whole tables subject to conditional formatting? I have not even been able to get individual rows to see it.
Here is my expression:
=Reportitem.parent.dataobject.Tiertype = "4T"
Style result is Visible = false (unchecked).
This is the latest of many excpressions I have tried.
Thanks for your usual wise counsel.
Here is my expression:
=Reportitem.parent.dataobject.Tiertype = "4T"
Style result is Visible = false (unchecked).
This is the latest of many excpressions I have tried.
Thanks for your usual wise counsel.
7 Answers, 1 is accepted
0
Hi Bob,
Actually your expression is correct. I've just tested this on our ProductCatalog demo report using the following conditional formatting applied on the Table:
=ReportItem.Parent.DataObject.ProductModel = Water Bottle (screenshot 1)
and the table for that product model was successfully hidden (screenshot 2).
Sincerely yours,
Steve
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
Actually your expression is correct. I've just tested this on our ProductCatalog demo report using the following conditional formatting applied on the Table:
=ReportItem.Parent.DataObject.ProductModel = Water Bottle (screenshot 1)
and the table for that product model was successfully hidden (screenshot 2).
Sincerely yours,
Steve
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
0
![](/forums/images/avatarimages/default.gif)
Bob Bruce
Top achievements
Rank 1
answered on 22 Mar 2010, 03:20 PM
Thanks, but my table just won't hide. It is in the Detail Section and uses the same datasource as the overall report. I even added the test field to the table, and it shows up, but it should have been a column in a hidden table. Is your sample project downloadable? Maybe there is still something I'm missing.
0
Hi Bob,
I'm using the ProductCatalog report from the Visual Studio examples installed along with the product. You can apply the rule from my previous post to that report and compare the differences compared to yours.
Greetings,
Steve
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
I'm using the ProductCatalog report from the Visual Studio examples installed along with the product. You can apply the rule from my previous post to that report and compare the differences compared to yours.
Greetings,
Steve
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
0
![](/forums/images/avatarimages/default.gif)
Bob Bruce
Top achievements
Rank 1
answered on 29 Mar 2010, 09:09 PM
I can not locate the sample Visual Studio project (using VB, I hope), because they are somewhere in our vast network. Can you send me the ProductCatalog, or whatever project you think would be best. As always, thanks for your prompt and helpful responses.
0
Hello Bob,
The examples are installed on the same machine you use to build the reports along with the product itself (see attached screenshot). You can start them from the Start menu --> Telerik --> Reporting --> Visual Studio examples. You would then be able to locate the ProductCatalog report and use the code provided in previous post.
Best wishes,
Steve
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
The examples are installed on the same machine you use to build the reports along with the product itself (see attached screenshot). You can start them from the Start menu --> Telerik --> Reporting --> Visual Studio examples. You would then be able to locate the ProductCatalog report and use the code provided in previous post.
Best wishes,
Steve
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
0
![](/forums/images/avatarimages/default.gif)
Bob Bruce
Top achievements
Rank 1
answered on 30 Mar 2010, 03:14 PM
Thanks, but our IT dept installed the software and I don't know where the server is, and samples are not in the Start menu, and the guy who did it is out for the week. Can you send me a zipped copy of the vb.net project?
0
Hi Bob,
Thanks for the clarification and no problem! I've attached the VB.NET ReportLibrary for your reference.
Sincerely yours,
Steve
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
Thanks for the clarification and no problem! I've attached the VB.NET ReportLibrary for your reference.
Sincerely yours,
Steve
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.