Hi,

I am able to get the Dollar Sign before the amount column , but how to get the Dollar sign for the Sub total and Grand totals.

Regards,
Navaneeth

Navaneeth,
It is automatic.

If you have M in the column definition, it is carried to the subtotal and grand total:

TABLE FILE CAR
SUM
SALES/D12MC
RETAIL_COST/D10M
BY COUNTRY SUBTOTAL
BY CAR
BY MODEL

END

Hi,

when I use McGuyver technique to display the totals and subtotals, it is not displaying .

Code :

ON DEPT_I SUBFOOT
"Total invoices funded for Dpt
I had to put in the $ sign in the headings


Regards,
Navaneeth

Then your formats are not correct. Did you look at what Francis posted? Do you have the M qualifier on your format?

Maybe you should post your code minus the stylesheet info.

Also please update your profile signature with your product suite, release and platform.

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

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.

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.

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

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

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

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

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

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,

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

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

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.

The code in previous posting is not complete.

... and that is because it was a cut and paste of my code which contained a couple of < characters.

T

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

Not a problem, it's what the Forum is all about

T

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.

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.

Darin -

That is what I had thought originally. Seems like a New Feature Request. The folks requesting the report prefer to avoid a subfoot.