ACCESS FEED: RE: [MS_AccessPros] Help wit report format

Kamis, 21 November 2013

RE: [MS_AccessPros] Help wit report format

John,

Thanks for the help – it worked like I would like it.

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of John Viescas
Sent: Thursday, November 21, 2013 3:37 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Help wit report format

Dear B-

Are these in subreports? If so, you should be able to shrink each subreport to zero height but set Can Grow to true. Stack the subreports so that there's a minimum of space between each (like .01"). For subreports that contain no data, there will be a minimal amount of "blank" space, but it won't be noticeable.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

SQL Queries for Mere Mortals

http://www.viescas.com/

(Paris, France)

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of bmorris.gm@gmail.com
Sent: Thursday, November 21, 2013 4:35 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Help wit report format

Hello,I have a report that I'm modifying. The original report was created by a person who is no longer with the company. Basic format has several queries which each feed a separate report. Then there is a final report that has all the other reports included. The final report is what is printed each week.

When there is a report that is not to be included in the final report (ie - no data for that week), the report has to be manually deleted from the final report form. If the sub report is set to "not visible", then there is an unwanted gap in the final printout.

What I'm wondering is - is it possible to have a single report that allows sub headers for the matching query where when there is no information in the query the sub header does not print - OR when the sub header is set to "not visible" there is not a gap in the report?

Explained another way:

Currently:

Query 1
Query 2
Query 3
Query 4
Report 1
Report 2
Report 3
Report 4
Final report w/
Report 1
      Report 2
      Report 3
      Report 4

Now if Query 3 returns nothing, then the final report is
Final report w/
Report 1
      Report 2
      - gap -
      Report 4

Best solution would be to have:
Final report w/
     Query 1
     Query 2
     Query 3
     Query 4

Or
Final report w/ (query 3 with no results)
     Query 1
     Query 2
     Query 4

BTW, I'm knowledgeable enough to be dangerous but can be trained :)

Thanks,
B