Post reply

Passing Time parameter as apposed to date

  • March 31, 2009 at 10:01 am

    #202381

    Hi All,

    Have asked my good friend Mr Google, but he has not helped me out here. 😉

    I have a query to produce a report to pull out a list of certain actions performed between two set times. Obviously I can pass date parameters, but running for one whole day will return unnecessary results and I cannot filter out any more on other fields.

    Any ideas how I can configure the parameter within SSRS to allow entering of a time value (both timefrom and timeto)

    Any ideas greatly appreciated

    Thanks,

    Danny

  • April 1, 2009 at 1:01 am

    #969648

    I think you can't but what my suggestion is to have a dropdown and hardcode the value like 01:15,01:30,01:45,02:00,02;15... in both fromtime and totime field. Then you can filter the value using query.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------
    Please feel free to let me know if you are not clear or I’ve misunderstood anything.

    Thanks,
    Arunkumar S P

  • April 1, 2009 at 4:51 am

    #969717

    we record the time within our date fields (e.g. 2009-03-12 17:11:16.110)

    Any way that i would be able to query that? :unsure:

  • April 1, 2009 at 5:08 am

    #969727

    Yes Danny. Use the query like this

    select datetimeCol from TestTable where datetimeCol >='01/13/2009 01:30:00' and datetimeCol<='01/13/2009 18:45:00'

    where datetimeCol is your table column

    -----------------------------------------------------------------------------------------------------------------------------------------------------------
    Please feel free to let me know if you are not clear or I’ve misunderstood anything.

    Thanks,
    Arunkumar S P

  • April 1, 2009 at 5:25 am

    #969734

    Thanks, I understand that we can do with with t-sql, but how can we do this from SSRS?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply