473,396 Members | 1,886 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

How to hide subreport no data

106 100+
Hi,

When I print my report with subreport having no data, there is a big gap between the lines. How can I supress/hide subreport when it has no data.
Sep 10 '09 #1
3 4034
ajalwaysus
266 Expert 100+
Try and set the can grow/can shrink to "Yes" then downsize your sub-report a very small slither. When you set the "Can Grow = Yes", the sub-report will grow accordingly to the number of records in it.

-AJ
Sep 10 '09 #2
NeoPa
32,556 Expert Mod 16PB
Reports have an On No Data event.

If you know the report will only ever run as a subreport then you can handle the event with code that hides the SubReport control on the main report.
Sep 10 '09 #3
NeoPa
32,556 Expert Mod 16PB
RicelandIT:
I posted a reply to this yesterday, but I cannot find it today. So, I hope it's okay to ask it again:
No. Not really. Your posts have been deleted for the reasons explained in the emails that you have received. It is not ok to ask your question in an existing thread.

Contributing answers to threads is fine, but if you have a question it needs to be asked in its own, separate, thread. A link to this thread is fine, but asking your question here is not.
Feb 12 '12 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Eddie Smit | last post by:
Hi all, I created a main report with a subreport. I want to display this subreport 8 times but with different data. (I do that with subreport.RecordSource = "sqlstring") HOW do I set this...
8
by: dixie | last post by:
I have a report with a subreport. The source object for this subreport varies according to the value of a field in a table. I am trying to programmatically set the object source for the subreport...
7
by: Jacob Barnett | last post by:
Access 2000 main report does not display subreport data in preview and may or may not print... sometimes. Usually, the entire report is fine. The behavior does not seem to depend on particular...
1
by: Melissa | last post by:
A form in my database has multiple subforms. If any subform has no data, the borders of the subform still display on screen and also are printed if I print the main form. Reports are different. If...
3
by: lorirobn | last post by:
Hello, I have a report which uses a subreport. When I run the report, I get "Enter Parameter Value" error message for "tblGuestRoom". I click ok and the report seems to work fine. I...
2
by: bobh | last post by:
Hi All, I have a report which has several sub-reports on it, Each sub-report has its own record source and child/parent link. Sometimes a sub-report may not have data for an entered policy nbr and...
11
by: DanielM | last post by:
How To hide a subreport? I found how to know if the subreport has no data (Me.subreportname.Report.HasData) what I didn't find is how to make the sub report unvisibile if it has no data. I tried:...
3
by: Simon | last post by:
Dear reader, The syntax for the VBA code to change the RecordSource of a Master Report is: Me.RecordSource = "TableOrQueryName"
3
by: Simon van Beek | last post by:
Dear reader, How to change the RecordSource for a subReport. For forms the syntaxes is:
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.