Focal Point
How to rename the excel sheets dynamically?(Really Urgent!!)

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/4827019136

July 02, 2013, 05:50 AM
info4pals
How to rename the excel sheets dynamically?(Really Urgent!!)
Iam passing the ID's (say 100,200,300,400,500 etc)[Multiple selections are also allowed] from the user interface/launchpage to the report(fex) and the excel report output will have output for each ID's in separate tab.100 in 1st tab ,200 in 2nd tab and so on.
Currently I have used the looping logic to place the reports on separate tab as I have used across on ID field.
Could anyone tell me how to name the sheets dynamically based on the inputs selected.This is really urgent.

Thanks a lot !


webfocus 769,windows 7,html
July 02, 2013, 06:44 AM
Ram Prasad E
Hi,
Get the values passed into amper variable each time you enter into the loop. Then use TITLETEXT option in stylesheet.

Thanks,
Ram


WebFOCUS 8.1.05
Windows
http://ibiwebfocus.wordpress.com
https://www.facebook.com/groups/ibi.webfocus/
July 02, 2013, 08:45 AM
Doug
BYTOC? . . . Please search for Excel and BYTOC (c/o Waz)
July 02, 2013, 09:57 AM
Francis Mariani
Just wanted to let you know that what's urgent for you is not urgent for us. I find it a little surprising you have two urgent issues. This particular one can be solved with a little documentation reading.


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
July 03, 2013, 01:48 PM
<Kathryn Henning>
Hi info4pals,

For issues that are urgent, you may also contact Information Builders’ Customer Support Services and open a case for assistance. You may either call at 1-800-736-6130 or access the online system at InfoResponse Online. Here is a list of information to have ready when you call: Before You Call InfoResponse Support.

Hope this helps.

Regards,

Kathryn