Error on reporting services

I am using VS 2003 + SQL Server 2000 Reporting services.

When i want to print the report, clicking the trigger button, and pop up a browser and get the following error.

Error occurs when handling the report (rsProcessingAborted)

Request on dataset 'PG' fails (rsErrorExecutingCommand)

Must declare the variable'@.qcode'.

- I already got qcode in my url link... i would like to know what's the problems about.

Thank you.

Hi,

Can you run this report successfully when you browse the report in the VS.NET IDE?

I think, you are passing a parameter which is not declared in the stored procedure. Are you using a stored procedure as the datasource of the dataset PG by the way?

Since you have the parameter qcode in the url, either this parameter is not defined in the report or is not defined in the SP.

You know, while naming parameters in SQL RS, you do not use the "@." preior the parameter name, but you use it within the sql SP.

Eralper

http://www.kodyaz.com

Error msg:SQLServer2005_SSMSEE.msi is not a valid installer package

I have downloaded the msi file for the SQL Server Management Studio Express. However, clicking the msi file, showed a Windows Installer error msg that the installer package can not be opened because it is not a valid installer pckage.

Previously, I did download and install the SQL Server 2005 Express successfully. We need Management Studio Express in order to run the 'Enterprise manager'. Am I right?

TIA,

Jeffrey

hi Jeffrey,

your downloaded file could be corrupted.. try downloading it again..

regards