Search results for query: *

Maybe something like this. ({@FormattedLineType} = 'Source' OR {@FormattedLineType} = 'Finished') OR ({@FormattedLineType} = 'Finished' AND ({#Row No} = 1 OR {#Row No} = 2))

Your formula does a distinct count for all available records, just like it is being asked to do. the if....then part does not change the record set. I would use an 'accumulation'/'manual running total' formula like below: numbervar count2; if{vw_report_event_infos.report_created_date} in...

in english, the below is what you want...i think. If hiredate is in apr mar june then Q1 else if hiredate is in july aug sept then Q2 else if hiredate in oct nov dec then Q3 else if hiredate in Jan feb mar then Q4 If the above is correct, then you would want change your how your formula...

Does my re-doing of your description still sound correct. In my experience, Crystal checking for nulls/negatives first tends to return the most accurate results. 1. If no Customer Name and no udfcustomer name and udfcustomervarious is false (non-boolean 0?) then Stock 2. If no Customer Name...

you can do a null/value test before the Split. something like Local stringvar z := ""; IF isnull(showval) = TRUE then z := "NULL" ELSE IF TRIM(showval) = "" then z := "BLANK" ELSE z := split(showval,"^")[x]; but from what you have shared so far, i don't think showval is getting any value...

What is the text of the error you are receiving? Also, what are the contents of the formula {@diffPercent}?

where are you placing the absent + tardy to absent formula? If it is not, try putting the formula in the group 1 student group footer.

Is your data dates or text/string or numeric? You likely some sort of a compatibility check and then a conversion if it is not a date format.

Are you certain that the field is null? You can change the formula to account for spaces/blanks that are not null like this: if isnull({IM_Warehouse.WarehouseCity})OR TRIM({IM_Warehouse.WarehouseCity})="" then "In Transit" else {IM_Warehouse.WarehouseCity}

Create a shared variable in the subreport to contain your Total1. ie: {@SharedUpTTL1} as: shared numbervar ttl1 := {@Total1}; create a matching shared variable in the main report. ie: {@SharedTTLT1} as: shared numbervar ttl1; you should be able to use the new variable in the main report...

I think you will need to apply your filtering after loading data. Sort your data by invoice total then compare using previous or next and suppress those items that you do not need/want. You will also probably need to group on some other field(s) to help weed out erroneous matches. I can think...

Where is your subreport placed? I think it will work best in your Group Header.

It is possible that there is a single access point with multiple ssids. I would use a utility like WiFiAnalyzer from VREM Software on an Android phone to see all the APs and their associated SSIDs. I would use a utility on a PC like Advanced IP Scanner to see exactly what is on the networks...

Point to Point bridged wifi network would be my 1st suggestion, but you would have to have power at both points and make sure they are properly aligned with each other.