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
Best Luck..
Nilesh