Hi !! as i mentioned i'm using the union so i cant sort that result
coz the CR is doing the grouping....



>Hi!

>I do not know CR so well, but I suggest that sorting works for case when data >source is a query for report. When it is SP, sort result set in the SP before >it is returned.


>hi
> (plz solve it only if u have enough time to read)
>
> So let me explain u the scenario
> i'm having 4 tables
>1. agentmaster (agent code[primary key],agent name)
>2. issuemaster (issue code[p key],issue name)
>3. mobilization (agent code,issue code,appl no,trans id[p key])
>4. dispatch (agent code, issue code, no of forms, dispatch date) [agent code + issue code + dispatch date...p key here]
>
>ok so 1 and 2 are master and 3 and 4 are transaction tables
>now table 3 contains the application mobilized by an agent for a particular issue and he could mobilized any no. of applications.
>table 4 contains the no. of forms dispatched to an agent for an particular issue on a particular date and also he could ask for additional forms.
>Now table
>3 and 4 are not related with each other I mean i cud send 1000 forms he may mobilize none, i cud send none but he cud mobilize 100...like that
>
>now i need to calculate the strike rate of agents for a particular issue.
>the strike rate = (no of forms mobilized / no of forms dispatched) * 100
>so what i did is made a SP which uses union and it returns the grouped rows.
>now i go in crystal report and grouped on issue and agent code and i GET the strike rate. very fine uptil here it worked very fine.
>-----------------------
>now in crystal report, i want to sort on strike rate(which is just a formula field).
>in my vb form I used Crystal report control's property SortFields like this
>crw1.sortfields(0)="+{MySP.@strikerate}" or crw1.sortfields(0)="+{@strikerate}"
>both statement gives error
>-----
>Any thoughts,help would be appreciated..
>
>
>Thanx for giving ur time
Vlad Grynchyshyn
vgryn@softservecom.com
The professional level of programmer could be determined by level of stupidity of his/her bugs