 |
|||||
|
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
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 community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| [SOLVED] Excel BYTOC Tab names | Login/Join |
| Platinum Member |
Hi, In the following code, I want the tab names to be exactly as defined, but they keep getting renamed or shortened to Additional Data Processing(1),etc. It is a compound report and is there a way to not have exccel change the names. Any help is appreciated. Thanks.
DEFINE FILE CAR
MODEL1/A100 = IF BODYTYPE EQ 'CONVERTIBLE' THEN 'Additional Data Processing (A)'
ELSE IF BODYTYPE EQ 'COUPE' THEN 'Additional Data Processing (B)'
ELSE IF BODYTYPE EQ 'HARDTOP' THEN 'Additional Data Processing (C)'
ELSE IF BODYTYPE EQ 'ROADSTER' THEN 'Additional Data Processing (D)'
ELSE 'Additional Data Processing (E)' ;
END
TABLE FILE CAR
PRINT *
BY MODEL1
ON TABLE PCHOLD FORMAT XLSX BYTOC OPEN
END
TABLE FILE CAR
PRINT *
ON TABLE PCHOLD FORMAT XLSX CLOSE
END
This message has been edited. Last edited by: FP Mod Chuck, App Studio Version 8202 windows Platform SQL Server 2008/2012 | ||
|
| Expert |
25 characters max for Tab name, Microsoft limitation, not WF... Tom Flynn WebFOCUS 8.1.05 - PROD/QA DB2 - AS400 - Mainframe | |||
|
| Platinum Member |
It is 30 char, I can edit the sheet and write the name App Studio Version 8202 windows Platform SQL Server 2008/2012 | |||
|
| Platinum Member |
and if you take out the second car report , it will give full name on the tabs, which is really driving me crazy. App Studio Version 8202 windows Platform SQL Server 2008/2012 | |||
|
| Virtuoso |
I have a feeling the values are not unique enough to the left of the ( and it's renaming them. I tried this instead and it works. Not sure if that's an acceptable solution but it sorta explains what's happening.
DEFINE FILE CAR
MODEL1/A100 = IF BODYTYPE EQ 'CONVERTIBLE' THEN '(A) Additional Data Processing'
ELSE IF BODYTYPE EQ 'COUPE' THEN '(B) Additional Data Processing'
ELSE IF BODYTYPE EQ 'HARDTOP' THEN '(C) Additional Data Processing'
ELSE IF BODYTYPE EQ 'ROADSTER' THEN '(D) Additional Data Processing'
ELSE '(E) Additional Data Processing' ;
END
TABLE FILE CAR
PRINT *
BY MODEL1
ON TABLE PCHOLD FORMAT XLSX BYTOC OPEN
END
This message has been edited. Last edited by: BabakNYC, WebFOCUS 8206, Unix, Windows | |||
|
| Platinum Member |
No, I do not have flexibility with the names. So back to the original question. It is really not a question of length, it truncates it for no reason. App Studio Version 8202 windows Platform SQL Server 2008/2012 | |||
|
| Virtuoso |
Perhaps you should call IB tech support and see if they have a solution here. WebFOCUS 8206, Unix, Windows | |||
|
| Platinum Member |
I figured out a way to do this. I have replaced BYTOC with GO TO looping and creating each tab. Thanks for the sugestions App Studio Version 8202 windows Platform SQL Server 2008/2012 | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |