I would create a conditional formula that returns True if a record has that treatment code. Then put this conditional formula in the group header and Details section for the Suppress property. That will suppress all records that relate to the one with this code.

To keep track of how many records this is, I would also create a Global variable that increments by one each time this happens and only include this in the conditional formula for the Details section. At the end of the report this variable should total the number of records that were skipped.

I cover how to write formulas and give numerous code samples for them in Chapters 5-7 of my Encyclopedia book. You can find out more about my books at Amazon.com or reading the Crystal Reports eBooks online.

Thanks for getting the book! I'm glad you like it.

Well, what you are wanting to do is change a record based on a DIFFERENT record's value. That becomes much more difficult. In fact, I'm not sure how I would handle it. I think I would try to use a subreport to prior to printing out out the group header and in this subreport use a Shared variable to track if the particular group has a treatment code. If so, then all the sections in the main report will use that shared variable in a conditional formula to suppress the sections. Of course, you need to suppress all the subreport sections as well b/c you don't want to see any of that data, just use it for the formula.

It's a bit tricky, but I think this approach will work if you code your formulas carefully and debug them. See Tutorial 9-6 in the book for how to use subreports for hidden calculations and the following section for troubleshooting subreport shared variables.

You can find out more about my books at Amazon.com or reading the Crystal Reports eBooks online.


Edited by BrianBischof - 03 May 2008 at 2:15am