# Where are Formatting Rules in TOAD DP 5.0.7+

**URL:** <https://forums.toadworld.com/t/where-are-formatting-rules-in-toad-dp-5-0-7/48819>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [January 23, 2020, 6:50pm UTC](https://forums.toadworld.com/t/where-are-formatting-rules-in-toad-dp-5-0-7/48819 "2020-01-23T18:50:28Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![michael.martinez2](https://avatars.discourse-cdn.com/v4/letter/m/9e8a1a/32.png) [@michael.martinez2](https://forums.toadworld.com/u/michael.martinez2)\
**Post date:** [January 23, 2020, 6:50pm UTC](https://forums.toadworld.com/t/where-are-formatting-rules-in-toad-dp-5-0-7/48819/1 "2020-01-23T18:50:28Z")

</div>

We have a toad data report (.tdr) that has formatting rules applied to certain fields.

i.e. If a value falls in a certain criteria, display x

![image](https://global.discourse-cdn.com/quest/original/2X/2/2c1b02bf7f474f4174c22518f3a2f042dc2a8625.png)

When I go to create a new report, there is nowhere to create a new formatting rule. I have to create the report in an old version of toad, add the formatting rule and then open it in the new version of toad.

Was this functionality removed? Is there something that replaces it that I am unaware of?

Thanks,

---

<div class="post-metadata">

**Author:** ![Gary.Jerep](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gary.jerep/32/205_2.png) [@Gary.Jerep](https://forums.toadworld.com/u/Gary.Jerep)\
**Post date:** [January 24, 2020, 6:25pm UTC](https://forums.toadworld.com/t/where-are-formatting-rules-in-toad-dp-5-0-7/48819/2 "2020-01-24T18:25:43Z")

</div>

As you may know, we use third-party components for some of Toad's capabilities, including report/chart designing features from DevExpress. For Toad DataPoint 4.3, it appears we used DevExpress Reports v. 17.x, but in later releases, we upgraded the DevExpress components to 18.x or later.

Just to confirm, yes, in Toad Data Point 4.3, I do see the Formatting Rules (pressing the smart tag for the report shows the formatting rules, per snap 1 below).

 ![image](https://global.discourse-cdn.com/quest/original/2X/d/d475dc63d48fa65dd12e6d84adf9d9e00c5bc6ad.png)

And, yes, in Toad Data Point 5.x, which uses newer versions of Dev Express Report Designer, I'm not seeing them, per snap 2 here.

 ![image](https://global.discourse-cdn.com/quest/original/2X/b/b2bfda561790e7a02f795badeb9aede12a2a372d.png)

It appears that Dev Express changed the way they do conditional formatting, switching from binding expressions on the data to some other method (Style sheets, perhaps?). We'll need our Development team to confirm how to do the equivalent of your formatting rules in the latest versions.

I would suggest opening a Support ticket, which is probably the fastest way to get to our Dev team, and will also help us document the resolution or work-around.

---

<div class="post-metadata">

**Author:** ![dan](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/dan/32/12882_2.png) [@dan](https://forums.toadworld.com/u/dan)\
**Post date:** [January 27, 2020, 11:01am UTC](https://forums.toadworld.com/t/where-are-formatting-rules-in-toad-dp-5-0-7/48819/3 "2020-01-27T11:01:30Z")

</div>

Hi,  
I can confirm it's not there anymore. It seems related to this question here: [https://www.devexpress.com/Support/Center/Question/Details/T710344/formatting-rules-missing-in-report-designer](https://www.devexpress.com/Support/Center/Question/Details/T710344/formatting-rules-missing-in-report-designer)  
Let me discuss with dev whether we can return this option to the Designer.

---

<div class="post-metadata">

**Author:** ![michael.martinez2](https://avatars.discourse-cdn.com/v4/letter/m/9e8a1a/32.png) [@michael.martinez2](https://forums.toadworld.com/u/michael.martinez2)\
**Post date:** [January 27, 2020, 3:03pm UTC](https://forums.toadworld.com/t/where-are-formatting-rules-in-toad-dp-5-0-7/48819/4 "2020-01-27T15:03:07Z")

</div>

Thank you Dan. To Gary's point, do I need to put in a support ticket as well?

Thanks!

---

<div class="post-metadata">

**Author:** ![dan](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/dan/32/12882_2.png) [@dan](https://forums.toadworld.com/u/dan)\
**Post date:** [January 29, 2020, 10:20am UTC](https://forums.toadworld.com/t/where-are-formatting-rules-in-toad-dp-5-0-7/48819/5 "2020-01-29T10:20:58Z")

</div>

> [@michael.martinez2](#):
>
> We have a toad data report (.tdr) that has formatting rules applied to certain fields.
> 
> i.e. If a value falls in a certain criteria, display x
> 
> ![image](https://global.discourse-cdn.com/quest/original/2X/2/2c1b02bf7f474f4174c22518f3a2f042dc2a8625.png)
> 
> When I go to create a new report, there is nowhere to create a new formatting rule. I have to create the report in an old version of toad, add the formatting rule and then open it in the new version of toad.
> 
> Was this functionality removed? Is there something that replaces it that I am unaware of?
> 
> Thanks,

Hi, no need to. I've set up a defect TMB-2397 and we'll need to investigate if we can solve it.
