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!

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

Search results for query: *

  1. skystar70

    Why can't I group using this formula field?

    Sorry. I may have missed one of the formulas. I was trying to include them all. Thanks for your comments. I guess this is beyond my level of experience.
  2. skystar70

    Why can't I group using this formula field?

    Hi. I feel like I've asked a similar question before, but here goes. I am on version 9. I am trying to group my report by the @Percent Variance formula and the formula is not available as a group. I am trying to group it because I actually want to sort by it, and I can't because I have another...
  3. skystar70

    Extract last name from name field

    Hi. Both formulas worked, but Nameparts was better as I discovered I had some records with multiple spaces in that field. I was able to use the following formula: Local StringVar array Nameparts := Split({st_code55.description}); if {st_code55.description} startswith ["CTS", "PT", "OT"] then...
  4. skystar70

    Extract last name from name field

    Hi. I have v9. I have a name field that is laid out as "FirstName LastName". I do not have two different fields for the first and last name. They are in the same field. Is there a way to create a formula that only displays the LastName? The LastName will always be after the space. Thanks! Sky
  5. skystar70

    Red line certain records

    Thank you both very much. I'm going to go with the one side of the text box. Much easier for me. Skystar
  6. skystar70

    Red line certain records

    Hi. I am on version 9. Can I write a formula to put a red line through records that meet certain criteria? I only want the line to be red. I want the text to be black. I know I can make both the text and line red or both black by doing a font formula for strikeout. And I know I can put a red...
  7. skystar70

    Highlighting Expert Locks up Crystal

    Hi. I have Crystal Reports Designer version 9. It seems, lately, when I select a field on my report, right click and select Highlighting Expert, my Crystal app locks up. I have to ctrl-alt-delete - end task to get it to close. Any thoughts or experience with this? This seems to be the only...
  8. skystar70

    Formula to Suppress Field Background

    Never mind. I got it. Didn't give myself enough time to figure it out. Here is my formula: if ({@ProjectEndDate} in Aged0To30Days) or ({@ProjectEndDate} in Next30Days) then yellow else white Thanks! Skystar
  9. skystar70

    Formula to Suppress Field Background

    Hi there. I am using Crystal version 9.2 and I am trying to put a yellow background on a particluar field of data and then suppress the backround if the data meets certain criteria. The field is a datetime field. I want to supress the backround if the datetime field is +/- 30 days from the...
  10. skystar70

    Group/Sort on Formula Field Containing Sums - continued

    No, I don't really have anyone accessible that can create this view. I will either manipulate the data in the database or dump the data in Excel and sort it there and publish the Excel report. Thanks for your help though. I appreciate your trying. Skystar
  11. skystar70

    Group/Sort on Formula Field Containing Sums - continued

    Did I just mess up the "Group/Sort on Formula Field Containing Sums" thread by posting the SQL Query? I don't see the section to respond to the posting any longer? If so, this is a continuation of the thread. Lbass, did you get the SQL Query that I posted? Skystar
  12. skystar70

    Group/Sort on Formula Field Containing Sums

    SELECT "vw_ACE_Work_Data"."work_title", "vw_ACE_Work_Data"."work_id", "vw_ACE_Work_Data"."work_depth", "custom_data"."acecmpldt", "custom_data"."planenddate", "vw_ACE_Work_Data"."ace_portfolio", "st_wbs99"."description", "vw_ACE_Work_Data"."ace_execution_stage", "custom_data"."planstart"...
  13. skystar70

    Group/Sort on Formula Field Containing Sums

    The formula is not available for inserting a summary. The formula is the summed project total already. If I could just sort on this formula field, life would be grand. So far, I have been doing all of my sorts for this report by inserting groups, but these have been on single database fields. I...
  14. skystar70

    Group/Sort on Formula Field Containing Sums

    Hi. Complex situation here (for me anyway). :) I have a report of project names and costs for each project, broken out by expense total and capital total, then project total. I need to sort the report by project total high to low. Here is why it is so complex: The records are summed at a group...
  15. skystar70

    Summary for Part of a Secondary Group - Placed in Report Footer

    Lbass, never mind. This worked! I figured out that there were more fields I needed to replace with my own and also there was a slight type in the first formula. Here is what I ended up with for the first formula: //{@accum} to be placed in the Group #2 footer: whileprintingrecords; numbervar...
  16. skystar70

    Summary for Part of a Secondary Group - Placed in Report Footer

    Lbass, forgive me but I am inexperienced with variables. When I try to create the first formula: //{@accum} to be placed in the Group #2 footer: whileprintingrecords; numbervar sumgrp2res1 := sumgrpt2res1 + ( if {table.group2} = "Result1" then {@Sub Total In Budget Expense} ); I get a message...
  17. skystar70

    Summary for Part of a Secondary Group - Placed in Report Footer

    Hi. Not sure how to explain this, but here goes. I have a report that has 2 groups: Group 1 - Result 1 Group 2 - Result 1 Record 1 Record 2 Record 3 Group 2 - Result 1 Summary Group 2 - Result 2 Record 1 Record 2 Group 2 - Result 2 Summary Group 1 - Result 1...
  18. skystar70

    Pie Chart - Unable to select a formula in expert

    Ah, that's Bestbegood. Unfortunately, the application I'm running only supports version 9. Sounds like I'm stuck. I'm playing with creating a special formula in a slightly different manner than the original and only using this formula for the chart if possible. We'll see....Thanks!

Part and Inventory Search

Back
Top