If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Invisible Group Footer
Hello there
I have report that shows data on companies Each company has sometimes sub company The report is summerize data of company and sub company If i have only one sub company the group footer of the subcompany should not be visible. How can i do that? |
#2
|
|||
|
|||
Invisible Group Footer
Roy Goldhammer wrote:
I have report that shows data on companies Each company has sometimes sub company The report is summerize data of company and sub company If i have only one sub company the group footer of the subcompany should not be visible. You didn't provide enough information for me to be specific, but I'll take a guess that the subcompany data is in the report's detail section. If so then add a hidden text box named txtDtlCnt to the footer section and set its control source expression to =Count(*) With that in place add a line of code to the group footer section Format event: Cancel = (Me.txtDtlCnt = 1) -- Marsh MVP [MS Access] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Not print group header when group footer prints | Kate | Setting Up & Running Reports | 1 | July 7th, 2005 05:24 AM |
Keep Together last record detail with group footer | Craig | Setting Up & Running Reports | 1 | May 18th, 2005 07:33 AM |
Ambiguous outer joins | Renwick | New Users | 1 | February 22nd, 2005 03:08 PM |
Syntax needed to get needed reports | Frank Lueder | New Users | 15 | January 6th, 2005 09:39 AM |
Using DCount in Group Footer filtering records based on value of the group | Beth | Setting Up & Running Reports | 1 | September 10th, 2004 04:17 PM |