Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ebstarasia

    Cross-tab average column

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

    Cross-tab average column

    thanks i got it to work now.
  3. ebstarasia

    Cross-tab average column

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

    Cross-tab average column

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

    Cross-tab average column

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

    Cross-tab average column

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

    Cross-tab average column

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

    Six months back to CurrentDate/ChangeDate

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

    Select Expert (STARTSWITH)

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

    Customizing Group Sort Order

    thanks that did the trick!!!
  11. ebstarasia

    Customizing Group Sort Order

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

    Twitter Widget with Joomla

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

    Complement Set in Crystal Reports 2

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

    Complement Set in Crystal Reports 2

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

    Complement Set in Crystal Reports 2

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

    Complement Set in Crystal Reports 2

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

    Complement Set in Crystal Reports

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

    Complement Set in Crystal Reports

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

    Complement Set in Crystal Reports

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

    Complement Set in Crystal Reports

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

Part and Inventory Search

Back
Top