Forum Replies Created

Viewing 10 posts - 1 through 11 (of 11 total)

  • RE: Using report parameters to return all data or just selection

    .... 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

  • RE: Using report parameters to return all data or just selection

    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...

  • RE: Date parameters

    Changed this and seems OK. Looks neater as well.

  • RE: Date parameters

    Yes, the date report parameters are of type datetime.

    The user picks the dates from a calendar icon on preview

  • RE: Case statement

    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,...

  • RE: Case statement

    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...

  • RE: Case statement

    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...

  • RE: Case statement

    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...

  • RE: Case statement

    INSERT INTO ReportingData

    (ProjectNo

    , ProjectType

    , Title

    , CustomerName

    ...

  • RE: Need to sort data and get top 10 only by value

    Ignore £ sign question as I figured this one out - I hadn't set report language property to UK

Viewing 10 posts - 1 through 11 (of 11 total)