Report Header Information - Alberta Rose

A

Alberta Rose

I would like to include the parameters of my search in the report header. I
can get it to work when there is only a Page Header, Detail and Page Footer.
But when I add another detail such as a summary level, example: ="Dates
Between " & [REQUIRED FIELD: Select First Date] & "and" & [REQUIRED FIELD:
Select Last Date] that I have on my Report Header doesn't work. The message
box comes up twice to enter the date parameters and you have to enter the
dates twice or they won't show up on the Report Header.

Any suggestions?
 
M

Marshall Barton

Alberta said:
I would like to include the parameters of my search in the report header. I
can get it to work when there is only a Page Header, Detail and Page Footer.
But when I add another detail such as a summary level, example: ="Dates
Between " & [REQUIRED FIELD: Select First Date] & "and" & [REQUIRED FIELD:
Select Last Date] that I have on my Report Header doesn't work. The message
box comes up twice to enter the date parameters and you have to enter the
dates twice or they won't show up on the Report Header.


The parameters **must** be spelled **exactly** the same
everywhere it is used.
 
M

Marshall Barton

Alberta said:
I would like to include the parameters of my search in the report header. I
can get it to work when there is only a Page Header, Detail and Page Footer.
But when I add another detail such as a summary level, example: ="Dates
Between " & [REQUIRED FIELD: Select First Date] & "and" & [REQUIRED FIELD:
Select Last Date] that I have on my Report Header doesn't work. The message
box comes up twice to enter the date parameters and you have to enter the
dates twice or they won't show up on the Report Header.


The parameters **must** be spelled **exactly** the same
everywhere it is used.
 
A

Alberta Rose

Yes they are spelled exactly. I had run into that issue awhile ago as well.
It seems like when I have the parameter in the query and then add it to the
report header, that's when I get a double pop up for the information.

Laurie

Marshall Barton said:
Alberta said:
I would like to include the parameters of my search in the report header. I
can get it to work when there is only a Page Header, Detail and Page Footer.
But when I add another detail such as a summary level, example: ="Dates
Between " & [REQUIRED FIELD: Select First Date] & "and" & [REQUIRED FIELD:
Select Last Date] that I have on my Report Header doesn't work. The message
box comes up twice to enter the date parameters and you have to enter the
dates twice or they won't show up on the Report Header.


The parameters **must** be spelled **exactly** the same
everywhere it is used.
 
A

Alberta Rose

Yes they are spelled exactly. I had run into that issue awhile ago as well.
It seems like when I have the parameter in the query and then add it to the
report header, that's when I get a double pop up for the information.

Laurie

Marshall Barton said:
Alberta said:
I would like to include the parameters of my search in the report header. I
can get it to work when there is only a Page Header, Detail and Page Footer.
But when I add another detail such as a summary level, example: ="Dates
Between " & [REQUIRED FIELD: Select First Date] & "and" & [REQUIRED FIELD:
Select Last Date] that I have on my Report Header doesn't work. The message
box comes up twice to enter the date parameters and you have to enter the
dates twice or they won't show up on the Report Header.


The parameters **must** be spelled **exactly** the same
everywhere it is used.
 
M

Marshall Barton

If I did that kind of thing I would use Copy/Paste to make
sure they are identical.

If you have already done that, the only other thing to try
is to add hidden text boxes that are bound to each
parameter.

I avoid using parameter prompts by creating a form with text
boxes for users to enter the parameter values along with a
button to open the report. The parameters in the query and
report then look like:
Forms![form name].[text box name]

Another benefit of using a form to manage the report is that
you can remove the parameterized criteria from the query and
use the OpenReport method's WhereCondition argument instead.
E.g.

stWhere = "[date field] Between " & Me.[first text box] _
& " And " & Me.[last text box]
DoCmd.OpenReport "report name", acView,,,, , stWhere
--
Marsh
MVP [MS Access]


Alberta said:
Yes they are spelled exactly. I had run into that issue awhile ago as well.
It seems like when I have the parameter in the query and then add it to the
report header, that's when I get a double pop up for the information.

Marshall Barton said:
Alberta said:
I would like to include the parameters of my search in the report header. I
can get it to work when there is only a Page Header, Detail and Page Footer.
But when I add another detail such as a summary level, example: ="Dates
Between " & [REQUIRED FIELD: Select First Date] & "and" & [REQUIRED FIELD:
Select Last Date] that I have on my Report Header doesn't work. The message
box comes up twice to enter the date parameters and you have to enter the
dates twice or they won't show up on the Report Header.


The parameters **must** be spelled **exactly** the same
everywhere it is used.
 
M

Marshall Barton

If I did that kind of thing I would use Copy/Paste to make
sure they are identical.

If you have already done that, the only other thing to try
is to add hidden text boxes that are bound to each
parameter.

I avoid using parameter prompts by creating a form with text
boxes for users to enter the parameter values along with a
button to open the report. The parameters in the query and
report then look like:
Forms![form name].[text box name]

Another benefit of using a form to manage the report is that
you can remove the parameterized criteria from the query and
use the OpenReport method's WhereCondition argument instead.
E.g.

stWhere = "[date field] Between " & Me.[first text box] _
& " And " & Me.[last text box]
DoCmd.OpenReport "report name", acView,,,, , stWhere
--
Marsh
MVP [MS Access]


Alberta said:
Yes they are spelled exactly. I had run into that issue awhile ago as well.
It seems like when I have the parameter in the query and then add it to the
report header, that's when I get a double pop up for the information.

Marshall Barton said:
Alberta said:
I would like to include the parameters of my search in the report header. I
can get it to work when there is only a Page Header, Detail and Page Footer.
But when I add another detail such as a summary level, example: ="Dates
Between " & [REQUIRED FIELD: Select First Date] & "and" & [REQUIRED FIELD:
Select Last Date] that I have on my Report Header doesn't work. The message
box comes up twice to enter the date parameters and you have to enter the
dates twice or they won't show up on the Report Header.


The parameters **must** be spelled **exactly** the same
everywhere it is used.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top