Thanks dohnfors,

I hadn't realised that the scope of the aggregate would override in that context.

I understand your solution, I've used that method for internationalisation of text. I think in this...

Hi dohnfors,

Yes, it's part of a tablix

The error is:

The BackgroundColor expression for the text box 'response_perc' referes to the field 'Response'. Report item expressions can only refer to fields within...

Still no joy. I've checked that the frameworks are installed. I have 1.0.375, 1.1.4322, 2.0.50727, 3.0, 3.5, 4.0.30319.

I've taken out all of my original code and tried to compile it...

Thanks Lowell, it does help. I have one more question. My .net is non-existent and so please forgive me if this is a dumb question.

I have in my code:

Imports System.Data

Imports...

I don't know if I'm allowed to answer my own questions, but I've solved the problem.

The issue is that the Parameters collection is zero based and not 1 based. The...

Hi Lowell,

Nope. The question is, how do I create a thumbnail from a randomly shaped image that is stored as binary image data without using .net or anything other than...

As promised:

SELECT @tmp_string  = 'bcp "SELECT Photograph FROM TableName WHERE ID=' +

      Convert(varchar(10), @id) + '" queryout "' +

      @application_path + '_' + @folder_name + '\' + @filename + '.jpg' +

      '" -f "'...

Hi Guys,

Thanks for the feedback. I'd tried the OA method without much luck. I was kinda fumbling around in the dark though. When I'm back in the office on Monday...