Focal Point
how to count records using Report Assistant

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7631043372

February 25, 2008, 02:32 PM
<akilayko>
how to count records using Report Assistant
I hope all is well with everyone.

Need help in learning how to count records based on a selection criteria using Report Assistant.

Thank you.
February 25, 2008, 03:25 PM
Leah
I don't have report assistant up at the moment, but if you are just wanting a simple count based on the 'BY' phrase(s) on the selected data, you 'SUM' the field, then under field options you can set the 'SUM' to a count of the field.


Leah
February 25, 2008, 04:49 PM
FrankDutch
Akilayko

Would you upgrade your signature so we know your version and applications.
Some training might help, since this is very basic.

TABLE FILE CAR
SUM CNT.MODEL
BY COUNTRY
END





Frank
prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

February 25, 2008, 05:35 PM
Glenda
WOOHOO!

That's what I came up with too. But I didn't post it because I thought I must have misunderstood what was wanted.

Training is not necessary for this code.....just crack open the manuals.


Glenda

In FOCUS Since 1990
Production 8.2 Windows
February 25, 2008, 05:41 PM
Prarie
But.... Winkthe question was doing it in the Gui...


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
February 25, 2008, 09:54 PM
Anatess
In Report Painter, right-click on the field you want to count (must be a SUM field) and click on Options... choose the General tab and click on the Prefix drop-down box. CNT should be one of the things you can pick among others.


WF 8.1.05 Windows
February 26, 2008, 09:15 AM
Glenda
What's GUI? Wink


Glenda

In FOCUS Since 1990
Production 8.2 Windows
February 26, 2008, 09:16 AM
Leah
I suppose the question is really, are you doing this under MRE where Report Assistant is used, or Developer Studio using Report Painter. Giving a code example does not answer the original question, probably should have asked the above before I did my answer. Some users of the tool can't do code, they may be limited to reporting objects under MRE. Groannnnnn.


Leah
February 26, 2008, 11:00 AM
Anatess
GUI - Generally Useless and Idiotic

ooops!

nah. I'm a big GUI fan... Note, GUIs are only as good as the programmers who wrote them.

Big Grin


WF 8.1.05 Windows
February 26, 2008, 11:09 AM
Tony A
We're lucky the text is not in Russian then Wink

GUI - The mess that's left at the bottom of a dumpster from food waste Frowner

T


In FOCUS
since 1986		WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
February 26, 2008, 11:37 AM
Glenda
LOL

Don't get me wrong. GUI is greate as long as the query you want to write is simple. Anything more complicated and it doesn't work.

I out grew GUI before I even knew it existed.


Glenda

In FOCUS Since 1990
Production 8.2 Windows
February 26, 2008, 01:18 PM
Leah
quote:
akilayko



Did you ever get the answer you needed. Not to keep the silliness going too much more, but GUI, gum under insole Music


Leah
February 27, 2008, 09:49 AM
PBrightwell
In the singles world it is Geographically Undersirable Individual.


Pat
WF 7.6.8, AIX, AS400, NT
AS400 FOCUS, AIX FOCUS,
Oracle, DB2, JDE, Lotus Notes