Error BC30654

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

FlashMerlot - 01 Jun 2005 12:56 GMT

I get the following error ... Any advice?

The value expression for the query parameter ‘@JIDs’ contains an error:
[BC30654] 'Return' statement in a Function or a Get must return a value.

Signature

Frederick Volking
System Architect
SC Dept of Juvenile Justice

Reply to this Message

Wayne Snyder - 01 Jun 2005 23:15 GMT

It looks like the parameter gets its value from a function...

Please post the function code...

Signature

Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)

I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org

>I get the following error ... Any advice?
>
> The value expression for the query parameter '@JIDs' contains an error:
> [BC30654] 'Return' statement in a Function or a Get must return a value.

Reply to this Message

Terry Francis, Database Developer - 02 Jul 2009 19:51 GMT

This error will occur when an SSRS report is based on a SQL stored procedure that must receive one or more parameters from the report at run-time, and the value of the parameters from within the report are not correctly set in the dataset. To correct this error in Visual Studio 2005 do the following:

1. Open the report project in Visual Studio 2005.
2. Select the report from the Solution Explorer.
3. Click on the Data tab.
4. The dataset on which the report is based should be selected in the Dataset drop-down menu. Click the elipsis next to the drop-down menu to edit the dataset.
5. When the dataset dialog box is displayed, click on the Parameters tab.
6. For each parameter that is passed to the stored proc, enter the parameter name, i.e., “@myParmVal” as it appears in the storec procedure. From the Value drop-down list, select the “=Parameters!myParmVal.Value” option.

From http://www.developmentnow.com/g/115_2005_6_0_0_533801/Error-BC30654.ht

Posted via DevelopmentNow.com Group
http://www.developmentnow.com/g/

Reply to this Message