Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Adding a Group Counter
Message
 
To
22/09/2006 03:11:55
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP1
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01156251
Message ID:
01156351
Views:
28
Thanks. Yes I know I could do it via a cursor in VFP, but in this case I want to avoid changing the exe because the application was already released. Instead I'm trying to accomplish this by editing the existing report. So you don't think there is a way to do this with standard FRX functions?

Mon


>
>Hi Mon,
>
>There is few solutions (that I know/use) to show counts at group header levels but none using standard frx functinality.
>
>1. You can prepare (preprocess) cursor with all counts already in place and then just expose those counts (tmp cursor fields) via ordinary report expressions at group levels.
>
>2. For your case where is only one count that needs to be presented, you can also use simple UDF to accomplish this.
>From ordinary report expression placed in group header, you simply call
>your UDF - wich then returns that count value.
>Hence, it is better to apply that function on tmp cursor - COPY of the one you are reporting, then on main report alias itself.
>For speed purposes on that cursor/copy you can add tmp index tag(s) as per your convinience.
>
>
>
>function StudentsPerTutor
>lparameters nTutorId
>.
>blah blah
>.
>return nStudentCount
>
>
>*In report expression (from grp Header) you wil put simply call to yr udf like
>
>=StudentsPerTutor(Sign-ins.TutorId)
>
>
>
>HTH
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform