 |
|||||
|
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. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| Interactive Report | Login/Join |
| Gold member |
I have a webfocus report that I want to be able to click on a link and make notes about a particular set of data and save the notes. What is the best way to do this? Someone suggested using ASP.NET, but how would I do this? Version: 8.0.0.6 Windows platform All output formats will probably be used. | ||
|
| Expert |
There are many ways, yes. My suggestion, apart from ASP, JSP, etc would be to have the drill down to the notes, call a FEX that uses modify to write the notes somewhere, but this has limitations. How large are the notes, and what will they be stored in ? Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Gold member |
Notes could be lengthy, and will be written to an oracle database. Version: 8.0.0.6 Windows platform All output formats will probably be used. | |||
|
| Expert |
Other options, WebFOCUS wise, could be issueing SQL Insert/Updates. How large ? I hope it isn't from a Cut and Paste, I've experienced this before, and from Word you get nasty hidden chars in the paste. Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Expert |
Do you need to capture notes per report row, or one note for the whole report. If it's one note for the whole report, it shouldn't be too difficult to create an HTML form that is placed before or after the report, with a button to trigger a second WebFOCUS program to update the Oracle table with the information entered. 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 | |||
|
| Gold member |
I need to capture notes per row. Also, I need the ability to check of 1 to many rows and apply a note to the rows that where checked. Version: 8.0.0.6 Windows platform All output formats will probably be used. | |||
|
| Expert |
I think you will have to hone your non-WebFOCUS skills with this one... 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 | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 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 |