• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 479
  • Last Modified:

Conditional printing of a sub-report?

I have a report that is designed to exactly fit one page.  
I have a sub-report (containing photos) that is at the bottom of the page.  It prints on page 2 because there is no room on page one.

The problem is, if the record has no photos (no data for sub-report), the print report still prints a blank page.

Is there any way of saying "if the sub report has no data, change the margins, or just print the first page of the main report"?
thanks.
0
SheaJeff
Asked:
SheaJeff
  • 2
1 Solution
 
Rey Obrero (Capricorn1)Commented:
you can hide the subreport with this

me.subreportName.visible=me.subreportname.report.hasdata
0
 
SheaJeffAuthor Commented:
There's still an issue of making it visible or not; I have the sub-report below the 8.5" page margin, so it shows up on page 2.

Maybe I'm looking for something to say "if no data, then only show the first page of the report(s), but for any WITH sub-report data, show both pages.
0
 
SheaJeffAuthor Commented:
I ended up making the subreport 1 grid-dog thick (just a line) at the bottom of page one, then if there was any data, it would print (starting on page 2), if not, the report would only show one page.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now