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

    Weekly Function ?

    Hi thanks. Hm, i was thinking of the Week No of the Year to manipulate too. I might need to be more elaborate on this. Sorry for the missed out details. In fact i am extending on my current report that summarized order backlog figures into various period buckets ie (PastDued, Current Month...
  2. ricolame

    Weekly Function ?

    Hi folks, Need some expertise on this. Have anyone done a report that actually breakdown by Weekly of the month. Ie. 1st Week , 2nd Week , 3rd Week and 4th Week of the month? I am trying to window our orders backlog into this 'window' period. I've done a similar one on monthly view ie for...
  3. ricolame

    GRAPH/Report footer appearing at the start of LAST PAGE

    Oh my, can't imagine i missed that simple option...after playing so much on the other configurations.. Thanks alot. It makes my day! With regards, CR10 Win2k SQLBase 7.6.1
  4. ricolame

    GRAPH/Report footer appearing at the start of LAST PAGE

    Hi folks, I am trying to automate my report delivery, and am trying to achieve my footer section of my report to appear at the start of the last page. It is a summary section of shared variables from my numerous subreports in fact. May i know how is it achievable such that my report section...
  5. ricolame

    Fuzzy Search Parameter Function

    ...Having my report returns multiple wildcard searches. I have a formula similar to below: (If {PART.ID}<>'ALL' then UpperCase({PART.ID}) like "*" & UpperCase({?PartID}) & "*" else {PART.ID}<>"") Now, my PartID input parameter accepts multiple values. But i'm having similar issue as...
  6. ricolame

    Fuzzy Search Parameter Function

    Hi dgilz, Thanks. I was thinking on both the questions you raised. In fact, the answer is still A and B. Yes, it is a report to print based on this keyword input? and yes, the report is to print customer name (in fact it is a shipment report i'm doing which i wish to pull specific customers...
  7. ricolame

    Fuzzy Search Parameter Function

    Hi Madawc, Thanks. So it is just basically the formula that you gave that makes the trick. I was on that line of thoughts but did not thought of the ampersand sign..which i used + instead. Thanks!
  8. ricolame

    Fuzzy Search Parameter Function

    Hi, It should be anything similar to this ? {CUSTOMER.NAME} like "*{?CustomerName}*" but because of the need of ", i tried something like """+{?CustomerName}+""" which failed on me.. dgillz,not sure if i did interpret wrongly, but i want wildcard search of customers pertaining to the...
  9. ricolame

    Number Display

    now, if i've to use the figure to sum for summary, i have to change it back to number =)
  10. ricolame

    Number Display

    hmm. stupid me. tks, with regards,
  11. ricolame

    Fuzzy Search Parameter Function

    ...field is {?CustomerName} 2. Fuzzy search on data field call Customer.Name 3. Say my input is gobby, my fuzzy search will do something similar to *GOBBY* in my database and return something like HAPPY GOBBY PTE LTD GOBBY PTE CO etc.. 4.Next i will extend it to accepting multiple values and...
  12. ricolame

    Number Display

    hi madawc, For ToText, there's a problem with number less than 1, it shows .xxxx, instead of 0.xxxx Is there a way in formula to include leading 0 ?
  13. ricolame

    Fuzzy Search Parameter Function

    ...on the paramter enter. Ie. Customer Name Field Parameter is {?CustomerName} So i would like to have a selection formula that equates to *{?CustomerName}* where i will also convert the input name to UPPERCASE too. I should i have it written in my formula field ? Any help here is greatly...
  14. ricolame

    Number Display

    Hi folks, Would like to seek advice how i should i go about formatting my number figure so that my number can display decimal to 4 places when there is decimal figures with leading zero in front(if less than 1), and if it is not, default to whole number ? Currently i can only default to...
  15. ricolame

    Wsd_sock32.dll and NAV 17-01 Definition Update

    Hi folks, Am faced with a very prominient situation where we have a majority of computers infected with wsd_sock32.dll (which was undetected for the past few days) With 17th-Jan detection, it was detected,removed and after a user reboots the pc, am prompted with a LSASS.exe countdown when...
  16. ricolame

    Moinitoing individual Shared Files in Corporate Network

    Hi, How do u delete personal files if you are not given access to ? Do you make use of any software to assist in your scanning ? Anyone else have any similar freewares that can assist in scanning company shared files ? With regards,
  17. ricolame

    Moinitoing individual Shared Files in Corporate Network

    Hi guys, Not sure if it is the appropriate site, but dealing with IT and monitoring ethics.. so here it is.. Have anyone monitored the shared folders of the terminals in your corporate network ? Recent complaints of games, 'illegal' files being shared by individulas have put us another...
  18. ricolame

    Sporadic Threat Risks And Eventual Crippling of NAV

    Hi guys, Am faced with a serious situation where my NAV started off with a simple threak risk Infostealer.Lineage, and triggered a string of risk attacks. Eventually, noticed nav files being detected for deleted/cleaning, and not long later, the whole engine is crippled and prompted for...
  19. ricolame

    Printer monitoring software

    am fervently looking for one too.. anyone here?
  20. ricolame

    Not using exchange server - How to archive emails?

    yup it could be done on server side. Am on qmail.. does exchange do that too ? wasnt aware of that though. All incoming and outgoing mails were made a copy to a log account where i'll receive through POP access and store them locally. It's interesting to see all the mail failure...

Part and Inventory Search

Back
Top