Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

no data in reports

Status
Not open for further replies.
peljo

peljo

Technical User
Mar 3, 2006
91
BG
I am opening a report listing the sales for a given client.When however there are no sales for a given client, the report is opened indeed but it is written error and the picture is rather ugly. Could i set up some filter on opening of the report, and if there are no data,just not open the report ? I will have a cleaner picture then
 
Sort by date Sort by votes
You can use the NoData event of the report (you will need to trap the cancel error) or you can use DlookUp to check for data before opening the report.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Teri Bridges
  • Locked
  • Question
Reports Combobox-List box
Replies
1
Views
211
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Print multiple copies of report data 1
Replies
5
Views
261
dhookom
dhookom
JimStrand
  • Locked
  • Question
Expression Limit on Sum IIf In Method ? Used in Report Calculation
Replies
1
Views
255
dhookom
dhookom
SamuelR
  • Locked
  • Question
Dlookup in a report
Replies
13
Views
299
dhookom
dhookom
breezett93
  • Locked
  • Question
What should be multiple reports is becoming one report with multiple pages 1
Replies
13
Views
225
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top