Generate Script - Specified cast is not valid

When trying to generate a script, from SQL Server Management Studio, for the
following Store Procedure ( SP ) I receive the following error. I have
dropped and recreated the Store Procedure but I continue to get the error.
CREATE PROCEDURE dbo.usp_CreditCardSaveTargetQueue_S_Count
@.RecordCount INT OUTPUT
AS
SET NOCOUNT ON
SELECT @.RecordCount = COUNT(*)
FROM CreditCardSaveTargetQueue
WITH(NOLOCK) WHERE validation = 'X'
GO
-- **************************************************************
Error:
TITLE: Microsoft.SqlServer.SqlEnum
--
Failed to retrieve dependency information (object_id(System.Int32)
1952726009.object_type(System.Int16) 4.relative_id(System.Int32)
731149650.relative_type(System.DBNull) .object_name(System.String)
usp_CreditCardSaveTargetQueue_S_Count.object_schema(System.String)
dbo.relative_name(System.DBNull) .relative_schema(System.DBNull) .).
--
ADDITIONAL INFORMATION:
Specified cast is not valid. (Microsoft.SqlServer.SqlEnum)I'm having the same problem and have tried the same resolution
(dropping/recreating stored procedure). If I try to script the database and
include this stored procedure, it fails. If I try to view dependencies to
this stored procedure it fails. Specified cast is not valid.
(Microsoft.SqlServer.SqlEnum).
"BarDev" wrote:
> When trying to generate a script, from SQL Server Management Studio, for the
> following Store Procedure ( SP ) I receive the following error. I have
> dropped and recreated the Store Procedure but I continue to get the error.
>
> CREATE PROCEDURE dbo.usp_CreditCardSaveTargetQueue_S_Count
> @.RecordCount INT OUTPUT
> AS
> SET NOCOUNT ON
> SELECT @.RecordCount = COUNT(*)
> FROM CreditCardSaveTargetQueue
> WITH(NOLOCK) WHERE validation = 'X'
> GO
> -- **************************************************************
> Error:
> TITLE: Microsoft.SqlServer.SqlEnum
> --
> Failed to retrieve dependency information (object_id(System.Int32)
> 1952726009.object_type(System.Int16) 4.relative_id(System.Int32)
> 731149650.relative_type(System.DBNull) .object_name(System.String)
> usp_CreditCardSaveTargetQueue_S_Count.object_schema(System.String)
> dbo.relative_name(System.DBNull) .relative_schema(System.DBNull) .).
> --
> ADDITIONAL INFORMATION:
> Specified cast is not valid. (Microsoft.SqlServer.SqlEnum)
>

Generate Script - Specified cast is not valid

When trying to generate a script, from SQL Server Management Studio, for the
following Store Procedure ( SP ) I receive the following error. I have
dropped and recreated the Store Procedure but I continue to get the error.
CREATE PROCEDURE dbo.usp_CreditCardSaveTargetQueue_S_Count
@.RecordCount INT OUTPUT
AS
SET NOCOUNT ON
SELECT @.RecordCount = COUNT(*)
FROM CreditCardSaveTargetQueue
WITH(NOLOCK) WHERE validation = 'X'
GO
-- ****************************************
**********************
Error:
TITLE: Microsoft.SqlServer.SqlEnum
--
Failed to retrieve dependency information (object_id(System.Int32)
1952726009.object_type(System.Int16) 4.relative_id(System.Int32)
731149650.relative_type(System.DBNull) .object_name(System.String)
usp_CreditCardSaveTargetQueue_S_Count.object_schema(System.String)
dbo.relative_name(System.DBNull) .relative_schema(System.DBNull) .).
ADDITIONAL INFORMATION:
Specified cast is not valid. (Microsoft.SqlServer.SqlEnum)I'm having the same problem and have tried the same resolution
(dropping/recreating stored procedure). If I try to script the database and
include this stored procedure, it fails. If I try to view dependencies to
this stored procedure it fails. Specified cast is not valid.
(Microsoft.SqlServer.SqlEnum).
"BarDev" wrote:

> When trying to generate a script, from SQL Server Management Studio, for t
he
> following Store Procedure ( SP ) I receive the following error. I have
> dropped and recreated the Store Procedure but I continue to get the error.
>
> CREATE PROCEDURE dbo.usp_CreditCardSaveTargetQueue_S_Count
> @.RecordCount INT OUTPUT
> AS
> SET NOCOUNT ON
> SELECT @.RecordCount = COUNT(*)
> FROM CreditCardSaveTargetQueue
> WITH(NOLOCK) WHERE validation = 'X'
> GO
> -- ****************************************
**********************
> Error:
> TITLE: Microsoft.SqlServer.SqlEnum
> --
> Failed to retrieve dependency information (object_id(System.Int32)
> 1952726009.object_type(System.Int16) 4.relative_id(System.Int32)
> 731149650.relative_type(System.DBNull) .object_name(System.String)
> usp_CreditCardSaveTargetQueue_S_Count.object_schema(System.String)
> dbo.relative_name(System.DBNull) .relative_schema(System.DBNull) .).
> --
> ADDITIONAL INFORMATION:
> Specified cast is not valid. (Microsoft.SqlServer.SqlEnum)
>|||I'm having the same problem and have tried the same resolution
(dropping/recreating stored procedure). If I try to script the database and
include this stored procedure, it fails. If I try to view dependencies to
this stored procedure it fails. Specified cast is not valid.
(Microsoft.SqlServer.SqlEnum).
"BarDev" wrote:

> When trying to generate a script, from SQL Server Management Studio, for t
he
> following Store Procedure ( SP ) I receive the following error. I have
> dropped and recreated the Store Procedure but I continue to get the error.
>
> CREATE PROCEDURE dbo.usp_CreditCardSaveTargetQueue_S_Count
> @.RecordCount INT OUTPUT
> AS
> SET NOCOUNT ON
> SELECT @.RecordCount = COUNT(*)
> FROM CreditCardSaveTargetQueue
> WITH(NOLOCK) WHERE validation = 'X'
> GO
> -- ****************************************
**********************
> Error:
> TITLE: Microsoft.SqlServer.SqlEnum
> --
> Failed to retrieve dependency information (object_id(System.Int32)
> 1952726009.object_type(System.Int16) 4.relative_id(System.Int32)
> 731149650.relative_type(System.DBNull) .object_name(System.String)
> usp_CreditCardSaveTargetQueue_S_Count.object_schema(System.String)
> dbo.relative_name(System.DBNull) .relative_schema(System.DBNull) .).
> --
> ADDITIONAL INFORMATION:
> Specified cast is not valid. (Microsoft.SqlServer.SqlEnum)
>

Generate chart dynamically

Can sombody tell me how to generate cahrt dynamically in reporting service?
I need to generate a number of charts based on the number specified.
Thanks
--
WeiNot sure what you exactly mean with dynamically "generate a number of
charts" - but did you look into the Visibility.Hidden property of the chart?
You can define several charts at design time and hide them using an
expression at runtime (dependent on e.g. a parameter value).
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"David" <weiliu00@.hotmail.com> wrote in message
news:D2828717-5299-43FF-B838-F29269B9D713@.microsoft.com...
> Can sombody tell me how to generate cahrt dynamically in reporting
service?
> I need to generate a number of charts based on the number specified.
> Thanks
> --
> Wei|||I 've got a chart (2 actually) inside a list. It creates the charts for
each element in the list. Works like a charm. (Except that you cannot
control the Y-scale, but that will be solved in the next release, I hear).
Hth,
Tom
"David" wrote:
> Can sombody tell me how to generate cahrt dynamically in reporting service?
> I need to generate a number of charts based on the number specified.
> Thanks
> --
> Wei|||Hi, Robert :
Thank you for your kind help. As my project, I do not know how many charts
will be generated. It depends on the number that a user specifies. What I am
planning to do is to use the following codes to generate chart dynamically:
Response.Write("<cc1:ReportViewer id='ReportViewer1' style='Z-INDEX: 101;
LEFT: 8px; POSITION: absolute; TOP: 8px' runat=server Width=680px
Height=632px ServerUrl='http://localhost/reportserver' ReportPath='/Sample
Report/Report1'" & _
"Toolbar=Default></cc1:ReportViewer>")
Of course I need to pass a parameter to the report so that the chart will be
different. However, it looks like the the above codes does not work.
Robert. Could you give me some suggestions?
Thanks a lot,
David
"Robert Bruckner [MSFT]" wrote:
> Not sure what you exactly mean with dynamically "generate a number of
> charts" - but did you look into the Visibility.Hidden property of the chart?
> You can define several charts at design time and hide them using an
> expression at runtime (dependent on e.g. a parameter value).
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "David" <weiliu00@.hotmail.com> wrote in message
> news:D2828717-5299-43FF-B838-F29269B9D713@.microsoft.com...
> > Can sombody tell me how to generate cahrt dynamically in reporting
> service?
> >
> > I need to generate a number of charts based on the number specified.
> >
> > Thanks
> > --
> > Wei
>
>