Report prints no data (97)

Topic

New Reply

Report prints no data
In my report

Reply | Quote

Replies

When you run your query as a select query, does this number

Reply | Quote

If your report doesn’t show any data, then it probably means that there are no records in its recordset that match the filter you have applied. Is that WHERE clause you showed in the query or is it a filter applied to the report? I don’t quite understand what you mean by calling a macro that will filter the data, though. All you need to is use minimal code to apply a filter without a macro. Alternatively, you can use a parameter query to limit the recordset behind the report without involving a macro or filter at all.

Reply | Quote

A couple of points:

1 – Is the filter value constant? i.e. do you ONLY ever want to filter on Retailer 50138?

If yes, then change the recourdsource of the report to a query, where the value of 50138 is entered into the conditions row for RetailerNumber

2 – If the filter is not consistant (i.e. Different Retailers are reported depending upon where the report was called from), then again,m set the record source to a query, and set the Condition row of the RetailerNumber to “=[Enter Required Retailer]” (do not include the quotes)

3 – If the report is called from a form, via the means of a Command Button, then go into the properties window of the command button, and then onto the events tab.

Select on_Click, where it should read ‘[Event Procedure]’ – select this row, and then click on the elipses to the far right ( the three dots)

Assuming the button was placed with the wizards switched on, it should read:

Dim stDocName As String

stDocName = “Digest Master: Budget Analysis” ‘- this will be the name of your report
DoCmd.OpenReport stDocName, acPreview[/b]

Change the secon line (DoCmd.OpenReport…) to read:

DoCmd.OpenReport stDocName, acPreview,,”[RetailerNumber]=50138″[/i]

I hope this helps

Reply | Quote

Thanks all for your suggestion.
What I went with eventually was to get rid of the macro.
In the reports filter property I just stuck one long string of values to filter on (50138 was not the only dealer)
I couldn

Reply | Quote

You can add more then 9 lines in the query grid.
Use the menu Insert, Rows.

Reply | Quote

(No Text)

Reply | Quote