Post reply

Data Driven subscription not working with parameter passing

  • February 24, 2010 at 11:07 am

    #230303

    Hi,

    I had created one table called userinfo.

    CREATE TABLE [dbo].[UserInfo] (

    [SubscriptionID] [int] NOT NULL PRIMARY KEY ,

    [LastName] [nvarchar] (100) NOT NULL ,

    [FileType] Bit,

    [Format] [nvarchar] (20) NOT NULL ,

    Company Varchar(100)

    ) ON [PRIMARY]

    GO

    INSERT INTO [dbo].[UserInfo] (SubscriptionID,LastName,FileType,Format,Company) VALUES ('1', 'nairgokul70@gmail.com', '1','Excel','CBL')

    in data driven subscription i had set company column as parameter where parameter is asked and the report is scheduled. but the report fails.

    if i run with out parameter it works fine.

    Please let me know what mistake i am making.

    Regards

    Gokul

  • February 24, 2010 at 11:36 am

    #1124432

    What is in the report server log? DDS runs write data there, also you may have to turn the verobsity up on the log to get the information you are looking for. Unfortunately it has been months since I have had to do this myself so i can't give you a step by step, but that is the place I would start.

    CEWII

  • February 24, 2010 at 9:57 pm

    #1124745

    Hi,

    it was an issue with parameter value. As the value i was passing was string value. i changed it to integer and now its working.:-D

    Regards

    Gokul

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply