Is there a way to create an HTML list of 'My Reports' from within DevStudio? The report names should be a hyperlink to the actual report. So far I have only been able view the 'My Reports' section in a Domain Tree format and wanted to see if anyone had created a list using HTML.
Thank you,
Elizabeth CosainThis message has been edited. Last edited by: <Kathryn Henning>,
WebFOCUS 7.7.3 DevStudio, MRE
April 23, 2013, 03:38 AM
Wep5622
You can do that using the APP LIST and APP QUERY commands.
WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010 : Member of User Group Benelux :
April 23, 2013, 07:15 AM
David Glick
In release 8 we have an option to populate a control with procedure names and at runtime, the selected procedure will run.
David Glick Director WebFOCUS App Studio and WebFOCUS Developer Studio WebFOCUS Division Information Builders, Inc. Direct (917) 339-5560 Voice Mail (212) 736-6250 x3560 Fax (212) 947-5168 Email david_glick@ibi.com
April 23, 2013, 09:21 AM
Francis Mariani
I don't see how you can get a list of My Reports in a version less than v8. The APP LIST suggestion won't work because the My Reports are stored somewhere in Managed Reporting, not on the application server.This message has been edited. Last edited by: Francis Mariani,
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
April 23, 2013, 02:00 PM
ECosain
Hello,
Thank you for the quick responses.
I was able to create an HTML report (from DevStudio) that used the following url and it seems to work.
But it is in the domain tree format. I thought there may be a way to format this to hide the Standard Reports and only show My Reports in a non collapsable format.
I don't think that upgrading to version 8 is possible for us right now. But if it were, do you know where I could see a sample of this working in version 8?
Thank you,
ElizabethThis message has been edited. Last edited by: ECosain,
WebFOCUS 7.7.3 DevStudio, MRE
April 23, 2013, 02:25 PM
Francis Mariani
Could you please edit your last post and put the URL between
[CODE]
your url here
[/CODE]
tags so that we can see the proper URL?
This URL does not look like it executes a "report" - it's a link to the B.I. Dashboard tree. If it is indeed a report, please tell us how you created this from Dev Studio?
Thanks,
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
April 23, 2013, 02:49 PM
ECosain
Hello,
I updated the url on my previous post.
In DevStudio I created an HTML report and added a listbox to it. In the properties window I changed the Data type to 'Dynamic' and selected 'Other' (instead of Embedded procedure or External Procedure) and placed the url in the 'Custom Library' area.
When I run the HTML report from Managed Reporting it gives me a tree domain that shows Standard and My Reports.
Some of the code will be different for other environments but for us the only thing that will change is the username so this works for us so far.
I also changed the FILEDEF command to the following. Previous:
FILEDEF MREBASEDIR DISK &MR_BASE_DIR.EVAL\&MREBASEDIR.EVAL\&MREBASEDIR.EVAL.htm
Updated way:
FILEDEF BASEDIRUSERHTM DISK C:\ibi\WebFOCUS77\basedir\&MREBASEDIR.EVAL.htm
I have to clean it up but it seems to be giving me what I need. I thought I would post this in case this could be useful to others with the same request.
Thanks,
Elizabeth Cosain
WebFOCUS 7.7.3 DevStudio, MRE
May 10, 2013, 06:50 PM
Francis Mariani
I may have an updated-to-v7703 version of the master, I'll post it to the other thread if I do.
I'm glad this worked for you Elizabeth, and thanks for the great idea of using it for the My Reports list - I didn't think of that!
Cheers,
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