|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 26th, 2005, 06:29 PM
|
|||
|
|||
Using parameter queries to create reports
I am using parameter queries to generate a data set which then feeds a
report. When I copy a report and then point it to a new record source (another parameter query) the report seems to carry over properties from the original record source. When I run the report I get prompts to enter data that is not applicable to the new parameter query. If I run the query alone I don't get the prompt so I am sure that somehow the report is maintaining a relationship. All the report references to the unneeded field are gone. Why does it keep doing this? 
|
|
#2
August 26th, 2005, 06:37 PM
|
|||
|
|||
|
The field name is usually hiding in the sorting and grouping levels.
-- Duane Hookom MS Access MVP "GregIU" wrote in message ... I am using parameter queries to generate a data set which then feeds a report. When I copy a report and then point it to a new record source (another parameter query) the report seems to carry over properties from the original record source. When I run the report I get prompts to enter data that is not applicable to the new parameter query. If I run the query alone I don't get the prompt so I am sure that somehow the report is maintaining a relationship. All the report references to the unneeded field are gone. Why does it keep doing this?
|
|
#3
August 26th, 2005, 07:52 PM
|
|||
|
|||
|
You were absolutely right. Thank you.
Greg "Duane Hookom" wrote: The field name is usually hiding in the sorting and grouping levels. -- Duane Hookom MS Access MVP "GregIU" wrote in message ... I am using parameter queries to generate a data set which then feeds a report. When I copy a report and then point it to a new record source (another parameter query) the report seems to carry over properties from the original record source. When I run the report I get prompts to enter data that is not applicable to the new parameter query. If I run the query alone I don't get the prompt so I am sure that somehow the report is maintaining a relationship. All the report references to the unneeded field are gone. Why does it keep doing this?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Reports not connecting to ANY NEW queries | MO | General Discussion | 2 | June 30th, 2005 01:06 AM |
| Looping to generate reports based on query parameter | jsccorps | Running & Setting Up Queries | 3 | May 24th, 2005 06:25 PM |
| Find redundant queries / tables / reports easily? | Richard Horne | General Discussion | 2 | April 19th, 2005 09:16 PM |
| Report queries belong in Reports | Jonathan Scott via AccessMonster.com | Setting Up & Running Reports | 2 | April 8th, 2005 01:37 AM |
| Create Reports from Queries | AL | General Discussion | 1 | December 18th, 2004 12:15 AM |
Linear Mode
