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...
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...
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.