Report Header Information - Alberta Rose

  • Thread starter Thread starter Alberta Rose
  • Start date Start date
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?
 
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.
Click to expand...


The parameters **must** be spelled **exactly** the same
everywhere it is used.
 
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.
Click to expand...


The parameters **must** be spelled **exactly** the same
everywhere it is used.
 
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.
Click to expand...


The parameters **must** be spelled **exactly** the same
everywhere it is used.
Click to expand...
 
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.
Click to expand...


The parameters **must** be spelled **exactly** the same
everywhere it is used.
Click to expand...
 
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.
Click to expand...


The parameters **must** be spelled **exactly** the same
everywhere it is used.
Click to expand...
Click to expand...
 
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.
Click to expand...


The parameters **must** be spelled **exactly** the same
everywhere it is used.
Click to expand...
Click to expand...
 
Back
Top