Passing user defined data type parameters to report does not work

[Bob]

I am calling a stored procedure from my report and passing in two parameters.  The first parameter is a SQL tinyiny, the second parameter is a SQL user defined data type named [OMS].[Lot_Number].  The data type is actually of type char(10).  In any case, when I attempted to programically set the parameter of the lot_number, and end users attempt to view the report, the query disregards the parameter.

To make this even more strange, when the developers run the exact code, the report functions as designed.

So after spending several, SEVERAL hours looking into the issue and passing blame amongst others in my IT department, I removed the user defined data type and defined it as char(10).  When the end users ran the report, the report finally produced the correct data.

This here is where I ask, does the report engine accept user defined data types and if so, how to pass the parameter to the stored procedure?

I appreciate  your help.

Regards,
Bob

[Stef]

Hello Bob,

We have tested the described scenario with the following custom type and stored procedure:

use EmployeesTest
go

CREATE TYPE NameSSN
FROM varchar(10) NOT NULL ;

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

Create PROCEDURE TestUserType
    @test NameSSN,
    @intTest tinyint
AS
BEGIN
    SET NOCOUNT ON;
    SELECT Employee.*, @test as TestCustType,@intTest as TesttinyInt from Employee
END
GO

The attached sample project successfully loads a report definition using the above stored procedure to retrieve the data.

Please compare the settings to yours and if you need further help, provide us with steps how to reproduce your issue. Feel free to open a support ticket and send us a sample project and data illustrating the problem.

Regards,
Stef
Telerik