Thanks to all that posted. I have configured SSRS as suggested, now I need to have aplay. I will check out that link and have a read up.

Thanks,

Phil.

I will take a look.

Regards,

Phil.

Resolved. My last post resolved the issue, I just needed to modify the report!

Thanks,

Phil.

Update

The following workin when I execute the SQL query but returns an error when I run the report?

'£' + CONVERT(varchar(12), CAST (CVCustomsValue.CustomFieldValueDecimal as money),1) AS CustomsValue

Hi Christopher. I do not know why I tried that as the data type is decimal so no conversion required!

I simply want to format to 2 decimal places.

'£' + CONVERT(varchar(12),CVCustomsValue.CustomFieldValueDecimal

The...

I have now modified the query as follows:

'£' + CONVERT(varchar(12),CVCustomsValue.CustomFieldValueDecimal,1)

How do I get it to display to 2 decimal places?

I tried:

'£' + CONVERT(varchar(12),CONVERT(decimal(5,2),CVCustomsValue.CustomFieldValueDecimal))

That returned error: Arithmetic overflow error converting...

Thanks Steve.

Phil

Thanks for your feedback guys.

Phil.

Hi Matt. Gave that a whirl. The report failed to return any records when I entered number of days as integer.

Is this due to the field being of data type...

Hi Matt. Missed your post. Thanks, will give that a whirl back at the office. The report runs as expected from within the application, just not within visual studio?

Thanks,

Phil.

Update. OK. If iI execute the query via the Dataset then enter value for @Expiry as 03/06/2008 the query runs as expected. If I execure via the calendar on the...

Hi. I have tried replacing the <= GETDATE() + 5 with <= @Expiry

In the report I set the parameter data type to DateTime. When I select the date from the...

Thanks. I now have a related question regards the report side that I will post to the relevent forum.

Many Thanks,

Phil.

Thanks for the reply Michael. I did not intend to change the schema. What I am doing currently is deleting the data from the tables in the database I wish...

Hi Sandy. Do you have an example as I could put that to good use.

Thanks,

Phil.