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!

  • Congratulations strongm 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. fisheromacs

    Only Select certain rows

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

    Date Range Formula - Data from two months ago only

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

    show annivesary dates for next quarter

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

    Remaining Text does not appear problem

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

    A subscript must be between 1 and the size of the array.

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

    A subscript must be between 1 and the size of the array.

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

    Adding two formulas

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

    Date prompt use in Formula with DatePart?

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

    If field is Null

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

    Use a field from a subreport in a calculation formula

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

    Trying to get Select Expert Group f

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

    Passed variable from Subreport to Main skips one row

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

    How Do You Find Hidden WiFi AP?

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

    Driving an output 1km from input

    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.

Part and Inventory Search

Back
Top