Joined: 06 Oct 2010
Location: United States
Online Status: Offline
Posts: 44
Topic: its urgent Posted: 07 Oct 2010 at 7:12am
hey can please some one help me........
my problem is i have one field in my sql db that is visitor... and i have date field also thr..... i have to take two date ranges and have to group by data with site name..... and according to date have to count how many visitors was thr on tht site during that dates.....
i am doing that with formula....
if({Visitor_info.Date}in({?CFromDate}to{?CTodate})) then Sum ({Visitor_info.DailyUnique}, {Site_Info.Site_Name})
for one date and same foe second only parameter is diffrent..... but its giving me total number.....
please help me some expert i have to finish this today evening.......
Joined: 06 Oct 2010
Location: United States
Online Status: Offline
Posts: 44
Posted: 07 Oct 2010 at 8:32am
thanks for your reply..... i did try this but in running total its adding that value to next record.... see my problem is....
i have couple of site name and site id in my one table and have visitor info in second tabel.....
i have to create report and give two date ranges
for both range i have to fetch data from table and have to do group by site name and for that site i have to display data in two diffrent columns and at last have to display total of this two field.... and in other fields i have to do comparission between this two fields..... so may be this running total will not work..... please help me....... i really appriciate it.........
Joined: 06 Oct 2010
Location: United States
Online Status: Offline
Posts: 44
Posted: 07 Oct 2010 at 8:50am
i did this with formula as i told before
if({Visitor_info.Date}in({?CFromDate}to{?CTodate})) then Sum ({Visitor_info.DailyUnique}, {Site_Info.Site_Name})
its giving me result but the thing is when date is in range its not checking all dates for this site.... once date is match its calculating all visitor for that site.......
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 07 Oct 2010 at 9:02am
i do not understand your design.
as i said before you cannot do condtional sums.
Likely multiple RTS will work.
Originally posted by neha_patel
i have to do group by site name and for that site i have to display data in two diffrent columns
create a group on the sitename
create 2 running totals to display each summation based on your 2 sets of params
you can also create a formula field to compare these summaries at the group level
Originally posted by neha_patel
and at last have to display total of this two field....
create 2 more RTS that are the exact same as your others (group totals)but they are not set to reset on the group (same thing as adding all the group level rts togther).
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
