July 02, 2013, 05:50 AM
info4palsHow 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 !
July 02, 2013, 06:44 AM
Ram Prasad EHi,
Get the values passed into amper variable each time you enter into the loop. Then use TITLETEXT option in stylesheet.
Thanks,
Ram
July 02, 2013, 09:57 AM
Francis MarianiJust 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