![]() *** Could it be a timing thing here? In other words, the conditional rule is applied BEFORE the DaysToShip field gets calculated? The conditional rule evaluates the empty field as less than 10 and changes to color of the background. When a condition is added to an aggregate function one should add If to this aggregate function name and additional argument with condition. Stimulsoft Reports allows adding a condition to an aggregate function. For example, it is necessary to sum up all values greater than zero. ![]() ALTER TABLE SalesData ADD AC AS SUM (COALESCE (val1,0)+COALESCE (val2,0)) An aggregate may not appear in a computed column expression or check constraint. Often it is necessary to calculate totals with condition. All of DATE backgrounds are colored regardless of the integer value. I am wanting to alter my table to have a column that is the SUM () of two other fields. To avoid clashing with the rules and to let me sneak up on this, the rule is only supposed to change the colors if the DaysToShip are less than 10 but it does not recognize the integer in the DaysToShip field. is lower, or green if the value is higher. Id be happy if I could get the font color change to red if the value. give an indication that its value is greater or less than the previous. Id like to add a condition to columns 2 to 12 that. ![]() I want to give color cues to the shop workers.Īt this time, the condition that I programmed does change the background color of the DATE. I have a report that summarizes activities on a monthly basis (sample is attached). If the DaysToShip is between 4 and 10, color the DATE background YELLOW. If the DaysToShip is less than or equal to 4 (or something), change the background of the DATE to RED. What I want to do is have an expression or rule that looks at DayToShip. The crude table below depicts what I'm trying to do.ĭaysToShip is a calculated field and it is working. The menu path is: REPORTS / ORDERS / JOB SCHEDULE
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |