Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by mbaml

  1. mbaml

    Grouping and Conditional Formatting

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

    Grouping and Conditional Formatting

    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} >...
  3. mbaml

    Formatting: Alternate shading within a report w/custom color

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

    Grouping and Conditional Formatting

    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.
  5. mbaml

    Grouping and Conditional Formatting

    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...
  6. mbaml

    Formatting: Alternate shading within a report w/custom color

    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....
  7. mbaml

    Formatting: Alternate shading within a report w/custom color

    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...
  8. mbaml

    Creating Drill Down Options

    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'...
  9. mbaml

    Formatting: Alternate shading within a report w/custom color

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

    How to Change the DSN in a report after its created....

    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!
  11. mbaml

    Group Summarization (count)

    Got it, thank you!!!!!
  12. mbaml

    Adding Pie Charts

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

    Creating Drill Down Options

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

    Formatting: Alternate shading within a report w/custom color

    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.
  15. mbaml

    Group Summarization (count)

    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
See more

Part and Inventory Search

Back
Top