Post reply

SSRS:Dynamically binding dataset to rdl

  • March 4, 2009 at 10:11 pm

    #207225

    Hi

    Is there any way to bind the dataset to rdl reports dynamically in VS 2005. I am in the need to manipulate the dataset before binding the data to report.

    Any Help please

  • March 5, 2009 at 2:27 am

    #953858

    Hi

    I think you should probably look at creating a stored procedure that is called from the .RDL using the necessary parameters that will allow you to manipulate the dataset. The parameters could be used to generate a dynamic select statement.

    Without more information that's about as clear as I can be.

    Nigel.

    Nigel West
    UK

  • March 6, 2009 at 4:25 am

    #954752

    Hi

    I am using SP only. The problem is my values are encrypted at the backend.

    I have to decrypt using my own procedure before displaying in the report. Is there any way to do that?

    Soundari

  • March 7, 2009 at 6:35 am

    #955450

    I would have thought you would need to decrypt within the stored procedure before returning the dataset to the report, what is the problem with doing it this way?

    Nigel West
    UK

  • March 13, 2009 at 10:29 am

    #959290

    How can I put the names of the columns on the report table after the dataset is returned by a dynamic sql from inside a stored procedure? Thanks.

  • March 16, 2009 at 5:31 am

    #960125

    Hi

    Thank you Mr.Nigel. I thought it may overload the database server. Anyway now i put decrypt function in the sql server and decrypting in the SP. Working fine.

    Thank you

    Soundari

  • September 6, 2010 at 5:47 am

    #1216884

    How can i drag the columns from the data set dynamically

Viewing 7 posts - 1 through 6 (of 6 total)

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