Error on generating report

I am using VS2003 and SQL Server 2000 with Reporting Services.

I try to generate the report but get an error "must declare the variable '@.qcode'

I check the file quotation.rdl and i found it should have declared... it's like

</PageFooter>
<ReportParameters>
<ReportParameter Name="qcode">
<DataType>String</DataType>
<Nullable>true</Nullable>
<DefaultValue>
<DataSetReference>
<DataSetName>DS_quot_code</DataSetName>
<ValueField>quot_code</ValueField>
</DataSetReference>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>Quotation Code:</Prompt>
<ValidValues>
<DataSetReference>
<DataSetName>DS_quot_code</DataSetName>
<ValueField>quot_code</ValueField>
<LabelField>quot_code</LabelField>
</DataSetReference>
</ValidValues>
</ReportParameter>

I would like to know what trigger the problem and what shall i do so as to solve it?

Thank you.

This sounds for me like a SQL Exception not a Reporting Services error. Can you run the command which is specified as the dataset command separately, or does it come up with the same error (I guess this is the case)

HTH; Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Thank you for your answer.

Does you mean that the problem comes from the SQL query stated in the rdl file?

|||Exactly.

Error Message when trying to open AdventureWorksDB in vbexpress

I get the following error message when trying to open the AdventureWordsDB in VBExpress: "Failed to generate a user instance of SQL Server dut to failure in starting the process for the user instance. The connection will be closed." Can someone tell me what the problem is and how to solve it? Thanks, Ray Holt

hi,

you seemed to open a database in User Instace mode.. User Instances are available in SQLExpress edition only and they have to be enabled.. at installation time of SQLExpress a kind of message asks you to enable this feature or not, but you can enable it even later executing the sp_configure system stored procedure with the 'user instances enabled' parameter..

regards

|||How do I execute the sp_configure? Thanks, Ray Holt|||

hi Ray,

for your convenience, you can download and install SQL Server Management Studio Express... you can then execute it, "open a new query", and execute the sp_configure call..

regards

Error message

I am getting this error message over night. The server is
not busy during this time but a job that runs at 1 AM
seems to generate this error only when it runs at 1 AM.
When I rerun it at 7 AM when I come in to work it runs
fine. The error is:
Error: 1204, Severity: 19, State: 1
The SQL Server cannot obtain a LOCK resource at this time.
Rerun your statement when there are fewer active users or
ask the system administrator to check the SQL Server lock
and memory configuration.
What configuration settings are availiable for this? I
allow SQL to dynamically set its memory between 0 and 6656
MB with 8 gig availiable.
Please advise.Lots of questions:
Are you running SQL Ent Edition? (if not can not use more
than 2gb of ram)
What kind of job is it? Are you running maintenance
routines at the same time? Do you ahve any errors in the
SQL log at the same time? Event viewer errors?
Ray Higdon MCSE, MCDBA, CCNA
>--Original Message--
>I am getting this error message over night. The server is
>not busy during this time but a job that runs at 1 AM
>seems to generate this error only when it runs at 1 AM.
>When I rerun it at 7 AM when I come in to work it runs
>fine. The error is:
>Error: 1204, Severity: 19, State: 1
>The SQL Server cannot obtain a LOCK resource at this
time.
>Rerun your statement when there are fewer active users or
>ask the system administrator to check the SQL Server lock
>and memory configuration.
>What configuration settings are availiable for this? I
>allow SQL to dynamically set its memory between 0 and
6656
>MB with 8 gig availiable.
>Please advise.
>
>.
>