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