details for a date and time in future.

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

 

 

Answer 1

User-1590246810 posted

Hi,

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

 

Answer 2

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 ^_^

Answer 3

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.

Answer 4

User1137674169 posted

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

Answer 5

User-1647480408 posted

can i do it by SQL expression???

Answer 6

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