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 derfloh 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 pb100

  1. pb100

    Can CR formulas be exported for review?

    I just answered my own question! For anyone else who is interested here's how to do it: Open the report and from the menu, choose File > Export > Export Report. Choose Report Definition (TXT) from the drop down and either save it to a file or open in an Application. A text file is created...
  2. pb100

    Can CR formulas be exported for review?

    Hi, I am working with a client in restructuring their reporting system. We would like to be able to export the formulas to compare them with similar reports for streamlining and possibly moving some of the logic into Stored Procedures. Is there a way to export the formulas into a text file or...
  3. pb100

    Change the color of 1 word in a formula for charts

    Hi lb, Thanks for the suggestion. The only stumbling block is that I also have a line in the chart showing volume so I'm limited to only 1 OnChgOf field. I'll probably set the values a and b to something meaningful and have them appear in the labels. Have a great day! -pb
  4. pb100

    Change the color of 1 word in a formula for charts

    Hi lb, My Chart has bars that read: 2006-a, 2006-b, 2007-a, 2007-b. The 'a' bars are yellow and the 'b' bars are blue and represent the national(a) or regional(b) sales values. My custom graphic legend indicates that yellow = National Sales and blue = Regional Sales. My customer just wants to...
  5. pb100

    Change the color of 1 word in a formula for charts

    Hi lb, In my chart, I have stacked bars and lines (1 OnChgOf and 2 ShowValues). The OnChgOf is by Year-a or Year-b and then bars for ShowValue1 and a line for ShowValue2. Year-a and Year-b are different colors and appear as separate bars even though they are stacked(another great workaround I...
  6. pb100

    Change the color of 1 word in a formula for charts

    Hi lb, The axis label formula is a string: totext(year(date),"#"). The sort value formula is also a string: If isnull(field1) then "a" else "b". I would like the a and b part of the labels to be "invisible". Thanks for your help! -pb
  7. pb100

    Change the color of 1 word in a formula for charts

    Hi all, I am using CRXI and SQL. I have charts where the On Chg Of formula is a concatenated string of 2 formula values. Is there a way to set the color of the second value to white (so it does not appear in the axis label). My formula looks something like this: {@axis label}&" " &{@sort...
  8. pb100

    Charting on Print Time formulas - array error

    LBass, that's it! Wow, thank you so much! I spent way too much time on this, should have written in sooner...!
  9. pb100

    Charting on Print Time formulas - array error

    Hi all, I am using CRXI with SQL. I have implemented the instructions from the Charting on Print-Time Formulas white paper and am getting the error "A subscript must be between 1 and the size of the array". I was able to reproduce the example from the white paper and the chart worked but...
  10. pb100

    Format multiple fields at once

    Thank you both for the great tips! It did save some time to use currentfieldvalue!
  11. pb100

    Format multiple fields at once

    Hi all, Using Crystal XI, is there a more efficient way to apply formulas to format fields? I have table style reports with 3-4 groups whose fields are the result of formulas. I overlay those fields with an 'N/A' text field and set the format to suppress if certain conditions are met on the...
  12. pb100

    Format date to 2-digit year (M/d/yy)

    Thought I would post this tip as I figured out the answer by trying different options after reading through several posts. I could not find a straightforward answer so hopefully putting it here will help someone else. I use CRXI and SQL 2005 and had a report with a text field description of...
  13. pb100

    Stacked Bar Chart Legend customization?

    Using CR XI with SQL, I have stacked bar charts where the stack is the sum of a formula. The result of that formula can represent one of 8 choices chosen by the user as a parameter (i.e. Type A, Method 1, Category 123). How can I customize the legend to show the dynamic value of what that...
  14. pb100

    Program object failing with a .bat file

    Hi, Thank you for responding! Yes, the .bat file works on the same machine that CE is on when launched directly. In CE, I get the error regarding operating system credentials. The default Windows login on that machine is the administrator. Any ideas? Thanks so much for your help!!
  15. pb100

    Program object failing with a .bat file

    We develop reports in CRXI Developer use CR Server to deliver them to the end user. We are now trying to launch a Program in CR Server which is a .bat file. The .bat file works great when launched within Windows but fails within Crystal Server with the error message "No operating system...
See more

Part and Inventory Search

Back
Top