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...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.