Post reply

Group Header

  • March 31, 2009 at 10:40 am

    #219582

    i am trying to group by creation date and the comments entered on that creation date

    I have the creation date field value in the group header. comments text in the detail section.

    I am not sure why the creation date shows up everytime with different comment text.

    i see a difference in the time but i want to do it by date. How do i achieve it?

    Say for example user enters 4 comments on the same day but different time, i want it to be grouped by date and not with combination of time.

  • March 31, 2009 at 1:57 pm

    #969422

    In your SQL script, you can use CAST or CONVERT to return just the date, not date/time, and use that field in your grouping.

    Or (and I have never tried this but it might work), in your Grouping Properties, under Group On Expression, change it to =format(datetimefield.value,"MMddyyy").

  • April 1, 2009 at 12:29 am

    #969640

    use like below sql code to covert the datetime field

    select CONVERT(VARCHAR(10),datefieldname, 101) AS datefieldname from tablename

    Use the above code in your dataset while selecting the date value from table

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

    Thanks,
    Arunkumar S P

Viewing 3 posts - 1 through 2 (of 2 total)

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