Search results for query: *

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.

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

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

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

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

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

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

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

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

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

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

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

Yes, I do see it.

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

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

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

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

LB - One summary for all Group 2 - Result 1.

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

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!