Check the default language of the login accessing the data for your report. British English and English will interpret '08-01-2013' in different ways.

Where you trying to move the data using a linked server connection? You can map the SQL logins in this way using ( I don't mean the Windows logins).

Use a bit of caution, this may affect other views and stored procedures that use this column. They may, for instance, be...

If working with a large data set, the convert function in the where clause will slow things down as compared to having a datetime column. It may be beneficial to...

In your query you are casting as decimal(18,2). Are your numbers always going to be whole numbers?

The following example

select PATINDEX('%[^0-9]%', '1234234.20')

does not return zero.

Just though I should ask.. Is wzunzip installed on your system or the server you are trying to have run your process?

Yeah, he could be implying cascading parameters. It is just not clear (beyond a reasonable doubt) from the post itself.

In SSRS 2005 I notice stored procedures in the dataset...

+1

Glad its working out, thanks.

From MSDN,

http://msdn.microsoft.com/en-us/library/ms187864%28v=sql.105%29.aspx

Indexed views work best when the underlying data is infrequently updated. The maintenance of an indexed view can be greater than the cost of maintaining a table index....

Just to clarify, that inner join is causing the cross. Is this the intended behaviour? If so could you post how this solves your problem?

Thanks.

Maybe I am reading you wrong but I take it you are writing the...

Hi, are you using a stored procedure in your dataset definition or are you typing in the query directly?

I am not sure you can accurately partition your articles without that company identity column. Are the company names consistent across the tables that you can join to the company...

Hi. Have you tried the pivot function?