Viewing 10 posts - 1 through 11 (of 11 total)
.... also if I don't enter any values into the data parameters (which can be null) no data is returned when what I actually want is all dates
March 10, 2008 at 10:34 am
What I want is for the user running the report to be able to ignore the parameters they don't want (without being prompted to input one) or to enter a...
March 10, 2008 at 9:47 am
Yes, the date report parameters are of type datetime.
The user picks the dates from a calendar icon on preview
March 5, 2008 at 3:43 am
Sorry to keep hassling. Here is the full script. This is very important and I am being leant on to get this working. Error message as below:-
Msg 8155, Level 16,...
February 12, 2008 at 9:53 am
Nearly there, I think. I have cut & paste exactly as in Query Analyser. Error message is:-
sg 170, Level 15, State 1, Line 44
Line 44: Incorrect syntax near ')'.
INSERT INTO...
February 12, 2008 at 8:01 am
Convert now works correctly.
Leadtime is int(3) in reportingdata and supposed to be a derived value from ForecastName. Not sure what you mean by using case twice though. Could you...
February 12, 2008 at 6:31 am
Realised the line with convert doesn't work either. Date needs to be stored as dd/mm/yy in reporting table
Msg 242, Level 16, State 3, Line 17
The conversion of a char data...
February 12, 2008 at 5:24 am
INSERT INTO ReportingData
(ProjectNo
, ProjectType
, Title
, CustomerName
...
February 12, 2008 at 5:06 am
Ignore £ sign question as I figured this one out - I hadn't set report language property to UK
February 6, 2008 at 8:30 am
Viewing 10 posts - 1 through 11 (of 11 total)