Search results for query: *

PERFECT, thanks LB! Again, your help has been invaluable this week and very much appreciated!!!!!

OK, thank you. I checked the updated formula...no errors found. However, it is still saying "others" in my report where the null fields are and its supposed to say "In-Process" Here is the formula exactly as I ran it: if isnull({Risk.RiskClass}) then "In-Process" else if {Risk.RiskClass} >...

OK, I got it, thank you very much for your help!!!!!!

I am entering the formula exactly as you have it and am getting the error: ")Missing" That is why I changed it the first time because by taking the Is Null out, I was able to have the formula work.

Hi LB, Running into another problem with this formula. So, The formula posted above that does work it what I am using, only I am adding to it that IF the risk class is "NULL" in the table I am pulling the data from, then I want it to say "In-Process" in the grouping. Right now, the current...

crDAE5F7" is a custom color, based off of a color in a client's logo. I want that color and white alternating through the details field....

I went into section expert, selected a white background color, and then clicked on the formula button and enterer the following formula: if remainder(Group #1 Name,2) = 0 then cr#DAE5F7 else crnocolor I am getting an error "(is missing". The "crDAE5F7" is the custom color I want alternating...

I cannot figure out how to create the drill down option itself off of a group. So I have a report grouped by country, and I want the user running the report to be able to chose a country they want to run the report on using a drill down option, OR they can choose to run the report on 'all'...

Thank you! Can you tell me where exactly I setup this formula?

We need to change the dsn from one server to another, that may have a different connection string, AFTER we have alread created the report in the development environment utilizing a different server. PLEASE HELP!

Got it, thank you!!!!!

Need to add a pie chart that reflects the count of a grouping. Each group being a separate part of the pie.

Need to create a drill down option where a user can select a group and the remainder of the groups will disappear.

Need to create alternate shading within a report that skips over the grouping names I have setup. So one line blue, next line white...etc. Also, need to use a custom color code.

Have a report grouped and need to do a count of how many are in that group, listing the total at the top and bottom of the group

Answered my own question, I grouped the saved formula by "special" order and chose which order I wanted to see the risk classes in. THANKS VERY MUCH FOR YOUR HELP!!!! I may have more questions before the day is done. VERY appreciated LB!!!!!!!

OK, I figure out how to get the wording in there, finally got the formula right. NOW I need to figure out how to group the risk class by the words I added. Here is the formula I used and here is an exmaple of the report. Formula: if {Risk.RiskClass} < 34 Then "Low Risk" else if...

OK, so I have the formula as the following: if isnull({Risk.RiskClass} <34 then"Low risk" else if {Risk.RiskClass} > 66 then"High Risk" elseif {Risk.RiskClass} in 34 to 66 then"Medium Risk" When I check it in the formula editor, It says I am missing ")" somewhere. Also, I have no grouping...

Hi LB, I am no longer in the office but will be back into this problem in about 10 hours. The field name in the table I am linking to is {Risk.RiskClass} the data in the field is a number (between 1 and 100). I want to group the report so that if that number is between certain parameters...

I am trying to group the report based off of the risk number within the report. So anything within the risk class field that is between 0-33 I want it to be grouped and say "LOW" as the group name, I dont have the classification of "LOW" anwhere in the table I am pulling the data from, I need...