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.
Is there any way of making a Reporting Object filter show up by default in Report Assistant? I can duplicate the WHERE clause and put it in the TABLE section of the Reporting Object and have the entire WHERE clause show up by default in RA, but it's not really user-friendly. We're on on 5.2.7 on IBM iSeries.
Posts: 319 | Location: Stockholm, Sweden | Registered: February 04, 2004
There isn't any way to automatically select a Reporting Object filter in Report Assistant. Alternatively to building a WHERE clause in RA, you could also build a WHERE in the Reporting Object. The WHERE created as a component of the Reporting Object will always be in effect for every report created from the Reporting Object. The end user will not be able to de-select it.
H, when you set up your Reporting Object, there is a section you click on called WHERE..and you can drop all your desired WHERE or IF statements in there. They'll be in effect for every user of that Reporting Object. if you want several types of WHERE's, set up several separate Reporting Objects, each with its own special set of WHERE's..and just name each of them cleverly..thats how we do it, anyway. The the user is selecting a different WHERE by selecting a different Reporting Object. Any help?
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003
Emma and Susannah, I know there's a WHERE section but a) I want the users to see the selection and b) I want them to be able to change the selection. The idea is to present the filter just as a sort of -DEFAULT setting and I think it would be so much nicer to show the filter name instead of core WF code.
Posts: 319 | Location: Stockholm, Sweden | Registered: February 04, 2004
Focal Point Forums 