Hi All,
I have a report that gets emailed to a contact and has been working for a long time. What I would like to do now is to change some of the text fields on the report based on some other data that is setup prior to the report being run. I have put the code to change the data on the "report, on open" event but now the report doesn't end up running completely. When i run it in break mode, I get to the line where the report output is created and then it just ends, no errors or other indications. Got any ideas?
Thanks,
Mark
Change report content
-
- 3StarLounger
- Posts: 253
- Joined: 19 Apr 2010, 09:01
- Location: Indiana, USA
Change report content
Thanks,
Mark
Mark
-
- 4StarLounger
- Posts: 482
- Joined: 24 Jan 2010, 15:02
- Location: Colorado, USA
Re: Change report content
If you don't get any error messages, is it possible that you have some higher level error handling code that is preventing the error message from being displayed. To check that, put in a new line at the beginning that turn off error handling and run it in debug mode. Another possibility is that there isn't any data and the "No Data" condition is causing the report to terminate when that is detected - but that seems like a more remote possibility.
Wendell
You can't see the view if you don't climb the mountain!
You can't see the view if you don't climb the mountain!
-
- Administrator
- Posts: 78631
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Change report content
If Wendell's suggestion doesn't help, please provide more detailed information about the code.
Best wishes,
Hans
Hans