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
|
|||
|
|||
No Data
Hi:
I have created a report based on a query. When I run the report, it's blank. If I run the query behind the report the data is there. There is no criteria in the query. I am using Access 2007. Any ideas? |
#2
|
|||
|
|||
No Data
Open the report in design view, and set the report's Filter On Load property
to No. This is a new property in A2007. If it's set to Yes, then whatever filter was previously saved gets applied again when you open the report, which may result in no matches. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Theresa" wrote in message news I have created a report based on a query. When I run the report, it's blank. If I run the query behind the report the data is there. There is no criteria in the query. I am using Access 2007. Any ideas? |
#3
|
|||
|
|||
No Data
Hi Allen:
The filter on load is already set to no. the funny thing is I have a sum in the footer which is calculating. Also, I created another report on this same query and it works fine. I was having so many issues trying to post on the Microsoft forum site.....Is anyone else have trouble posting to these forums? I keep getting a service is temporarily unavailable error. Allen Browne wrote: Open the report in design view, and set the report's Filter On Load property to No. This is a new property in A2007. If it's set to Yes, then whatever filter was previously saved gets applied again when you open the report, which may result in no matches. I have created a report based on a query. When I run the report, it's blank. If I run the query behind the report the data is there. There is no criteria in the query. I am using Access 2007. Any ideas? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200908/1 |
#4
|
|||
|
|||
No Data
If the sum in the footer is calculating, perhaps you have set the Visible
property of the Detail section to No. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "TheresaS via AccessMonster.com" u54250@uwe wrote in message news:9b2d121710c5f@uwe... Hi Allen: The filter on load is already set to no. the funny thing is I have a sum in the footer which is calculating. Also, I created another report on this same query and it works fine. I was having so many issues trying to post on the Microsoft forum site.....Is anyone else have trouble posting to these forums? I keep getting a service is temporarily unavailable error. Allen Browne wrote: Open the report in design view, and set the report's Filter On Load property to No. This is a new property in A2007. If it's set to Yes, then whatever filter was previously saved gets applied again when you open the report, which may result in no matches. I have created a report based on a query. When I run the report, it's blank. If I run the query behind the report the data is there. There is no criteria in the query. I am using Access 2007. Any ideas? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200908/1 |
Thread Tools | |
Display Modes | |
|
|