Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     How to give space between fields being shown in subfoot
Go
New
Search
Notify
Tools
Reply
  
How to give space between fields being shown in subfoot
 Login/Join
 
Member
posted
Actually i want to show

1.Total of Am1,Amt2,Amt3 if month changes for particular Manager
2.Total of Amt1,Amt2,Amt3 if manager changes
3.Total no of record of particular month


Manager month serial party Amt1 Amt2 Amt3
---- ----- ----- ------- ---- ---- ----
A jan 1 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 10 10 10
A jan 2 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 10 10 10
A jan 3 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 10 10 10

A jan 3 30 30 30

A feb 1 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 10 10 10
A feb 2 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 10 10 10
A feb 3 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 10 10 10
A feb 4 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 10 10 10

A feb 4 40 40 40


A mar 1 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 10 10 10
A mar 2 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 10 10 10
A mar 3 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 10 10 10
A mar 4 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 10 10 10
A mar 5 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 10 10 10

A mar 5 50 50 50

A 12 120 120 120

B jan 1 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 10 10 10
B jan 2 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 10 10 10
B jan 3 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 10 10 10

B jan 3 30 30 30

B feb 1 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 10 10 10
B feb 2 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 10 10 10
B feb 3 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 10 10 10
B feb 4 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 10 10 10

B feb 4 40 40 40


B mar 1 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 10 10 10
B mar 2 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 10 10 10
B mar 3 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 10 10 10

B mar 3 30 30 30

B 10 100 100 100


Actually to show total as month or manager changes, i use subfoot
Could anyone help me to show serialno and reset it as month changes
and tell me how to show space between field being dispayed under subfoot
because when i use subfoot is comes on output like this

a jan 3 30 30 30

i want to give space between these fields.

Can someone help me???
n m sure it will be great help
waiting for you vaueable comment

Thanks,
Sujeet Sharma
 
Posts: 12 | Location: noida India | Registered: December 20, 2006Reply With QuoteReport This Post
Expert
posted Hide Post
in reply to your pm,

SUM ... COMPUTE SERIAL/I8=IF MANAGER NE LAST MANAGER THEN 1 ELSE IF MONTH NE LAST MONTH THEN 1 ELSE 1 + LAST SERIAL;

as for your second question, it looks as tho you do in fact have a space between your elements in your subtotal row. if you want the numeric values to be underneath their respective columns, use SUBTOTAL

Edit your profile now to say what operating systems, products, and release versions you are on.




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Reply With QuoteReport This Post
Member
posted Hide Post
Hi susannah,

your solution to put serial no,is working for me.thanks alot.
As you suggest we can use subtotal to show summed values underneath their respet columns.
I tried it.But I want to show total whose title will contain the manager name and month.If i will use subtotal,then it will show only manager name because we can subtotal on one By feild.
if i will put subtotal on both manager and month,then it will give result like this.

manager......................sum sum sum
month........................sum sum sum


but i need like

manager........month.....sum...sum...sum

thats why i used subfoot.but when i used subfoot
it came like this-

manager month sum sum sum

i found no space between them

now i want to put space between them.

can you please suggest something.

Thanks
sujeet sharma

using
winxp/webfocus
 
Posts: 12 | Location: noida India | Registered: December 20, 2006Reply With QuoteReport This Post
Virtuoso
posted Hide Post
SP/A1 = HEXBYT(160, 'A1');
SP02/A2 = SP|SP;
SP05/A5 = SP|SP|SP|SP|SP;

This creats spaces..that you can use in your subfoot..just insert as a field.


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Reply With QuoteReport This Post
Member
posted Hide Post
Thanks alot Prarie.....
its working..
 
Posts: 12 | Location: noida India | Registered: December 20, 2006Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Great.


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     How to give space between fields being shown in subfoot

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.