August 21, 2017, 08:51 AM
DevBecause I have to change the text(Title and totals) to 90 Deg rotation, Because of that am using HTMLFORM with the help of CSS
August 22, 2017, 08:37 AM
jgelonaIf you are allowed, try using an excel template with an embedded macro to format. I use them for formatting, turning on filters, filtered subtotals, group borders, etc.
August 22, 2017, 10:36 AM
DevWe have to figure it out without macro!
August 22, 2017, 05:11 PM
DougTry using FORMAT XLSX with styling / without an embedded macro.
Here's a FocalPoint link, Search for "excel style rotate title":
Vertical column title to Excel . Check it out.
August 23, 2017, 08:36 AM
DevHi,
Sorry I might share my table request file.. May be this will give you all in more clear.
I have both BY and Across columns, BY alias name we can know it is static. but across columns it will be quiet difficult (even we can hold the across value and load it line by line as a variable). but the think is How my value's are loading alpha to scientific form?
ABLE FILE HMRD7
SUM
SELECTX AS ''
CUR_MI_F NOPRINT
BY SORT1 NOPRINT
BY HIGHEST DLVRBL_PLATN_Y NOPRINT
BY ITEM_A AS 'S.No'
BY APQ008X AS 'PMT'
BY APQ01TE_N AS 'Supp'
BY APQ10_C AS 'Code'
BY APQ20STAT_X AS 'Status'
BY NTEI AS 'Count'
BY APQ20RT_N AS 'Comm'
BY NO_OPEN AS 'Open'
BY COMMMS_DEL AS 'Steps'
BY SCH_DLVRBL_ED_CMPLTN_Y AS ' to Green'
BY APQ01TING_C AS 'Verfication'
BY S_MGR AS 'S Manager'
BY APQ0_CDS_D AS 'Sneer'
BY LNG AS 'Lneer'
BY LEYER AS 'Lyer'
-SET &K = 1;
-REPEAT :Loop_visits13 &Visits_cnt.EVAL TIMES
BY AVISIT&K.EVAL AS '&Visits_Head&K.EVAL'
-SET &K = &K + 1;
-:Loop_visits13
-SET &K = 10000;
-REPEAT :Loop_PPAP13 &Late_cnt.EVAL TIMES
BY AA&K.EVAL AS '&PPAP_Head&K.EVAL'
-SET &K = &K + 10000;
-:Loop_PPAP13
BY DUMM1 AS 'Direct,sted Date'
BY DUMM2 AS 'Meeting, Summary/Notes'
BY VISIT_VAL NOPRINT
ACROSS DLVRBL NOPRINT
ACROSS APE_C NOPRINT
ACROSS PGN_DT AS ''
ACROSS BURG NOPRINT
ACROSS COLOR_VAL NOPRINT
ACROSS DLV_X AS ''
August 23, 2017, 09:11 AM
Tony AOnce the data stream has left WebFOCUS, the display of your "report" is down to the application in which it is displayed - in your instance MS Excel.
So you should understand how MS Excel interprets any data that it is given as that is where your answer will lie.
E.g. If you wanted a text value not to be re-interpreted by MS Excel then you would probably prefix it with a single quote - doing that in WebFOCUS will then see MS Excel happily displaying the single quote as well!!
Remember that Microsoft thinks it knows better than you as regards what you want - or is it trying to be helpful? Jury is still out!
T
August 24, 2017, 05:53 AM
DevTony its true what you said.
Why the same MS Excel is not thinks better while we use EXL2K, XLS & XLSX formats!
Why it is truly behave while we use HTMLFORM XLS?