SQL Server Performance

ssrs subreport error when i give datetime datatype

Discussion in 'SQL Server 2005 Reporting Services' started by swethayty, Aug 16, 2008.

  1. swethayty New Member

    I have created 3 sub reports which have 2 parameters as string data type and 2 parameters as date time datatype .Then i created a main report with parameter as string through which I can select which subreport I need to preview.When Processing I got an error as
    [rsErrorExecutingSubreport] An error occurred while executing the subreport ‘subreport1’: The value provided for the report parameter 'Begin' is not valid for its type.
    Begin has date time data type.
    Any help hoe to solve this issue is highly appreciated.
    thanks in advance,
    sasi
    swethayty, Aug 16, 2008
    #2

  2. dineshasanka Moderator

    Veridy where you are passing correct value.
    OR
    You may have passing NULL but parameter may not be configured for NULL
    dineshasanka, Aug 17, 2008
    #3

Share This Page