March 4, 2009 at 10:11 pm
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
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
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
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
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
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
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