Focal Point Banner


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 community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Why cannot run 2 times-in-a-row an Excel outfile report without closing the 1st one?

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Why cannot run 2 times-in-a-row an Excel outfile report without closing the 1st one?
 Login/Join
 
Marikaki
Gold member
posted
Hi guys,

Q: Why cannot run 2 times-in-a-row an Excel outfile without closing the 1st one?


I mean an mr application shows an htmlpage. Running the report a 1st time choosing Excel (coded EXL2K) as the outfile, lets the excel appear in a different window as requested. When I modify the report paramters for a different excel report, this request does not run. I should close the previous excel page before running the 2nd one.

What can be done on this?

Thanks for your cooperation.


Marikaki

WF 7.7.03m, MRE, BI Dashboard, DevStudio, Report Caster, Windows 7, I.E. 8/9, Apache Tomcat 6.0, Derby Output formats: Excel2K, PDF, HTML, AHTML

 
Posts: 96 | Location: Montreal, Quebec, Canada | Registered: January 20, 2010Report This Post
Waz
Expert
posted Hide Post
I believe that this is a basic issue with Excel.

Excel will only open the same named file once.

Are you running the same report twice ?

There was a post a year or two ago, that described how to names the returned XLS file, and possibly avout the issue.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
ERINP
Platinum Member
posted Hide Post
Marikaki,
You can add the TITLETEXT to the report which will name the excel report. This will remove the IBI naming convention of WFServlet and allow you to open more than one report.

 
...
ON TABLE SET PAGE-NUM OFF
ON TABLE SET BYDISPLAY ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT 'EXL2K'
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$

TYPE=REPORT,
     TITLETEXT='Name of Excel Sheet',
     GRID=ON,
     FONT='ARIAL',
     SIZE=8,
$


WebFOCUS 7.6.9

Reporting client Windows 2003 Service pack 2 using IIS and TomCat 5.5
Reporting Server OS/400 V5R4M0
Outputs: HTML, Excel, PDF, CSV, and Flat Files
 
Posts: 130 | Location: Columbus, Ohio | Registered: February 25, 2009Report This Post
Marikaki
Gold member
posted Hide Post
Thank you ERINP.

I tried it but it didn't work. Maybe your suggestion is functionnal with different reports that open different Excels? In my case, I meant that I would like to run the same report many times, just with different selections. So the TITLETEXT remains the same...? Is it possible?

Your help is very appreciated.


Marikaki

WF 7.7.03m, MRE, BI Dashboard, DevStudio, Report Caster, Windows 7, I.E. 8/9, Apache Tomcat 6.0, Derby Output formats: Excel2K, PDF, HTML, AHTML

 
Posts: 96 | Location: Montreal, Quebec, Canada | Registered: January 20, 2010Report This Post
Marikaki
Gold member
posted Hide Post
Oh! Thank you Waz.

Yes I am running the same report twice!

I tried some searchs for posts, nothing comes out corresponding to my issue.

Thank you for the information. I will do some new searches.


Marikaki

WF 7.7.03m, MRE, BI Dashboard, DevStudio, Report Caster, Windows 7, I.E. 8/9, Apache Tomcat 6.0, Derby Output formats: Excel2K, PDF, HTML, AHTML

 
Posts: 96 | Location: Montreal, Quebec, Canada | Registered: January 20, 2010Report This Post
JRLewis
Gold member
posted Hide Post
Can you make the value of TITLETEXT be variable based on the selections made on the report? Use an amper variable that indicates the report selection or selections.


WebFOCUS 8
 
Posts: 74 | Location: Gahanna, OH | Registered: September 22, 2009Report This Post
ERINP
Platinum Member
posted Hide Post
Marikaki,
In the instance of running the exact same report with different parameters this will not work. Unless you can create an amper variable for the TITLETEXT based on the parameters chosen in the report to create a concatenated string of the parameters chosen and use that as the naming convention for the TITLETEXT. This would work as long as the same parameters are not chosen for the output.

ERINP


WebFOCUS 7.6.9

Reporting client Windows 2003 Service pack 2 using IIS and TomCat 5.5
Reporting Server OS/400 V5R4M0
Outputs: HTML, Excel, PDF, CSV, and Flat Files
 
Posts: 130 | Location: Columbus, Ohio | Registered: February 25, 2009Report This Post
ERINP
Platinum Member
posted Hide Post
Keep in mind that Excel has limitations for the TITLETEXT: Excel limits the length of worksheet titles to 31 characters. The following special characters cannot be used: ':', '?', '*', and '/' when creating the amper variable for the TITLETEXT.

ERINP


WebFOCUS 7.6.9

Reporting client Windows 2003 Service pack 2 using IIS and TomCat 5.5
Reporting Server OS/400 V5R4M0
Outputs: HTML, Excel, PDF, CSV, and Flat Files
 
Posts: 130 | Location: Columbus, Ohio | Registered: February 25, 2009Report This Post
Marikaki
Gold member
posted Hide Post
Thanks for the comment.

But I am really far from that since I am so green in webfocus that I can't figure out how to vary an amper variable. I mean vary because for each run I want a different titletext to get different open Excel pages.


How would you code it to get different titletext each time the report runs?

Examples: titletext1, titletext2, titletext3,...

Thank you for your help.


Marikaki

WF 7.7.03m, MRE, BI Dashboard, DevStudio, Report Caster, Windows 7, I.E. 8/9, Apache Tomcat 6.0, Derby Output formats: Excel2K, PDF, HTML, AHTML

 
Posts: 96 | Location: Montreal, Quebec, Canada | Registered: January 20, 2010Report This Post
ERINP
Platinum Member
posted Hide Post
Marikaki,
How many different parameters do you have for this report?
If you have logic in your program that builds a WHERE statement or a BY field based on the &var then you have a start.
If you know what can be selected then create a list of those choices (&vars). I'm sure you have logic that says if &var selected then &var else FOC_NONE or something along those lines. With that being said then all you need to do is create a COMPUTE field for those selections. Something like:
 COMPUTE &var1_Text/A10 = If &var1 NE FOC_NONE then &var1 ELSE '';
COMPUTE &var2_Text/A10 = If &var2 NE FOC_NONE then &var2 ELSE '';
COMPUTE &var3_Text/A10 = If &var3 NE FOC_NONE then &var3 ELSE '';
COMPUTE TITLE_TEXT/A31 = &var1 | &var2 | &var3;

Then simply use the TITLE_TEXT for the TITLETEXT. Something like:
TYPE=REPORT,
TITLETEXT=TITLE_TEXT.EVAL, -* may need '' around it
GRID=ON,
FONT='ARIAL',
SIZE=8,


WebFOCUS 7.6.9

Reporting client Windows 2003 Service pack 2 using IIS and TomCat 5.5
Reporting Server OS/400 V5R4M0
Outputs: HTML, Excel, PDF, CSV, and Flat Files
 
Posts: 130 | Location: Columbus, Ohio | Registered: February 25, 2009Report This Post
Marikaki
Gold member
posted Hide Post
Great!

Because I'm having my vacations next week, I will look at it hopefully tomorrow or friday if time permits.

Thak you very much. It is a good start.


Marikaki

WF 7.7.03m, MRE, BI Dashboard, DevStudio, Report Caster, Windows 7, I.E. 8/9, Apache Tomcat 6.0, Derby Output formats: Excel2K, PDF, HTML, AHTML

 
Posts: 96 | Location: Montreal, Quebec, Canada | Registered: January 20, 2010Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Why cannot run 2 times-in-a-row an Excel outfile report without closing the 1st one?

Copyright © 1996-2020 Information Builders