As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at email@example.com and provide your corporate email address, company, and name.
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
SELECTX AS ''
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;
-SET &K = 10000;
-REPEAT :Loop_PPAP13 &Late_cnt.EVAL TIMES
BY AA&K.EVAL AS '&PPAP_Head&K.EVAL'
-SET &K = &K + 10000;
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 ''
Once 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!
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
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004