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 strongm 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. Juice300x3

    Suppress if duplicated

    I am working in CRv9 in a manufacturing setting. I have a report that tells me part#'s that we were out of that kept a unit from progressing through manufacturing. Each product that we start machining gets a "tag #". Somtimes, these tag#'s may go on and off of our "set a side" list and then...
  2. Juice300x3

    Date

    Try this formula WhileReadingRecords; DateVar Array Holidays; DateVar Target:={@StartDate}; // Put your field name in here NumberVar Add:= 2; // put the number of days here to add (a positive number) NumberVar Added := 0; WHILE Added < Add Do (target := target +1; if dayofweek (target) in...
  3. Juice300x3

    How do I get a new page for each new group?

    I am trying to get each of my groups to appear on a new page. I am working in v9 and have suppressed my details. In a class I took recently, I thought there was a formula that had to be put in. Can anyone help?
  4. Juice300x3

    Suppress if Duplicated w/second column

    Thanks for your patience. This is my first time utilizing this help. I tried checking out the other posts, but am still unsure what info to provide since I don't speak programmer. Here is what the report looks like with no suppression. Detail columns labeled just like in Crystal. I think I...
  5. Juice300x3

    Suppress if Duplicated w/second column

    Here is what it looks like right now. The main part# is the 64004, and it repeats in all the blanks you see here since all of the other parts are subcomponents that have to be assembled to make a 64004. Since there is still a qty field when I suppress duplicates, the suppress blank section is...
  6. Juice300x3

    Suppress if Duplicated w/second column

    Sorry, I didn't go far enough in my explanation. I format the part# field to suppress if duplicated, and go to section expert to suppress if blank section. The problem is that I still have a quantity in that section, and cannot figure out a way to suppress it based on the part# being...
  7. Juice300x3

    Suppress if Duplicated w/second column

    I have a report that shows my part#'s in a bill of material and the subcomponents when a main part# is made up of several smaller parts. I linked with a left outer join from my main BOM to the sub table. Some of my parts in the main BOM have several components that have to be assembled to make...
  8. Juice300x3

    How to suppress details section if no data.

    If you are just trying to suppress the info in the subreport when there is no matching record in the main report, link it by the common field.
  9. Juice300x3

    Exporting with subreports

    Has anyone ever figured out a way to export to excel with a subreport, and not get the carriage return?

Part and Inventory Search

Back
Top