Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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