Search results for query: *

Thanks for the help with this question. Sadly, I have to come back for this just for a quick help. I am using the report to do the weekly average, as mentioned above, and it works great. However, now I am asked to also have a report for the daily average. I noticed that when i change the...

thanks i got it to work now.

Total Week 1 Week 2 Week 3 Total 568 168 212 188 Alex 220 50 90 80 Zack 180 60 60 60 Sam 168 58 62 48 From your instructions(trying to get this clarified), Move the total...

I am getting an error message stating that you cannot divide by 0. numbervar wks = 0

whileprintingrecords; numbervar addcnt := currentfieldvalue; should this be true or false?

lbass, what exactly is the {@0} formula? is it just a null/empty formula?

I have a cross-tab that displays the weekly amount of files completed by each user. Total Week 1 Week 2 Week 3 Total 568 168 212 188 Alex 220 50 90 80 Zack 180 60 60 60 Sam 168...

I have a crosstab that I am trying to display data starting from the currentdate or even date specified (preferably)to six months back from specified date. {v_oimaster.CREATEDATE} in date(year({?change date}),month({?change date}-6),day({?change date}) to {?change date} where {?change date}...

I have a report that is selecting only file reference numbers starting with "CBO". However, since the turn of the new year, some files that are would normally be "CBO" are also now "CB" files. It use to be that there were two ref. no. to choose from, "CBO" & "CBA" making it easy to select which...

thanks that did the trick!!!

I have been working on a project that needs to display the customer's name, their most recent upload date of a file, along with the original name of their upload file(custom field). I suppressed the detail field and grouped the data by the name of the customer. I have the detail field sorted...

I am trying to add a Twitter feed module to my site, however I can't seem to find a great mod/extension to work properly. I did, however, get a Twitter feed to work for about a month. It was iNow Twitter Widget. For about a month it worked great, but suddenly every now and then when I came...

the house bills are the customers different shipments. From what I've been told, we want the event code to be added to the missing array if its missing but only displayed if it meets the criteria. So say if two shipments have missing "AR" "AV" & "AD" but shipment a has conditions where only...

I did try it. It's not doing exactly what I need it to do. Maybe I phrased my description wrongly. Let me try again, Each customer will have a different set of EDI event codes. which is array y. For BELK it is ["AE","VD","VA","UV","OA","AV"] For BROOKSTONE...

I don't see how that will add "AR" string into the array. I should also add that there will be other conditional statements for the other EDI event codes as well. I was just trying to get an idea of how to do one.

referring to forum discussion http://www.tek-tips.com/viewthread.cfm?qid=1657972&page=1 (Complement Set in Crystal Reports) I am now trying to go a step further in displaying the missing event codes. I am not trying to create an array based on conditional events. Let me explain: What i...

I got it to work. what i did was told it to suppress {@displaymissingcodes} = " ";

LB, basically what your code does, solve my the main issue of only displaying the event codes per house bill. layout looks like this: Company Name HBL number missing event code Design Group Header#1: Name of Customer/Company Group Header#2(suppress): House bill {@rest} Details...

error message for distinctcount({table.eventcode},{table.housebills}) = k "there must be a group that matches this field

does the whileprintingrecords; numbervar k; distinctcount({table.eventcode},{table.housebills}) = k go in the same formula {@displaymissingcodes} or a separate formula of its own?