Hi Peter,

I tried to execute this query and I didn't have any error thrown when executing it.

1. Which version of Enesys RS Data Extension are you using?
2. Where are you trying to execute this query? If you are executing this query within BIDS in the Preview tab, you can try to go back to the query designer, click on the execute button () and provide the two parameters. Then click on the button to refresh the fields ().

Regards,
Marien Monnier
Enesys

Hi Peter,

Do you have this error within BIDS or within your Report Server? If this error is within your Report Server, do you have the same problem within BIDS?

Could you try to activate the error logging framework within BIDS so we can see what is going wrong?

1. Copy the Enesys.ReportingServices.Ersde2008.nlog file located in the "ConfigFiles\ReportDesigner" folder of your current ERSDE installation. You can access the main ERSDE folder through the Program Menu folder. (Default program location is C:\Program Files\Enesys\ERSDE2008)
2. Paste the file to the "PrivateAssemblies" folder of your BIDS installation:
   C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies for Visual Studio 2005
   C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies for Visual Studio 2008
3. Re-execute the query.

In the CommonApplicationData folder (C:\ProgramData on Vista, C:\Documents and Settings\All Users\Application Data on other Windows), you should have an ERSDELogFiles folder.

Could you send us the ERSDE2008Error.log file to our support address? (Email address is available in the last page of the documentation

Thank you,

Regards,
Marien Monnier
Enesys