Darn. I was looking at the "On Entry" expression builder under the "Edit Bands" option thinking maybe the Summary Band had some kind of "visible" property that could be set to false under certain conditions.
This is similar to another limitation in the report writer where it seems near impossible to program whether or not you want to print a group on a new page, or new line, etc., etc... The solution to that was create a separate report with the "New Page" property set up under the data grouping tab, and have the user select the report through the UI, what a pain. James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com office: 717-637-8931 cell: 717-887-2565 fax: 717-637-6766 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Paul Newton Sent: Friday, January 20, 2012 11:32 AM To: [email protected] Subject: RE: Print when condition with remove line James The answer is: , or do I have to enter the same "Print when" condition in each field in the summary band? .... Yes Paul Newton -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of James E Harvey Sent: 20 January 2012 16:18 To: [email protected] Subject: Print when condition with remove line I have a number of fields in the summary band of a report that each holds a variable which is a grand total of a value of the field in the cursor created by a select statement. If I'm choosing to group the report, and sub totaling the groups, the summary band makes sense, as it gives a grand total. If I select only one group for the report I don't need the summary band as the totals for the group are the same as the summary. I enter a "Print When" condition in one of the field's "Print only when expression is true" box in the summary band that compares the sub total value with the grand total value and if not equal it prints the grand total in the summary band. If the values agree then this field does not print. This part works fine. Now, I check the "Remove line if blank" condition in this field, and the field does not print, but all the other fields in the summary band continue to print. I'm not sure why I thought the "Remove line if blank" would work by not printing the summary band, but it was worth a try. Is there a method to cause the summary band not to print when the sub total of a group equals the grand total, or do I have to enter the same "Print when" condition in each field in the summary band? Please excuse me if this has been asked before, I've tried to research this, but can't seem to find an answer. James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com office: 717-637-8931 cell: 717-887-2565 fax: 717-637-6766 [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
