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     [SOLVED] Send URL instead of inline report

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Send URL instead of inline report
 Login/Join
 
Master
posted
I could swear I did this before, even if it was just in an online class, but I would like to schedule a report (It's an alert, actually) to run and be emailed to a user.

However, for security reasons, I would like the report to not be in the body of the email or even attached to it. I would like a hyperlink sent in the email, such that the user would click on the hyperlink and the report would appear (From the Library, maybe?).

This report would run on a regular basis, so I suppose the report at the other end of the hyperlink would need to have a unique name.

This is probably very easy, but I have forgotten how. Is this possible or was I imagining things?

This message has been edited. Last edited by: Squatch,


App Studio
WebFOCUS 8.1.05M
Windows, All Outputs
 
Posts: 594 | Location: Michigan | Registered: September 04, 2015Report This Post
Expert
posted Hide Post
Squatch, if the distribution method is Report Library, the recipient will receive an email with a link. I don't think there any complications with this...


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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Master
posted Hide Post
Okay, thanks Francis. That does sound familiar.

My concern is that I am trying to send a report via an alert that checks for selected information every 10 minutes, and that information will only be picked up once from the data source (The data can be checked to see if it is older than 10 minutes, and if so, then that data will not be reported on again).

So my concern is that I don't want the report overwritten, which would seem to imply a quasi-random filename in the Report Library is needed.

Now, maybe the Report Library takes care of this automatically... if that is the case, then I don't have anything to worry about.

But if the file is overwritten by succeeding reports, then I am in trouble.


App Studio
WebFOCUS 8.1.05M
Windows, All Outputs
 
Posts: 594 | Location: Michigan | Registered: September 04, 2015Report This Post
Expert
posted Hide Post
Nothing gets overwritten and you can't specify a file name. Each execution creates a new Library report and send a unique link.


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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Master
posted Hide Post
Thanks! I'll give it a try this afternoon.


App Studio
WebFOCUS 8.1.05M
Windows, All Outputs
 
Posts: 594 | Location: Michigan | Registered: September 04, 2015Report This Post
Virtuoso
posted Hide Post
Pay attention to change the default which is to keep only one version in the library since you seems to have more than one...


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Report This Post
Master
posted Hide Post
quote:
Originally posted by MartinY:
Pay attention to change the default which is to keep only one version in the library since you seems to have more than one...

Not quite sure where to find that...

I have changed the Expiration date in the schedule to 7 days.

If I schedule to the Report Library, I can specify a Library Access List, but this does not result in an email to Library Access List users. An email is crucial.

I successfully ran a schedule with the output to the Report Library, but with no email with a link, I have no clue how to get to the Library.

The schedule log mentions: "Alert is triggered. Turn on the alert flag in the repository." ???

In the Distribution part of the schedule, the "Folder Location" defaults to the Repository folder I have the alert, schedule and fex in. Not sure what that means...

And to top it all off, I can't find the student training manual for the ReportCaster online class I took over two years ago...


App Studio
WebFOCUS 8.1.05M
Windows, All Outputs
 
Posts: 594 | Location: Michigan | Registered: September 04, 2015Report This Post
Expert
posted Hide Post
In this example, I have a "Private" report. On the "Options" tab I can choose to send an email. Play around with the "Access Options" on the General tab, then the "Options" tab.




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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Master
posted Hide Post
Okay, so the "Report Library" results in a Report Library file that is dumped into whatever "distribution folder" you select under Distributions when creating a schedule.

The report is always the same name; it has an icon next to the report that looks like upright books next to each other.

If you right-click on this report name, you can select "versions"... so the report is actually a sort of container that contains all the instances of that report, one for each time the schedule runs.


App Studio
WebFOCUS 8.1.05M
Windows, All Outputs
 
Posts: 594 | Location: Michigan | Registered: September 04, 2015Report This Post
Master
posted Hide Post
quote:
Originally posted by Francis Mariani:
In this example, I have a "Private" report. On the "Options" tab I can choose to send an email. Play around with the "Access Options" on the General tab, then the "Options" tab.

LOL! I misread the two tabs as "General Options"... I thought it was just a label!

Thanks again, I think that will solve my problem.


App Studio
WebFOCUS 8.1.05M
Windows, All Outputs
 
Posts: 594 | Location: Michigan | Registered: September 04, 2015Report This Post
Master
posted Hide Post
Okay, got it working... thanks everyone!

(I managed to get Francis up to 9,978 posts...)


App Studio
WebFOCUS 8.1.05M
Windows, All Outputs
 
Posts: 594 | Location: Michigan | Registered: September 04, 2015Report This Post
Expert
posted Hide Post
These are my last few working minutes. I haven't reached the magic number yet, so I may check in once in a while over the holidays.

Happy Holidays. Happy New Year.


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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Master
posted Hide Post
Awaiting F10K (Francis 10,000)...


App Studio
WebFOCUS 8.1.05M
Windows, All Outputs
 
Posts: 594 | Location: Michigan | Registered: September 04, 2015Report 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     [SOLVED] Send URL instead of inline report

Copyright © 1996-2020 Information Builders