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!

Register Log in
  • Congratulations derfloh 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: *

  • Users: ricolame
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. ricolame

    Fuzzy Search Parameter Function

    Hi folks, Another qn if you guys had done this before.. I would like to have a FUZZY SEARCH 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. ricolame

    Archiving of Company Mail Records

    Hi guys, I've recently setup a pop account that make a copy of every individual sent & received mail. Need some advise from you gutus out there 1. Am on qmail, my vendor told me that a command was written on the queue folder that enable the whole process. Were advising to set up additional...
  9. ricolame

    Outlook Attachment -> Outlook Express Missing Attachment?

    Hi guys, Would need some advise esp from pple who are familiar with mixed Outlook 2003 & OE clients in their environment. I'm encountering random & persistent missing attachments sent out from Outlook 2003 clients and Outlook Express users are not receiving the attachment, but just the usual...
  10. ricolame

    Summing / Counting field based on Field (after printing)

    Hi, I've use a summary field in my report which pulls out a maximum date from my list of records. On top of that, instead of using selection to select my records (since it could not work due to 'reqd after printing') , i perform a suppression of field based on a condition such that {@maxdate}<...
  11. ricolame

    SELECTION condition

    Hi folks, I'm facing a weird scenario while using SELECTION formula. I've a select condition such that {INVENTORY_TYPE.CLASS}<>"A". The only values in CLASS is A,I and R. Now, I changed the formula to {INVENTORY_TYPE.CLASS} ="I" and {INVENTORY_TYPE.CLASS} ="R" and it will never work. My...
  12. ricolame

    Use Group and Outline in Excel with Protection On

    Hey guys, I need help to use group & outline when my protection is turned on. Is there a way to do that?
  13. ricolame

    452 Too Many RCPTs

    Hi guys, Clients are having abv mentioned errors, and our check discovered it's has nothing to do with our mail isp. We have zoomed down that a mail sent to more than 10 recipients, my user would be prompted an error and subsequently, that mail is not being sent out but placed in my sent...
  14. ricolame

    Help with a SQL Query

    Hi folks, My brain is going abit dead.. need some technical advise on sql query.. VENDOR_QUOTE table : vendor_id,partid,quote_date,default_price for each part, i can have few vendors for each part, i can have few quote dates i need to know how i should write my sql such that, it will return...
  15. ricolame

    Header Link to its Footer?

    Hi guys, Since suppressing / hiding of subreports are not possible, and the fact that my main report do use quite a handful of subreports and the avg value in these reports.. I would like to ask if it is possible that i can create some kind of link that will leads me straight to the footer of...
  16. ricolame

    Shared Variable and Subtotals, Totals-

    Hi guys, my report has finally come close to an end.. ok i have 3 subreports generated for a part record. Each subreport has a shared variable (avg price field) to the main report depending on certain conditions. Now, i have a problem doing summing of subtotals. I have a Qty field for the part...
  17. ricolame

    SQL Command and Parameter in Main Report

    hi, is there a way i could link my sub sql query (by adding command) to my formula variable in my main report ? Below is my query frm my analyser which works well: SELECT customer_id,part_id,default_unit_price,qty_on_hand,udf_layout_id FROM CUSTOMER_PRICE CP,PART P WHERE ( CP.PART_ID NOT IN...
  18. ricolame

    Date Range Selection to Subreport

    Hi folks, Another head-swelling problem for me. I have a parameter {?Period} that returns the no of months i should look back to trace records i have written successfully a formula minDate minimum(PastXMonths({?Period})) where it will return the minimum date i should start searching Now...
  19. ricolame

    Subreport isEmpty ?

    Hi folks, Working on subreports, and another question: Is there any kind of formula that i can write to detect if the subreport is empty? Kind of subreportIsNull formula.. As I am working on two subreports per record set on my main report, I would like to put up flags to indicate which...
  20. ricolame

    Sub Report and Suppression

    Hi folks, Been reading through the posts here for aiding but couldnt solve my issue. I have 2 built-in subreports say Purchase Orders History and Sales orders History separately. I'm pulling shared variables from these two subreports in my Detail section where the 2 variables comprise of avg...

Part and Inventory Search

Back
Top