 |
|||||
|
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. | |||||
Focal Point 
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] Send URL instead of inline report
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] Send URL instead of inline report Read-Only TopicGo | Search | Notify | Tools |
| [SOLVED] Send URL instead of inline report | Login/Join |
| Master |
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 | ||
|
| Expert |
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 | |||
|
| Master |
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 | |||
|
| Expert |
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 | |||
|
| Master |
Thanks! I'll give it a try this afternoon. App Studio WebFOCUS 8.1.05M Windows, All Outputs | |||
|
| Virtuoso |
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 | |||
|
| Master |
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 | |||
|
| Expert |
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 | |||
|
| Master |
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 | |||
|
| Master |
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 | |||
|
| Master |
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 | |||
|
| Expert |
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 | |||
|
| Master |
Awaiting F10K (Francis 10,000)... App Studio WebFOCUS 8.1.05M Windows, All Outputs | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] Send URL instead of inline report
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] Send URL instead of inline reportCopyright © 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 |