Hi Friends,
I am using crysal reports2008. My Report requirement looks simple but was unable to achieve.
I need to count the tickets on Daily,weekly,monthly,Yearly. Report will display all the columns.
Daily–Displays the current date tickets
Weekly–Displays current week details
Monthly–Displays current month total tickets.
Hope I was clear
How can I calculate this information. Any help would be appreciated.
Thanks in Advance
Anil.
anil.ganga1 
(BOB member since 2007-07-04)
Insert 5 groups (grouped on your date field) and then change the lowest to display daily, then next weekly, then next Monthly and so on.
Then insert whatever counts the tickets in the detail section.
ABILtd 
(BOB member since 2006-02-08)
Hi Andyskinner,
Thanks for ur prompt reply, I need to show all the values in a horizantal table.
Daily||weekly||monthly||yearly
Could you please tell me any formulae to achieve each an every column seperately and then put them in details.
anil.ganga1 (BOB member since 2007-07-04)
That is really four separate queries with different date ranges…
BUT…
If you put the ticket details in the Details section, then you can create a formula for each counter to say whether the ticked falls within the week/month/year and outputs 1 if it does and 0 if it doesn’t.
then add sum totals to the report footer to output the totals for this week/month/year
You have not said whether your week is Mon-Sun or last 7 days. both are possible using formulas, but last 7 days is easier because you can simply subtract one date from another.
obiron (BOB member since 2008-01-10)
You could create a formula which does the grouping and then use this as the column headers in a crosstab.
ABILtd (BOB member since 2006-02-08)