[SOLVED] Multilingual : Label of heading ou label of subtotal
I'm building a multilingual report with DB2 Web Query and Developer Studio to edit my synonyms and change a couple of things in the webfocus report.
I think to use the multilingual function of WEB query to translate the title of columns but i'm blocked about the heading and subtotals labels.
In fact, I know it's concerning the manipulation of datas, so I'd like to know if it's possible that Webfocus retrieve me the title or the description of my field. And in reality the description or the title will be my labels...
I don't know if I'm clear ??This message has been edited. Last edited by: Kerry,
WebFocus Release : 763 OS/Platform : AS/400 (v6r1) DB2 Web Query for system i, pack service : 6
May 14, 2009, 10:09 AM
<JG>
If the required information is in a table/file extract them and populate them into variables and use something like
Table file whatever HEADING "&variable1 &variable2" print field by sort1 by sort2 on table subtotal as '&variable3' end
May 14, 2009, 12:05 PM
sullivan
Thank you for your answer
I've already seen this possibility but if I have to tranlate my labels without passed by a data retrieval. So maybe, I could put the translations directly in the Webfocus code and change my variable according to my language code.
Else, how did you do to include the result of a SQL request in a variable, for example to be used by the subtotal label?
For example:
quote:
SQL SELECT NOMLIB FROM FACT_QRY_LBLFA2 WHERE OID='00LIBT.FACOE01.037'; END
TABLE FILE FACT_QRY_LBLFA2 END
-*-SET &RESULT_requestSQL = SQL SELECT NOMLIB FROM FACT_QRY_LBLFA2 WHERE OID='00LIBT.FACOE01.037'; (Not possible but basically, it's I want to do)
TABLE FILE FACT_QRY_INTFA2 SUM FACT_QRY_INTFA2.FACT_QRY_INTFA2.MTIMPIR FACT_QRY_INTFA2.FACT_QRY_INTFA2.MTIMPSSIR FACT_QRY_INTFA2.FACT_QRY_INTFA2.MTIMPT FACT_QRY_INTFA2.FACT_QRY_INTFA2.MTFINANCE FACT_QRY_INTFA2.FACT_QRY_INTFA2.MTINTERET BY FACT_QRY_INTFA2.FACT_QRY_INTFA2.CDSOCI NOPRINT PAGE-BREAK SUBTOTAL SUM. FACT_QRY_INTFA2.FACT_QRY_INTFA2.MTIMPIR SUM. FACT_QRY_INTFA2.FACT_QRY_INTFA2.MTIMPSSIR SUM. FACT_QRY_INTFA2.FACT_QRY_INTFA2.MTIMPT SUM. FACT_QRY_INTFA2.FACT_QRY_INTFA2.MTFINANCE SUM. FACT_QRY_INTFA2.FACT_QRY_INTFA2.MTINTERET AS 'TOTAL SOCIETE' BY FACT_QRY_INTFA2.FACT_QRY_INTFA2.CDAGEN NOPRINT SUBTOTAL SUM. FACT_QRY_INTFA2.FACT_QRY_INTFA2.MTIMPIR SUM. FACT_QRY_INTFA2.FACT_QRY_INTFA2.MTIMPSSIR SUM. FACT_QRY_INTFA2.FACT_QRY_INTFA2.MTIMPT SUM. FACT_QRY_INTFA2.FACT_QRY_INTFA2.MTFINANCE SUM. FACT_QRY_INTFA2.FACT_QRY_INTFA2.MTINTERET AS 'TOTAL AGENCE' BY FACT_QRY_INTFA2.FACT_QRY_INTFA2.CDPROD NOPRINT PAGE-BREAK SUBTOTAL SUM. FACT_QRY_INTFA2.FACT_QRY_INTFA2.MTIMPIR SUM. FACT_QRY_INTFA2.FACT_QRY_INTFA2.MTIMPSSIR SUM. FACT_QRY_INTFA2.FACT_QRY_INTFA2.MTIMPT SUM. FACT_QRY_INTFA2.FACT_QRY_INTFA2.MTFINANCE SUM. FACT_QRY_INTFA2.FACT_QRY_INTFA2.MTINTERET AS 'TOTAL PRODUIT' BY FACT_QRY_INTFA2.FACT_QRY_INTFA2.NOCONT BY FACT_QRY_INTFA2.FACT_QRY_INTFA2.NOPLAN BY FACT_QRY_INTFA2.FACT_QRY_INTFA2.NOUTIL BY FACT_QRY_INTFA2.FACT_QRY_INTFA2.NOTIER AS '&RESULT_requestSQL' BY FACT_QRY_INTFA2.FACT_QRY_INTFA2.NOMTIE BY FACT_QRY_INTFA2.FACT_QRY_INTFA2.DTDDECH
...
END
Thanks in advance
WebFocus Release : 763 OS/Platform : AS/400 (v6r1) DB2 Web Query for system i, pack service : 6
May 15, 2009, 01:56 AM
<JG>
to assign a value to a variable from a file you use -READ.