locked
details for a date and time in future. RRS feed

  • Question

  • User-1647480408 posted

    i want to generate a report where the details are related to future date and time.

    how i can do that??

     

     

    Sunday, November 4, 2012 1:12 AM

Answers

  • User-578610739 posted

    Hi Oman,

    see this,

    http://forums.asp.net/t/1073788.aspx/1

    http://www.reportsyouneed.com/crystal-add-command-vs-views/

    or you can check your post

    http://forums.asp.net/t/1856565.aspx/1?exception+in+passing+a+para+to+a+report

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, November 7, 2012 12:09 AM

All replies

  • User-1590246810 posted

    Hi,

       Can you please ellaborate your needs.?? how you want future date and time should be..?? what are the reports..??

     

    Sunday, November 4, 2012 2:14 AM
  • User-1647480408 posted

    it is a report shoing the shift details for each employee

    the details should be related to the coming day not in the past one.

     

    i hope that it is clear ^_^

    Sunday, November 4, 2012 3:04 AM
  • User-578610739 posted

    Hi Oman88,

    For your need , you make a sp which gives you the data. I'll show you as

    select cast('05 jan 2011' as datetime) as DT, 1 as val into #t
    union all select CAST('05 jan 2011' as datetime), 1 
    union all select CAST('29 jan 2011' as datetime), 1 
    
    declare @start datetime = '01 jan 2011'
    declare @end   datetime = dateadd(day, 29, @start)
    
    ;with amonth(day) as
    (
        select @start as day
            union all
        select day + 1
            from amonth
            where day < @end
    )
    select amonth.day, count(val)
        from amonth 
        left join #t on #t.DT = amonth.day
    group by amonth.day



    After this sp you can merge your column with dateoutput. Now you whole data is set in db. you just through in report.

    Monday, November 5, 2012 2:32 AM
  • User1137674169 posted

    what output do you want? please post codes you have right now.

    Monday, November 5, 2012 2:35 AM
  • User-1647480408 posted

    can i do it by SQL expression???

    Tuesday, November 6, 2012 12:44 AM
  • User-578610739 posted

    Hi Oman,

    see this,

    http://forums.asp.net/t/1073788.aspx/1

    http://www.reportsyouneed.com/crystal-add-command-vs-views/

    or you can check your post

    http://forums.asp.net/t/1856565.aspx/1?exception+in+passing+a+para+to+a+report

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, November 7, 2012 12:09 AM