Recent content by ricolame

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

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

hmm. stupid me. tks, with regards,

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

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