Avatar of Aubie91
Aubie91
Flag for United States of America asked on

How to print blank report

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
Microsoft Access

Avatar of undefined
Last Comment
Aubie91

8/22/2022 - Mon
Jeffrey Coachman

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
Aubie91

ASKER
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 Coachman

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...
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
ASKER CERTIFIED SOLUTION
Scott McDaniel (EE MVE )

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Aubie91

ASKER
Thanks you for your help, I will go ahead an add Blank record in the Form so the report can be printed.
Russell Fox

Or create a new dataset of "select ' ' as myBlank; " and use that as the datasource, putting that one field in any field.
Scott McDaniel (EE MVE )

Not sure why you awarded this a B grade - the answer was fairly complete, and you did not ask for additional help.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Aubie91

ASKER
It was an A I just hit the wrong button

Thanks for your guidance