You stated "SUBTOTAL" in your original posting, but you mention "SUBFOOT" in one of your replies. They are two different things.
This will not have dollar signs in the SUBFOOT (nor will it have commas, because of the original column definition for SALES):
TABLE FILE CAR
SUM
SALES/D12MC
RETAIL_COST/D10M
BY COUNTRY SUBTOTAL
BY CAR
SUBFOOT
"SUBFOOT TOTAL <ST.SALES"
BY MODEL
END
This will have dollar signs and commas, because a DEFINE is used instead of a format change:
DEFINE FILE CAR
SALESN/D10M = SALES;
END
TABLE FILE CAR
SUM
SALESN
RETAIL_COST/D10M
BY COUNTRY SUBTOTAL
BY CAR
SUBFOOT
"SUBFOOT TOTAL <ST.SALESN"
BY MODEL
END
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
August 20, 2008, 01:49 AM
Ajay kumar
Hi Francis Mariani,
This is working only for floating dollar i.e either by applying 'M' or '!D' if we use fixed dollar i.e either 'N' or '!d' , its not working.Please Clarify.
Regards, Ajay kumar.
Webfocus 714 Windows XP HTML,EXCEL,PDF,GIF
August 20, 2008, 09:37 AM
Francis Mariani
Please clarify.
Please be precise about the issue, it will save us replying back and forth. You can use the CAR file as an example table - everyone that has FOCUS/WebFOCUS should have this file.
Please read the manual, "Describing Data With WebFOCUS Language > Describing an Individual Field > The Displayed Data Type: USAGE > Extended Currency Symbol Display Options":
Reference: Extended Currency Symbol Formats
The following guidelines apply:
- A format specification cannot be longer than eight characters.
- The extended currency option must be the last option in the format.
- The extended currency symbol format cannot include the floating (M) or non-floating (N) display option.
- A non-floating currency symbol is displayed only on the first row of a report page. If you use field-based reformatting (as in the example that follows) to display multiple currency symbols in a report column, only the symbol associated with the first row is displayed. In this case, do not use non-floating currency symbols.
- Lower case letters are transmitted as upper case letters by the terminal I/O procedures. Therefore, the fixed extended currency symbols can only be specified in a procedure.
- Extended currency symbol formats can be used with fields in floating point, decimal, packed, and integer formats. Alphanumeric, dynamic, and variable character formats cannot be used.
Note: "A non-floating currency symbol is displayed only on the first row of a report page", perhaps this is what you're encountering.
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
August 21, 2008, 01:38 AM
Chirag
Hi Francis, I am facing the same issue, but i am trying to print £ sign before my total. With the above mentioned way, I could print $ sign but not £ sign. I used the format like this
Amount/D20.2!L
Please advise, how can i do this?
Sorry, I am not creating a separate thread for this. I think it belongs to the same issue.
Thanks, Chirag
7.6.11 Linux Excel, HTML, PDF
August 21, 2008, 02:00 AM
Tony A
Chirag, Ajay and Navaneeth,
Are you all working on the same project and in the same outsourcing company? It certainly sounds like it.
Perhaps you should get some collective training?
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
August 21, 2008, 04:08 AM
Chirag
Thanks Tony for your suggestion. But me, ajay and navneeth are not working on same project. I used to check forum to get insight into various tricks and tips. I saw this one too. Tried to run the same for £ sign but couldn't get success.
Thanks, Chirag
7.6.11 Linux Excel, HTML, PDF
August 21, 2008, 05:36 AM
Tony A
quote:
But me, ajay and navneeth are not working on same project
Does this imply that you are working for the same outsourcing company though?
If that's true then you still have the same problem/question (albeit across separate client accounts) and it would be worth while for your company to ensure you are adequately trained - it is unfair to you as individuals for your company to expect you to do a job for which you do not have sufficient training!
As for your pound sterling signage problem, the following sample code against GGSALES (a sample database supplied with WF) shows that you should have no problems?
TABLE FILE GGSALES
SUM DOLLARS/D12!L
DOLLARS/D12!l
BUDDOLLAR/D12M
BY REGION
BY ST
BY CITY
ON CITY SUB-TOTAL AS 'Total'
ON TABLE SET HTMLCSS ON
ON TABLE SET PAGE NOLEAD
ON TABLE SET STYLE *
GRID=OFF, SIZE=9, $
ENDSTYLE
END
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
August 21, 2008, 06:11 AM
Chirag
Tony, My problem is little bit complex. I am printing the subtotal in subfoot and output format is exl2k. I have to print the details first and then using But if i try the same with AMOUNT/D20.2M, $ sign comes quite easily there.
quote:
Sorry I don't know Ajay and Navneeth. I am not working with them.
Thanks & Regards, Chirag
7.6.11 Linux Excel, HTML, PDF
August 21, 2008, 07:01 AM
Tony A
Think outside of the box and not so blinkered.
If the request is erroring because it doesn't like ON CITY SUBFOOT "Subtotal for <CITY is <SUM.DOLLARS/D12!L" then think how you can effect the currency symbol without having to provide instream conversion (the /D12!L) -
DEFINE FILE GGSALES
STERLING/D12!L = DOLLARS;
END
TABLE FILE GGSALES
SUM STERLING
DOLLARS/D12!l
BUDDOLLAR/D12M
BY REGION
BY ST
BY CITY
ON CITY SUBFOOT
"Subtotal for City of <CITY is <SUM.STERLING"
ON TABLE SET HTMLCSS ON
ON TABLE SET PAGE NOLEAD
ON TABLE SET STYLE *
GRID=OFF, SIZE=9, $
ENDSTYLE
END
T
Edited to make it readable - because I left some residual HTML tags This message has been edited. Last edited by: Tony A,
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
August 21, 2008, 07:29 AM
Chirag
Tony, I am doing exacltly the same thing, but not getting the £ sign before subtotal. I tried to run the following code but did not get the desired result.
DEFINE FILE GGSALES
STERLING/D12!L = DOLLARS;
END
TABLE FILE GGSALES
SUM STERLING
DOLLARS/D12!l
BUDDOLLAR/D12M
BY REGION
BY ST
BY CITY
ON CITY SUBFOOT
"Subtotal for City of <CITY is <SUM.STERLING"
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET HTMLCSS ON
ON TABLE SET PAGE NOLEAD
ON TABLE SET STYLE *
GRID=OFF, SIZE=9, $
ENDSTYLE
END
Thanks for your patience and support.
Regards, Chirag
7.6.11 Linux Excel, HTML, PDF
August 21, 2008, 08:11 AM
Tony A
If that's the case, and you have support, then you need to call it in as a possible bug with 7.1.4. Use the sample code I gave above as a demonstration. Run it to HTML output in your own environment and save the resultant HTML file, also grab a screen shot.
Raise the case with IB and then follow-up with an email containing the screen shot and HTML file as attachments, quoting the case number.
For reference this works against a 7.6.2 server set-up on Windows Server 2003, but only on the first data row when using subfoot. Subsequent data rows do not have the £ symbol.
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
August 25, 2008, 05:39 PM
Bhanu
DEFINE FILE GGSALES STERLING/D12!L = DOLLARS; END TABLE FILE GGSALES SUM STERLING DOLLARS/D12!L BUDDOLLAR/D12M BY REGION BY ST BY CITY ON CITY SUBFOOT "Subtotal for City of ON TABLE PCHOLD FORMAT EXL2K ON TABLE COLUMN-TOTAL ON TABLE SET HTMLCSS ON ON TABLE SET PAGE NOLEAD ON TABLE SET STYLE * GRID=OFF, SIZE=9, $ ENDSTYLE END -EXIT
Works fine and could see the pound and $ symbols on the subtotal and todal.
August 26, 2008, 11:29 AM
Francis Mariani
The code in previous posting is not complete.
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
August 26, 2008, 11:46 AM
Tony A
... and that is because it was a cut and paste of my code which contained a couple of < characters.
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
August 28, 2008, 06:11 AM
Chirag
Hi Tony, You were right, there is some problem with 714 client. It's working fine with 762. A case has been raised with IBI. They are researching the problem.
Thanks for your help.
Regards, Chirag
7.6.11 Linux Excel, HTML, PDF
August 28, 2008, 08:03 AM
Tony A
Not a problem, it's what the Forum is all about
T
July 28, 2009, 12:19 PM
<Sandy Kadish>
This a twist for this thread:
Is there a way to have all rows formatted as, for example, P12CB, but have the subtotal and grand total lines format the same column as P12CNB. The report requester wants to show dollar signs only for the subtotal and grandtotal.
Thanks in advance - Focal Point always comes through.
July 28, 2009, 12:39 PM
Darin Lee
Not using SUBTOTAL. Subtotals and Grand Totals using ON fieldname SUBTOTAL always use the same format as numbers in that column. You can use SUBFOOT and embed ST. or TOT. fields which you have redefined to another format.
Regards,
Darin
In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat
July 28, 2009, 02:53 PM
<Sandy Kadish>
Darin -
That is what I had thought originally. Seems like a New Feature Request. The folks requesting the report prefer to avoid a subfoot.