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

    Is it possible to link to a table with a formula?

    No, there are just 340 matches, ergo the case statement will be 340 cases long. There are no combinations to be had, basically I have a table with 2 columns, the 2 letter code, and the description. Since they can appear in any combination, what I am instead doing is taking the combined codes...
  2. barc0001

    Is it possible to link to a table with a formula?

    I have a report that has a field that is made up of 2 letter codes. I also have a CSV file that breaks these codes out into descriptions. For example, LHDZ would mean "Left Hand (LH)", "Double reinforced (DZ)". So, I want to break these fields into their two letter...
  3. barc0001

    Fields disappearing from report after group is added!

    SynapseVampire: If you're familiar with MAS90 and have access to it, you might be able to see it live and in color for yourself. The fields in question are located in the SO_20CRWSalesOrderDetail table. Ken: I've tried moving the items to different subsections and creating new...
  4. barc0001

    Fields disappearing from report after group is added!

    Hi there; No, it's not a view or a query, they're simply different fields in the same table... I do get exactly the same number of records with or without the group. Essentially, like I say, it's printing a sales invoice, and just using the group to organize the items on the invoice into...
  5. barc0001

    Fields disappearing from report after group is added!

    The additional fields that disappear are from the same table, not a child table. The comments fields are probably still in the report, but as they are in a subsection that is suppressed if blank, they are effectively missing. I tried moving the comments fields into the first section as well...
  6. barc0001

    Fields disappearing from report after group is added!

    Hello all; I am working with Crystal 8.5 and MAS90. I have a report that essentially prints the sales orders out, listing the items, the number ordered, price, total, etc. in the Details section. When I added a group to sort by generalized product line, two of the fields, the comments1 and 2...
  7. barc0001

    Group speed problem

    I'm having a problem with Crystal 8.5 that ships with MAS90 (a business swiss-army-knife, does sales orders, inventory, accounts r/p, etc). If I take one of the default reports that comes with the package and add a second group to sort the report by, the report generation goes from being...

Part and Inventory Search

Back
Top