Thanks I will check it out. How would the end user use the tool as at present they simply select the report they wish to run, once rendered thet choose...

Thanks guys. Jeff I am using Visual Web Developer 2008. I tried omitting the formatting from the T-SQL then on the column within the GridView in VWD I set ConvertEmptyStringToNull...

Hi Florian.

DECLARE @prods TABLE (Id INT IDENTITY, Name VARCHAR(100))

INSERT INTO @prods

SELECT 'Prod1'

UNION ALL SELECT...

Thanks to all. The table in question has 34000 rows.

Many Thanks,

Phil.

Pleased to here you resolved.

Phil.

Thanks. I must say I thought adding 'Search' to the web form was going to be simple! 🙂

They had an old site running on MySQL that worked fine.

Regards,

Phil.

As far as I am aware a table can only reference a single dataset.

Regards,

Phil

Terry many thanks for taking time to respond to my post.

I will try the code posted.

Many Thanks,

Phil.

Thanks. One other thing. I created a new folder and uploaded a report to it. When the user browses to the folder it displays 'There are no items in 'Folder...

Thanks guys, linked servers is way to go then.....

Many Thanks,

Phil.

Poor old Tommy is dead.......

Thanks for all your efforts, your code looks neater than my attempt.

Kind Regards,

Phil.

Gianluca many thnaks for taking time to review my thread, I have struggled to get onto the site from the office.

I also reviewed my code and came up with the...

OK, I could run the package OK with the new credentials however I was unable to complete the 'Package Installation' wizard on the target server.

To resolve this added the login...

Hi, in answer to my own question I decided to create a new sql login and grant 'SELECT' permissions to the limited number of tables the account needed to access...

Just to update this post I found the following article regards 'Custom Logging using Event Handlers' that others may find of use.

http://blogs.conchango.com/jamiethomson/archive/2005/06/11/SSIS_3A00_-Custom-Logging-Using-Event-Handlers.aspx

Regards,

Phil.