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!

  • Congratulations gmmastros 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: *

  • Users: Drus
  • Order by date
  1. Drus

    MAS 90 Price Level Discount

    With my tech hat on: it sounds like you want to use Price Codes (I/M, Setup, Price Code maintenance). This allows you to have up to 36 price levels per price code. One price code per item. One price level per customer. It takes creativity to apply it correctly. Work out your ideas in a...
  2. Drus

    ODBC Connection With Access

    What you are describing has to do with Access. It saves you the hassle of having to re-enter the password. If I understand what you are trying to accomplish, you want to extract data and re-join the muliple companies back into a single table. If so I have done this before. You would want to...
  3. Drus

    While printing records

    What is "While Printing Records" used for? I have a subreport I am trying to pass a value from. It seems to not pass the value due to the record falling within the last sequence. Detail Records 100-00 pass-through works fine. 100-99 pass-through does NOT work. &ru
  4. Drus

    Combine multiple records into field, then group

    You may have missed the subtlety here. Or maybe I am missing the simplicity (but I doubt it). By adding the two fields together, here is the result I get... Table1.ItemNo Table2.ExtDesc Table2.Sequence Details > Record #1 A100ZX Interface, tabl 001 Record #2 A100ZX...
  5. Drus

    Combine multiple records into field, then group

    I want to combine extended description fields into one field that shows at the record level. For example... Table1:Inventory Item Table2:Extended description on inventory items Table1.ItemNo Table2.ExtDesc Table2.Sequence Details > Record #1 A100ZX Interface, tabl...
  6. Drus

    How to overlap details with a text box in right column

    I have a Bill of Lading where I need certain disclaimers to print in the right column. The disclaimer is fixed text and will span a range of details (items shipped). Here is the jist of what the form looks like... QTY ITEM# DESCRIPTION (This is where the 1 ABC ABC PART...
  7. Drus

    Weeks in a month?

    Below is the pattern to follow. I am getting a "5" as a result for 12/29/02 rather than a "1"? And how do I compensate for this? Sunday Saturday Week # 12/29/2002 1/4/2003 1.00 1/5/2003 1/11/2003 2.00 1/12/2003 1/18/2003 3.00 1/19/2003 1/25/2003 4.00...
  8. Drus

    Weeks in a month?

    Both answers have minor flaws in them and I'm not sure they can be corrected using either approach. I am thinking at this point it might be easier to have the user enter a parameter that passes through to the report. Thanks gurus, &ru &ru
  9. Drus

    Strip slashes from date

    I need to strip the slashes from a date field. I have: 1/2/2003 I need: 01022003 &ru
  10. Drus

    Strip Formatting

    My database has dates in this format: 1/21/2003 10/1/2003 I need these dates to appear in this format: 01212003 mmddyyyy 10012003 mmddyyyy &ru
  11. Drus

    Weeks in a month?

    Thanks, but I need it to tell me what week in the current month it is. And the fiscal year is slightly different than a calendar year. For example, the year starts at 12/29/02 and ends at 12/28/03. Even the months are atypical. Period 1 starts 12/29/02 and ends on 2/2/03. &ru
  12. Drus

    Weeks in a month?

    I need a formula that will return a value for which week the transaction date falls within the current month (1-5). In other words, if the transaction date is 2/3/2003 the result should be "2" since it is based on a Sunday - Saturday week. Another example is if the transaction date...
  13. Drus

    on last record

    Looks like it did not work completely. I see the logic in what you were attempting to do with "pagenumber = totalpagecount"; however, these are invoice forms. There may be 20 invoices in a batch. Therefore, the page number may never equal the total page count. Currently, the page...
  14. Drus

    on last record

    Thank you so much. Where can I learn these tricks? &ru
  15. Drus

    on last record

    Problem: I have a subreport in footer "a" and a large footer in footer "b". When the report exceeds one page, my page footer (where it says, "continued") does not show. I know that the reason for this is that I have a conditional suppress on the page footer...
  16. Drus

    Page Length

    I have a Bill of Lading that is printing on a dot matrix and need to change the page length to 8 1/2 x 7. Any way to accomplish this? &ru
  17. Drus

    Error in formula

    Why would the following formula return an error? totext({SO_23CRWInvoiceDetail.QtyShipped}/{IM_90_UDF_IM_Masterfile.Weight}) + " " + totext({IM_90_UDF_IM_Masterfile.Label}) When I save the formula in Crystal it does not find an error, yet when I preview the report the error pops up. &ru
  18. Drus

    If Contains, Then Group

    This formula will not give a result because I need to specifically search for a piece of text that matches: {Field A} = "MARFIM ANTARTIDA QTR RND" For "QTR RND" in that text. So IF "QTR RND" exists anywhere in {Field A} THEN "SBN & QTR RND" Is there...
  19. Drus

    If Contains, Then Group

    I want to create a group and then gather records into that group based on the contents of a certain field. IF {Field A} contains "SBN" OR "QTR" THEN gather record into GROUP A. ELSE IF {Field A} contains "DA" OR "BEAK" gather record into GROUP B. My...
  20. Drus

    Strip Formatting

    I get errors with what you gave. Maybe I misunderstood. Do you mean to place those formulas inside my existing formula somewhere? &ru

Part and Inventory Search

Back
Top