 |
|||||
|
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 |
| Report Information Storage | Login/Join |
| Silver Member |
Hi all! Anyone know where information (properties) for individual reports are stored on the report server? I know where to find the reports and can run them from the MRE or ReportCaster but where does the MRE get/store the properties (name, filename, date, etc.)? I'd like to create a dynamic list of reports that is displayed on an ASP page. Anyone have any ideas? Thanks! A Aaron M Reiff Prod - WebFocus 7.66 Prod - ReportCaster 5 Win Server 2K/ISAPI/MSSQL Server 2K -------------------- Test - WebFocus 7.66 Win Server 2003/TomCat/MSSQL Server 2K -------------------- Dev - WebFocus 7.66 Win Server 2003/TomCat/MSSQL Server 2K | ||
|
| Guru |
If you are talking about MRE reports, the information is stored in an htm file in basedir. Go to the domain in MRE, and look at its properties to determine its physical name. Then look for an htm file with that name. (Prod: WebFOCUS 7.7.03: Win 2008 & AIX hub/Servlet Mode; sub: AS/400 JDE; mostly Self Serve; DBs: Oracle, JDE, SQLServer; various output formats) | |||
|
| Silver Member |
Thanks! I found the htm file but am wondering where the properties info comes from - when the file name is right-clicked. Is this part of the java front-end on the MRE? Aaron M Reiff Prod - WebFocus 7.66 Prod - ReportCaster 5 Win Server 2K/ISAPI/MSSQL Server 2K -------------------- Test - WebFocus 7.66 Win Server 2003/TomCat/MSSQL Server 2K -------------------- Dev - WebFocus 7.66 Win Server 2003/TomCat/MSSQL Server 2K | |||
|
| Platinum Member |
Actually all of those properties are in that same file on the same line as the report. Try modifying the properties of one of your reports and looking at the difference in the htm file. Just to be clear, you have to be looking at the DOMAIN htm file. You can find this by right-clicking the specific domain folder you are looking at in Dev Studio under "Managed Reporting, Domains". Production: 7.6.6 WF Server <=> 7.6.6 WF Client <=> 7.6.6 Dev Studio Testing: <none> Using MRE & BID. Connected to MS SQL Server 2005 Output Types: HTML, Excel, PDF | |||
|
| Platinum Member |
Also, check out the following posts. There are master files included in the posts that will help you write reports off of that domain HTM file. I've used this with some pretty good luck -- pretty handy. https://forums.informationbuilders.com/eve/forums/a/tpc/...971055961#1971055961 https://forums.informationbuilders.com/eve/forums/a/tpc/...391088331#4391088331 Production: 7.6.6 WF Server <=> 7.6.6 WF Client <=> 7.6.6 Dev Studio Testing: <none> Using MRE & BID. Connected to MS SQL Server 2005 Output Types: HTML, Excel, PDF | |||
|
| Expert |
Trav, I'm glad that the Master for the MRE domain HTML file came in handy. That was an expensive freebie I put out there! 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 |