Error 3070 when running report

[jlk]

Hi, I have a report that prints the last 12 months worth of data. I have options within my forum to select the parameters of this report. The report covers 200 staff. And one of the parameters i have is that you can select a team from these staff. (approx 15 staff per team).


However the problem i'm having is that not every team has data each month.

I have a button on my form to export the report to PDF once the team has been selected. I'm receving Error 3070 when there is no data for a month.

My button is running off code.

DoCmd.OutputTo acOutputReport, "rptFINALCSOOutlierTrendV3", acFormatPDF, , True, , , acExportQualityScreen

The report runs perfectly fine when all staff are selected. The error is only occuring when there is no data for a month within the team selection.

Can anyone offer any solutions on what I can add to either the code or the query that it runs off to fet around this issue?

Your help is much appreciated.

[June7]

Google: Access report no record

Review http://office.microsoft.com/en-us/ac...010158277.aspx

[jlk]

Google: Access report no record

Review http://office.microsoft.com/en-us/ac...010158277.aspx

Thanks June7, however this does not answer my question. It only shows how to cancel the print when there is no data. i have data for 11 out of the 12 months. My report needs to have the last 12 months dates as headings, as it would be a great hassle to remove the record source when there is no data for a specific month. As this report is run many times for differnet parameters.

An example of my report is: Every month for the last 12 months has data except for December. the 3070 error is stating no data for December. My report runs off a crosstab query. How can I get the text box in the report that the record source is December to remain blank due to no data?

Thanks

[June7]

Stabilizing a crosstab to run perpetually in report is tricky.

Google: Access report stabilize crosstab

Review:
https://www.accessforums.net/reports...ery-26806.html
http://www.blueclaw-db.com/report_dy...stab_field.htm
http://allenbrowne.com/ser-67.html
http://forums.aspfree.com/microsoft-...ry-322123.html