How to print blank report

Aubie91
Aubie91 used Ask the Experts™
on
I have created a report with multiple subreports.  The user wants to print a blank report to fill in the information with the client, in report view I can see everything but print preview is blank.  The subreports are in the Detail section
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
I'm confused...
You say you want a blank report, ...yet you say that Print Preview is already blank?
So what exactly do you have now, and what exactly do you need help with accomplishing?

With things like this, it is sometimes quicker to simply post a sample database and a clear graphical example of the exact output you are seeking
(especially with designs involving multiple sub reports)

You can certainly make the source for the report a "Blank" record,
...or even just create a "Graphical" report (one with no records behind it)

...bit we need to know a bit more about your current system
This is where the sample db will save us a lot of time.

JeffCoachman
Aubie91Manager of Business Systems

Author

Commented:
The database is blank at the moment the user will be meeting with the client and would like to have a blank report to review with the client and fill in the information.  I've attached what I get in Print Preview for the blank database and then what I'd like to print I created a dummy number.  I'd like to print without having to create the dummy number

Thanks for your time and help
Sample_SubrptIncluded.pdf
Sample_RoomData.pdf
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
Again,...a sample of the DB would be a lot easier to work with...
It is still not clear how your report is designed...

Again, there are a few different way you could go about this...
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Most Valuable Expert 2012
Top Expert 2014
Commented:
I've had this request before, and I've generally just included a table that contains "blank" data, and use that when I need to create the blank report. Reports are bound to an Access data object (query or table), so you must have some data in a table somewhere to "print" a report.
Aubie91Manager of Business Systems

Author

Commented:
Thanks you for your help, I will go ahead an add Blank record in the Form so the report can be printed.
Russell FoxDatabase Developer
Top Expert 2014

Commented:
Or create a new dataset of "select ' ' as myBlank; " and use that as the datasource, putting that one field in any field.
Most Valuable Expert 2012
Top Expert 2014

Commented:
Not sure why you awarded this a B grade - the answer was fairly complete, and you did not ask for additional help.
Aubie91Manager of Business Systems

Author

Commented:
It was an A I just hit the wrong button

Thanks for your guidance

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial