Focal Point
[CLOSED] Display total number of rows in header

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

March 02, 2018, 01:42 PM
Gagan Marwah
[CLOSED] Display total number of rows in header
Hello,

I would like to display the count for total number of rows in the header. Can some help me how I can achieve that or point me to another discussion that have solved the similar issue?

Thank you,
Gagan

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8
Windows, All Outputs
March 02, 2018, 02:06 PM
Mike Williams
This conversation might help
http://forums.informationbuild...241061092#8241061092


WF Version 8105
March 02, 2018, 04:37 PM
jcannavo
You could also lookup how to use READFILE in which you could create a hold file, read it, and type your count into an amper variable to be used at a later time in your header.


JC
WebFOCUS Dev Studio / App Studio
8.2.01
Windows 7
March 02, 2018, 04:41 PM
FP Mod Chuck
Gagan

Welcome to Focal Point! I hope you find this a great forum to get answers to your development questions.

I think this code will help you.

https://s9.postimg.org/h9fmkskqn/code_example.png

This message has been edited. Last edited by: FP Mod Chuck,


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
March 02, 2018, 05:15 PM
Gagan Marwah
I am not exactly sure what I would change in my text editor. I tried to make an attempt but I am not getting the right results..

Here is a snippet of what I have in my text editor

TABLE FILE servicemanagement/computersystem_processor

SUM
COMPUTERSYSTEM_PROCESSOR.COMPUTERSYSTEM.ASSET_ID_
COMPUTE R/I5 = 1 + R; NOPRINT
SUM CNT.COMPUTERSYSTEM_PROCESSOR.PROCESSOR.NAME AS 'Total CPUs'
COMPUTE cores_per_cpu/D12=COMPUTERSYSTEM_PROCESSOR.SPECIFICATIONS_PR.NUMBEROFCORES/cpuCount ; AS 'Cores per CPU'
COMPUTERSYSTEM_PROCESSOR.SPECIFICATIONS_PR.NUMBEROFCORES AS 'Total Cores'
BY COMPUTERSYSTEM_PROCESSOR.COMPUTERSYSTEM.ASSET_ID_ AS 'Server CI ID'

ON TABLE SUBHEAD
"Servers with CPU and Core Count"
"Parameters: Company &COMPANY Owner Name &OWNER_NAME"
"Report Run Date: &DATEMDYY &TOD"
"Rows: "Page of
Is this what I am suppose to have?


WebFOCUS 8
Windows, All Outputs
March 02, 2018, 06:04 PM
FP Mod Chuck
Gagen

My example used a DEFINE instead of a COMPUTE..


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
March 07, 2018, 10:56 AM
Gagan Marwah
Thanks Chuck. This worked for me.

Thank you,
Gagan


WebFOCUS 8
Windows, All Outputs