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...
hi folks,
in fact this is an extension i'm trying to do.
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...
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...
Hi Madawc & folks,
Thanks. I had read that before. May like to refine my problem statement. Btw i'm on CR10.
What i meant is doing fuzzy search BASED on my input parameter which is dynamic upon report generation.
Thus if i were to program it, how do i write in my formula such that if
1. My...
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,
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.