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.
Join the TIBCO Community TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.
From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
Request access to the private WebFOCUS User Group (login required) to network with fellow members.
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at firstname.lastname@example.org for further assistance. Reference the community FAQ to learn more about the community.
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