RicelandIT
Last Activity: Nov 8 '12, 11:35 PM
Joined: Feb 10 '12
Location:
-
In Access 2003, it DOES, indeed, appear to be working properly. However, as you can see from my earlier image, the empty footers show up for every employee in Access 2007. Could there be some kind of database setting or reports setting that is causing the difference? At this point, I just can't worry about it any more. I don't have any more time to spend on it, but I really appreciate all your replies. Many individuals were very helpful. -
See attachment
The circled areas are the subreports. Guillory has no data, so I want his subreport to be hidden.
[IMGNOTHUMB]http://bytes.com/attachments/attachment/6132d1330106533/empty-footer.jpg[/IMGNOTHUMB]...Leave a comment:
-
You are correct, there is no data for Guillory and Rudd, but the "Additions or (Subtractions)" still shows up for them and for every single day for every employee, regardless of whether or not there is any data below it. It's this "Additions or (Subtractions)" that I'm trying to hide when there is no data.Leave a comment:
-
Cannot Hide Empty Subreport
Sorry I have been out of town for 4 days, but have finally returned.
Well, you were correct. The reports WERE there, but I could not see them due to the view. And, the "Compact and Repair" was also where you indicated.
The attached database has been saved in 2003 format. I am attempting to run the report "Employee Totals By Day". Notice that employee...Leave a comment:
-
Please accept my apology for having a negative attitude and failing to properly post the code. Trying to resolve this has taken a real toll on me. I will be very careful to comply going forward.
I am attempting to upload the database, per NeoPa's instructions (which are very clear). When I save the database as Access 2003 format, I notice that when I open the 2003 version, the report (and subreport) are missing. I guess that might...Leave a comment:
-
I am not familiar with Crystal Reports. I'm already having to learn Access from scratch, and have invested about 50 hours into this application. (I was formerly a Visual Studio.NET developer, but no longer work at that company, and no longer have access to that development platform.)
Is it, or is it not possible to hide an empty subreport?Leave a comment:
-
I would prefer not to use a complex workaround. Such a solution will likely create more issues I cannot resolve in the future. I saw in another post that it is best to change the SQL so that the empty subreport is not retrieved, but I don't understand where that SQL is physically located so that I could try a different type of join between my report and subreport. (This might not even be making sense.)
Maybe there is something...Leave a comment:
-
Here's the code:
It doesn't matter if we use "!Me" or "Me.": the empty subreports continue to show up.Code:Private Sub GroupFooter3_Format(Cancel As Integer, FormatCount As Integer) If !Me.TotalEmpItemsDaysubreport2.Report.HasData Then Cancel = True End If End SubLeave a comment:
-
As I said before, I set its visibility to FALSE because it didn't appear that the if-else-endif block was functioning properly. The entire block of code is the following:
If the "on format" event is too late, then what difference...Code:If Me.TotalEmpItemsDaysubreport2.Report.HasData Then Me.TotalEmpItemsDaysubreport2.Visible = True Else Me.TotalEmpItemsDaysubreport2.Visible = False End IfLeave a comment:
-
I'm using Access 2007. There is nothing else in the footer. There are 2 footers: one for the day of the week and another for the employee. (Report lists data by employee, then for each employee data appears for each day of the week.) The employee footer always has data, but the day of the week footer may not, and the subreport contained in the day of the week footer is the one I'm trying to hide. I've tried to set its visibility to FALSE regardless...Leave a comment:
-
Cannot hide empty subreport
I've reviewed the posts on www.bytes.com.
My problem is the same as that reported by others:
a report with an empty subreport cannot suppress the display of the empty subreport. I've set the "can shrink" and "can grow" properties to "yes" on both the footer and the subreport's control object. I've also minimized the physical size of the subreport in the footer. These all seem to make no difference. So,...
No activity results to display
Leave a comment: