The problem, it appears, lay with the remove condition function call which corrupted the SQL - without the remove condition everything is fine - of course, I had to delete the prompts in my original reports but at least it works.
Hi Sri
yes, I am automating using VBA (see code snippet below). There are prompts in the report and so I cycle through the data providers looking for conditions that are prompts. If I find one I replace it with a hardcoded condition. Once all of the conditions have been examined I unload...
Hi,
Did you get to the bottom of this?
I'm having the same problem... I managed to fix one of my reports by saving it as another name, deleting the original and then renaming the saved file. This didn't work for the other report which had to be reimplemented.
Only seems to happen when the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.