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 Chriss Miller 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. pineisland99

    Hiding/Suppressing a Group

    dgillz and Madawc, Thanks for the help I went into the Section expert, highlighted the details section, checked off suppress, then clicked on the (x+2 and a pencil) button, which takes me took me to the editor where i entered: GroupName...
  2. pineisland99

    Hiding/Suppressing a Group

    well I have 2 groups in the report. They are based off a question ( fu148#reason ).If the question is populated with an answer, it goes to one group. If the question has no answer(null), it goes to the other group - I would like to hide this group altogether. I have gone into the Section...
  3. pineisland99

    Hiding/Suppressing a Group

    Crystal Reports 9.2 How Can i hide/suppress a group in Crystal? I have to groups in my report, one with the data I want. The other with the data I don't want. I can't discard this data because I need it reflect in my summaries. Thank You
  4. pineisland99

    Adding Issue

    Thank you. I used a similar solution to yours, where I looked at a field to verify that it was not equal to "Y" before the if-then run, then set it to "Y" once the run was complete: dim strNCost as string dim strProg as string dim strfix as string dim strArm as string dim strNewRate as single...
  5. pineisland99

    Adding Issue

    Hello All.... Please excuse if not in correct section. Below is a macro I wrote which adds 1 point to my variable(strNewRate) when certain conditions are met. This macro runs when 'save' is clicked on the application. It is written in a macro editor that is part of the app. The macro...
  6. pineisland99

    A boolean is required

    I was creating the report under the field explorer. I did try the solution by lbass and it appears to work well. Thank you all for your help.
  7. pineisland99

    A boolean is required

    Crystal Version 9.2 How am I creating this formula - I had the formula as below when I was using groups, but now management has changed the request so need some more logic... NumberVar ProcCount; if UCase({TRACKING_FILE.fu36#loan_queue}) = "Processing" then 1 else 0
  8. pineisland99

    A boolean is required

    Attempting ti build the below formula but am receiving the above error on saving it: if {TRACKING_FILE.f453#processor_name} or {TRACKING_FILE.f321#closer_name} = "Naheed Gulamali" then if UCase({TRACKING_FILE.fu36#loan_queue}) = "Processing" then 1 else 0 What am I doing wrong?
  9. pineisland99

    Hiding Results/Including in totals

    How can I hide/suppress certain records from my details section that don’t meet a certain criteria but still have them included in my totals. Example – have the following field in my report: 7001#buyer_name I have another field: 148#nonoffer_reason I want to display 7001#buyer_name only if...
  10. pineisland99

    "A summary has been specified on a non-recurring field"

    Thank you all... I edited the formula to the below, removing GroupName and it is giving me the intended results: NumberVar ClsCnt_Cls; if {TRACKING_FILE.f453#processor_name} = {TRACKING_FILE_CUSTOMREPORT.f321#Closer} then 1 else 0
  11. pineisland99

    "A summary has been specified on a non-recurring field"

    Thanks, Running totals sounds like it would work, however my formula still doesnt show in the Running Totals drop downs...AHH!!! All my other formulas show except this one....Theres something about the way Crystal is viewing this value. Thanks Again
  12. pineisland99

    "A summary has been specified on a non-recurring field"

    I am trying to insert a summary in my report. My first sign of trouble is that the formula I want to summarize is not appearing in the "Choose field to summarize" dropdown in the summary dialog box. I cut n' paste the formula into another formula that did show in the drop down and recieved the...
  13. pineisland99

    Formula Question

    Appreciate the help. I ended up modifying the code as below and it worked if {TRACKING_FILE_CUSTOMREPORT.f463#Status} <> "C" then if {TRACKING_FILE_CUSTOMREPORT.f463#Status} <> "R" then if {TRACKING_FILE_CUSTOMREPORT.f463#Status} <> "W" then if {TRACKING_FILE_CUSTOMREPORT.f321#Closer} = 'TBANC...
  14. pineisland99

    Formula Question

    OK! edited my formula as below, however am getting an error of type: "A number, currency amount, boolean, date, time, date-time, or string is expected here." The error appears to be pointing to the [“R”, “W”, “C”]) piece. My values in this field are strings. if...
  15. pineisland99

    Formula Question

    To clarify: This is my formula: if {TRACKING_FILE_CUSTOMREPORT.f321#Closer} = 'TBANC New Construction' then NewConstructionCount:= NewConstructionCount + 1; I need it to run only when field (f320#loan_status) is not equal to A, W or C. I tried the below, but it errored out: if...
  16. pineisland99

    Formula Question

    I have the below field in my database: (f320#loan status) This field can have an answer of 'closed' or 'open' I have the below formula in my report: if {TRACKING_FILE_CUSTOMREPORT.f321#Closer} = 'TBANC New Construction' then NewConstructionCount:= NewConstructionCount + 1; I need the formula...
  17. pineisland99

    Supressing Detail

    I have a field in my db which holds state and zip data(ie - Fl 33165) I am building a report with a field that should display zip code only. What code can I put in a formula to, say, remove the first 3 characters of my output - Ideally, my result would display only the zip code. Thank You
  18. pineisland99

    Summing Summaries

    Thank You, New formula was created with your info. plus some added code and placed on report footer; (Sum ({@ProcCount})+Sum ({@ClosedCount})+Sum ({@UwCount}))-Sum ({@ClosedDateCount}) Thanks Again!
  19. pineisland99

    Summing Summaries

    I have the below formula in my group footers - It basically adds a few sums together - I want to add all if its results together in the report footer - When I try to use the Summarize function, it doesn't show/allow me to pick this formula as a 'field to summarize' Sum ({@ProcCount}...
  20. pineisland99

    Defining Null Value

    Beautiful: I changed my formula to: if isNull({f422#Close_date}) then 0 else 1 this worked, thanks

Part and Inventory Search

Back
Top