Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: its urgent Post Reply Post New Topic
<< Prev Page  of 5 Next >>
Author Message
neha_patel
Groupie
Groupie
Avatar

Joined: 06 Oct 2010
Location: United States
Online Status: Offline
Posts: 44
Quote neha_patel Replybullet Posted: 07 Oct 2010 at 9:29am
hey i got it...... thanks a lot.... i relly appriciate it....
IP IP Logged
neha_patel
Groupie
Groupie
Avatar

Joined: 06 Oct 2010
Location: United States
Online Status: Offline
Posts: 44
Quote neha_patel Replybullet Posted: 07 Oct 2010 at 9:30am
hey can you help me with one more problem if you can..... that report i have to submit by tomorrow evening.....
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 07 Oct 2010 at 9:30am

Are you really using a Crystal Running Total (RT) or are you using a variable formula?

I was suggesting to use a RT.
Right Click on RT and select NEW
Enter a Name
field to summarize={Visitor_info.DailyUnique}
type of summary=SUM
evaluate=use a formula
{Visitor_info.Date}in({?CFromDate}to{?CTodate}
reset=on a group pick the group name from the pick list that is = to{Site_Info.Site_Name}
IP IP Logged
neha_patel
Groupie
Groupie
Avatar

Joined: 06 Oct 2010
Location: United States
Online Status: Offline
Posts: 44
Quote neha_patel Replybullet Posted: 07 Oct 2010 at 9:31am
Thank you thank you thank you........Smile you knw i was working on this from last day
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 07 Oct 2010 at 9:31am
what is the other issue?
IP IP Logged
neha_patel
Groupie
Groupie
Avatar

Joined: 06 Oct 2010
Location: United States
Online Status: Offline
Posts: 44
Quote neha_patel Replybullet Posted: 07 Oct 2010 at 9:36am
oh god that issu is very big for me......... my report is almost over but bcoz of this one field i m stuck......
 
i have 5 fields in my table.....for each site......
 
that field is for..... it store's 5 most visited site... for each site... every day.....
 
in my second report i m passing date range and site id..... according to that i have to display all data...... which i already did.... but i have to show most visited 5 pages from that date range......
 
 
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 07 Oct 2010 at 9:41am
please explain 'most visited 5 pages from that date range'
IP IP Logged
neha_patel
Groupie
Groupie
Avatar

Joined: 06 Oct 2010
Location: United States
Online Status: Offline
Posts: 44
Quote neha_patel Replybullet Posted: 07 Oct 2010 at 9:46am
i am passing parameter as date
user will give date like 01/01/2010 to 09/09/2010
so for this time i have to display data for user given site id and
i have to find 5 most visited pages from db's 5 fields.....
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 07 Oct 2010 at 9:53am
i don't know your data...
what is a 'visited page' and what is 'db's 5 fields'?
how are you counting it or summing it?
is this the RT result?
is it in the main report?
IP IP Logged
neha_patel
Groupie
Groupie
Avatar

Joined: 06 Oct 2010
Location: United States
Online Status: Offline
Posts: 44
Quote neha_patel Replybullet Posted: 07 Oct 2010 at 11:32am
see i have data base(report_info) in that i have 3 table one for which type of site is it. 2nd is site info. and 3rd is main table visitor information and in this table i have all information about visitor's with site id....as foreign key.... in this table i have lots of fields but 5 of them are most visited1,most visited 2, most visited 3,most visited 4, most visited 5 in this field site names are thr..... like which 5 site's are most visited today.... like that for every day......
 
in my report i have to pass site id....and date range as parameter...... and with this site id i have to do group by data...... but i have to find 5 most visited site from table visitor information table's most visited1,2,3,4,5 field......
hope i cleared my self....
IP IP Logged
<< Prev Page  of 5 Next >>
Post Reply Post New Topic
Printable version Printable version

Forum Jump
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



This page was generated in 0.043 seconds.