Supress Repeated Value on Report

[jmeckley]

I have a report with the following format:
Group 1 - Subassembly
Group 2 - Finished Good
Group 3 - Order Number
Detail - specific to order

in the details section there are values that repeat. I have suppressed the repeated values and set the also print to true for Order number in the Print When dialog box.

However the values also print when the the details overflow to a second page. The In First Whole Band of New Page/Column and When Details Overflow to New Page/Column are marked false. Is there are workaround to this?

Thank you for your assistance.

Jason Meckley
Programmer
Specialty Bakers, Inc.

 

[JRB-Bldr]

Assuming that you have copied your data into a 'scratch' (temporary) table to use specifically to support report printing, you can always add additional fields which you can then pre-process before issuing the REPORT FORM command.

These additional fields can then be used to specifically control your printing.

This approach may be a little more complex than just allowing the REPORT FORM to do it for you, but it will provide you with finite control of how things get printed.

Good Luck,


JRB-Bldr
VisionQuest Consulting
Business Analyst & CIO Consulting Services
CIOServices@yahoo.com

 

[jmeckley]

the data is queried into a cursor that is then used by the report. I am a novice to FoxPro 2.5.

My data is structured in the follow way

[tt]
+--SubAssembly--+--Finished Good--+--Order #--+--Detail A--+--Detail B--+
| 10000 | 1234 | 99998 | 50 | detail 1 |
+---------------+-----------------+-----------+------------+------------+
| 10000 | 1234 | 99998 | 50 | value 2 |
+---------------+-----------------+-----------+------------+------------+
| 10000 | 1234 | 99998 | 50 | value 3 |
+---------------+-----------------+-----------+------------+------------+
| 10000 | 1234 | 99999 | 75 | value 1 |
+---------------+-----------------+-----------+------------+------------+
| 10000 | 1234 | 99999 | 75 | value 2 |
+---------------+-----------------+-----------+------------+------------+
| 10000 | 1235 | 88888 | 100 | value 1 |
+---------------+-----------------+-----------+------------+------------+
| 10000 | 1235 | 88888 | 100 | value 2 |
+---------------+-----------------+-----------+------------+------------+
| 20000 | 2235 | 77777 | 100 | value 1 |
+---------------+-----------------+-----------+------------+------------+
[/tt]

With this structure I would need each value of Detail B to be printed. I would only need 1 instance of Detail A printed for each Order #

This works fine until the details sections overflows to a second page.

Jason Meckley
Programmer
Specialty Bakers, Inc.