I finally got this right using the Matrix control thanks, the one issue i'm having is when I'm exporting it to excel, it only shows one row, what do i...

Hi,

Thanks for the response,

Using the Matrix control i get Rows, Columns and Data. I tried putting the serverId on the columns box but it only shows the systems for Server01...

Thanks once again, my issue now is that I had to create one reporting user and stored that users credentials on the data source. So no matter who is running...

Hi,

Thanks for the response, one more question how can I get that global Field do i have to create it ?

Got the answer, changed the Language setting on the textbox to use my local settings, it was using default.

Thanks for the replies. you both mentioned that these solutions will not perform well. IS that terms terms of speed or will it cause any harm to the the DB?

Regards

thanks this worked.

Thanks this did the trick.

Replace + with &.

Got the answer. thanx

Thanks for all the replies.

Willem, your solution does give me the result I want. However, i wonder if there is a better way to do it since in my scenario...

Thanks you are right. I didnt have database e-mail configured.

Hi Phil,

Thanks for a reply, by inject I mean putting thie script on the sql command text box. Received was a typing error. [PaymentDate] and [ReceivedDate] are Varchar datatypes....

Thanks I think i'm gonna go with a staging table approach.

The way they want it to happen is, they will forward me a File with changes from the Master DB and. I would then be expected to import that file...