Dates in database are
Ist july 2006
2 nd july 2006
1 st sep 2006
Group by state1
I need to get count of Application nos for Group by state1 and date should be in header for a week. we have to pass date range values from date_range parameter
How do get it. The format is given below:
Sat Sunday Monday .. Friday
Statename 1/7/2006 2/7/2006 3/7/2006 .. 7/7/2006
State1 2 5 7 6
If I do group by date, then dates will not appear in a horizontal manner, Please help me how to proceed furtherTry the cross-tab format for the report.
Rashmi|||cross tab shoul not be used as per the clients requirement
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment