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

 

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

as i said before you cannot do condtional sums.

Likely multiple RTS will work.

 

Did you set the Running total Reset value to = On cange opf Group (Store name)?