Search results for query: *

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

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

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

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

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

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.

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

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?

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

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

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

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

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

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

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

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

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

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!

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

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