Search results for query: *

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

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

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

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

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

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

I'm working on a formula which will add a 1 everytime there is a date in my field. Basically if my field (f422#Close_date) has a date, then a 1 is added. If there is no date(empty) then 0. How do you signify a null or empty set.. i tried this but it does not work: if {f422#Close_date}) <> ""...

We have this formula placed in our group footer NumberVar SaleCount; if UCase({external_sales#sales}) = "Sold" then 1 else 0 We have inserted the formula into a group footer, and it prints results accordingly. How can we prevent the formula from printing if the value is 0. Ideally, we don't...