Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Adding a Group Counter
Message
From
22/09/2006 09:09:08
 
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:
01156373
Views:
20
>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?

Sorry, I overlooked that pert of yr message.
Perhaps something can be done with report variables but I don't hv anything ready made. Folow the tread Sergey gave you, you might strike some idea that
resolves your problem.
Since you are letting user customise reports, then maybe you should
consider making one release in the future with completely precalculated
cursors as I suggested before.


>
>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
*****************
Srdjan Djordjevic
Limassol, Cyprus

Free Reporting Framework for VFP9 ;
www.Report-Sculptor.Com
Previous
Reply
Map
View

Click here to load this message in the networking platform