Thanks very much. I had the footer on the report rather than the group. works fine now

Thanks very much for your help. I will let you know how I handle the date in SSRS in due course

Hi Luke,

I can see what the problem is now!! I have been entering in dates as dd/mm/yy which is the format many of us use in the UK. I have...

Hi - I mentioned the datatype for continuousdate is of type datetime. I am rightclicking on the procedure name in sql server 2005 management studio to execute. If I set...

I am getting the error message even when I run the very simple script below. Continuousdate is definitely of type datetime in the table. Something must be set up incorrectly...

Hi - thanks very much for looking over my code. Your amended code compiles OK but I still get the same error on execution, when @TheDate is declared as datetime

Msg...

Previously this data was used to populate an excel spreadsheet but I've been asked to produce it in reporting services with a date parameter. No date vars were used previously...

Thanks for replying.

If I have my date var set as datetime in management studio I get the following error

Msg 8114, Level 16, State 5, Procedure spGdbaSourceExport, Line 0

Error converting...

Thanks so much for your help - that's all working fine now. I had not realised you can put a parameter into an sp without declaring it and initialising it...

Hi - have done both these things and report runs; however, now no data is being returned.

Just returned to this this afternoon but still got a problem with - The report parameter ‘Manager’ has a DefaultValue or a ValidValue that depends on the report parameter “Manager”....

Thanks again. I've unchecked the multi-value box in the parameter which is called Manager. When I run amended dataset in the data tab I am prompted to enter All or...

Thanks, that has worked brilliantly by putting ALL in the correct part of the parameter list (with multi-value box checked).

All the data is being returned from the sp however...

Many Thanks - I'll give that a go