Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Report Header
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Report Header
This is an Excel Programming discussion group. Nevertheless, a lot of us use
Access, and thus, may be able to offer some help. Check this out; found it from an old Queries post over in the Access area... #1) if you've declared the parameters as [Enter Start Date ] and then referred to them as [Enter Start Date] (note the space at the end of the first) then you will be prompted for both and only the referred value will actually be used. #2) You've applied a filter or sort to the query in datasheet view and saved the change. This can sometimes cause the query to run twice. Once for the acutual SQL and a second time to apply the filter or sort If this is the case open the query in datasheet view and Select Remove Filter/Sort and save the query. In summary, you probably need to switch to SQL view, copy the SQL statement, and paste it into a new query. Run the new query. IF you no longer get the prompts and get the correct results, save the new version with the name of the old version. Good luck, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Alberta Rose" wrote: 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Report Header
Thanks Ryan. It was instance #2 that was causing the grief. My appologies
for posting this on the wrong site, I've been doing so much work in Excel lately that I wasn't paying enough attention I guess. Thanks again....Laurie:) "ryguy7272" wrote: This is an Excel Programming discussion group. Nevertheless, a lot of us use Access, and thus, may be able to offer some help. Check this out; found it from an old Queries post over in the Access area... #1) if you've declared the parameters as [Enter Start Date ] and then referred to them as [Enter Start Date] (note the space at the end of the first) then you will be prompted for both and only the referred value will actually be used. #2) You've applied a filter or sort to the query in datasheet view and saved the change. This can sometimes cause the query to run twice. Once for the acutual SQL and a second time to apply the filter or sort If this is the case open the query in datasheet view and Select Remove Filter/Sort and save the query. In summary, you probably need to switch to SQL view, copy the SQL statement, and paste it into a new query. Run the new query. IF you no longer get the prompts and get the correct results, save the new version with the name of the old version. Good luck, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Alberta Rose" wrote: 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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Report Header
Sorry about that, I had tried #2 and was only prompted once for the dates.
However, when I run the report, it doesn't filter out any dates and gives me everything. I removed the filter from the query, as well I have copied the SQL into a new query, with the same result. Any ideas? "ryguy7272" wrote: This is an Excel Programming discussion group. Nevertheless, a lot of us use Access, and thus, may be able to offer some help. Check this out; found it from an old Queries post over in the Access area... #1) if you've declared the parameters as [Enter Start Date ] and then referred to them as [Enter Start Date] (note the space at the end of the first) then you will be prompted for both and only the referred value will actually be used. #2) You've applied a filter or sort to the query in datasheet view and saved the change. This can sometimes cause the query to run twice. Once for the acutual SQL and a second time to apply the filter or sort If this is the case open the query in datasheet view and Select Remove Filter/Sort and save the query. In summary, you probably need to switch to SQL view, copy the SQL statement, and paste it into a new query. Run the new query. IF you no longer get the prompts and get the correct results, save the new version with the name of the old version. Good luck, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Alberta Rose" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically display filter range in report header in Excel | Excel Worksheet Functions | |||
Add Header/Footer to excel report from ASP.. | Excel Discussion (Misc queries) | |||
Add Header/Footer to excel report from ASP.. | Excel Programming | |||
Automate Excel report to place certain data into existing report? | Excel Worksheet Functions | |||
Header in Report Manager Report | Excel Discussion (Misc queries) |