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     Report Assistant & Editor

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Report Assistant & Editor
 Login/Join
 
Guru
posted
I have a user that is using RA to create some reports. I had to restore the user's reports and now they open up in the Editor instead of RA.

I did find some other posts about this and to make sure the first 2 lines have the following lines in there (which it does), so I am not sure why it will not open in RA. Is there something else in here that maybe RA does not understand?

Thanks for the help.

-* HTML Tool
-* Created by Report Assistant
-* FF Line do not change this line! Field Name
-* FF Line do not change this line! Alias
-* FF Line do not change this line! Format
-* FF Line do not change this line! Segment
-* FF Line do not change this line! UseAlias
-* FF Line do not change this line! displayTree=0
-* J001 J001
-* J002 J002
-* J004 J004
-* J005 J005
JOIN
INNER
TBLEMP.TBLEMP.EMP_PK
IN TBLEMP
TO MULTIPLE TBL_TMX_ATTEMPT.TBL_TMX_ATTEMPT.EMPFK
IN TBL_TMX_ATTEMPT TAG J001
AS J001
END
JOIN
INNER
J001.TBL_TMX_ATTEMPT.ACTIVITYFK
IN TBLEMP
TO MULTIPLE TBL_TMX_ACTIVITY.TBL_TMX_ACTIVITY.ACTIVITY_PK
IN TBL_TMX_ACTIVITY TAG J002
AS J002
END
JOIN
INNER
J002.TBL_TMX_ACTIVITY.ACTIVITYLABELFK
IN TBLEMP
TO MULTIPLE ACTLABEL.ACTLABEL.ACTLABEL_PK
IN ACTLABEL TAG J004
AS J004
END
JOIN
INNER
TBLEMP.TBLEMP.EMP_PK AND J001.TBL_TMX_ATTEMPT.ACTIVITYFK
IN TBLEMP
TO MULTIPLE CFR_TRANSCRIPT_ESIGNATURE.CFR_TRANSCRIPT_ESIGNATURE.SIGNER_FK AND CFR_TRANSCRIPT_ESIGNATURE.CFR_TRANSCRIPT_ESIGNATURE.ATTEMPT_FK
IN CFR_TRANSCRIPT_ESIGNATURE TAG J005
AS J005
END
TABLE FILE TBLEMP
SUM COMPUTE
Total_Completes/D12.2 = J001.TBL_TMX_ATTEMPT.COMPLETIONSTATUS;
BY J002.TBL_TMX_ACTIVITY.ACTIVITYNAME AS 'Course Name'
BY J001.TBL_TMX_ATTEMPT.COMPLETIONSTATUS AS 'Completion Status' NOPRINT
WHERE (J004.ACTLABEL.ACTLABEL_NAME EQ 'Curriculum')AND (J001.TBL_TMX_ATTEMPT.COMPLETIONSTATUS EQ 1);
HEADING
"Cert Completes with E-Signer and Date"
ON TABLE SET STYLE *
-INCLUDE IBFS:/CFG/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENDefaultTableStyle.sty
TYPE=REPORT,
   GRID=ON,
   TITLETEXT='Cert Completes with E-Signer and Date',
 $
TYPE= HEADING,$
TYPE=DATA, COLUMN=Total_Completes,
  FONT=Tahoma,
 $
TYPE=TITLE, COLUMN=Total_Completes,
   FONT=Tahoma,
 $
ENDSTYLE
ON TABLE SET HTMLCSS OFF
ON TABLE SET AUTODRILL ALL
ON TABLE SET OLAPPANE TOP
ON TABLE ROW-TOTAL
ON TABLE COLUMN-TOTAL
END
-* End Report Assistant 


WebFOCUS 8.1.05
 
Posts: 496 | Registered: January 04, 2008Report This Post
Guru
posted Hide Post
Hi,

Remove the where clause from the file using the editor,save it and then open it again with RA and tell me if it opens .

Regards


WebFocus 7.6.5
AND WebLogic server as web server
sql2005 as database server
 
Posts: 273 | Location: Europe | Registered: May 31, 2007Report This Post
Guru
posted Hide Post
Why would it not like the WHERE clause?


WebFOCUS 8.1.05
 
Posts: 496 | Registered: January 04, 2008Report This Post
Guru
posted Hide Post
Does it open in RA?


WebFocus 7.6.5
AND WebLogic server as web server
sql2005 as database server
 
Posts: 273 | Location: Europe | Registered: May 31, 2007Report This Post
Guru
posted Hide Post
No, but removing the WHERE clause allows the report to run now.


WebFOCUS 8.1.05
 
Posts: 496 | Registered: January 04, 2008Report This Post
Guru
posted Hide Post
Hi,

In RA sometimes, the user is warnned about some errors and instead of dealing with them they just ignore them. In this case one the report is save it will not open any more in RA and it will require the administrator intervention.

Regards.


WebFocus 7.6.5
AND WebLogic server as web server
sql2005 as database server
 
Posts: 273 | Location: Europe | Registered: May 31, 2007Report 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     Report Assistant & Editor

Copyright © 1996-2020 Information Builders