Answered by:
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??
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