 |
|||||
|
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 report formatting | Login/Join |
| <Kev> |
I'm trying to generate a report in Excel format. My requirement is that the report needs to start at a fixed row and column (say ``C9'') and it should retain whatever existed originally in the template before the row on which output begins. Is there any way to do this? Thanks!This message has been edited. Last edited by: Kerry, | ||
|
| Virtuoso |
Check out Excel templates in the documentation Regards, Darin In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat | |||
|
| <Kev> |
Can you please point me to any available in online documentation? Thanks! | ||
|
| Expert |
The doc link is in the upper right corner of this page. Ginny --------------------------------- Prod: WF 7.7.01 Dev: WF 7.6.9-11 Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google | |||
|
| <Kev> |
Unfortunately, I can't find anything for my case. Basically what I want to find out is - can I control what {row,column} output gets printed on? Thanks! | ||
|
| Expert |
To move the report content down x rows have x lines in your header. To move it y columns to the right have y empty fields in your output. Open your mind to what you want to do and it will become obvious how to achieve it. As for leaving current content untouched then Darin has already given you a pointer to your solution, excel templates. Understand that in a template file, if you target sheet number 2 (for instance) then that sheet is "deleted" and your report is created in that location (as a new sheet essentially) so you should see why existing content gets wiped out. T
| |||||||||
|
| Expert |
In addition, the Excel template's sheet 1 is the one that should have the existing data on. Cells in sheet 1 can refer to cells in sheet 2 - this is the way you get the WebFOCUS data in sheet 2 to display in sheet 1 - the one the user will use. There is a method to suppress the sheet tabs so that the user doesn't know that there are multiple sheets, but I don't like using that. Documentation on Excel Templates: Creating Reports With Graphical Tools > Styling Reports With the Report Painter > Using Excel Templates Creating Reports With WebFOCUS Language > Choosing a Display Format > Using Excel Display Formats: Excel 2000, Excel 97, Excel > Creating Excel Templates How to hide the worksheet tabs in EXL2K Template output? Francis  Give me code, or give me retirement. In FOCUS since 1991 Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server | |||
|
| <Kev> |
+1 for Line 1! I think I can figure out what needs to be done now. Thanks a lot! | ||
|
| Expert |
Give a man a fish and he'll eat well for one day. Give him a boat and rod ...... You know the rest  T
| |||||||||
|
| 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 |