I get the following error when running reports that I created using stored procedure containers:
Sage X3 Intelligence Reporting : An unexpected error occurred.
Error Number : 
Description : [Operation is not allowed when the object is closed.]
Source : [ADODB.Recordset]
1. I get the error on all my schemas
2. There is one report that does use a simple stored proc without parameters that runs without an issue
3. I get the error as soon as I've entered parameters and select OK
4. I've checked a previous post with a similar error and checked what was suggested
I have found this article hope it helps:
Thanks, I'll check it out
I found the follwing solution to this issue. It may not have resolved the source problem, and may just be a work around:
I went and changed all the lists on the parameters where I was listing text by adding apostrophes as prefixes and suffixes to the options in the list:
So E.g. Parameter Company - List option was Company1, Company2
I changed this to 'Company1', 'Company2'
This resolved my issue