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.
I have a simple Drill down that I created using the report painter. The master report & the drill down report are nearly identical, so I copied most of the code (which I tested first) including DEFAULTs and DEFINE. I can run either of them independently without problem. They both have a USE filea AS fileb, which seems to be a problem. When the master reports executes and I select the data value for drilling down, Focus tells me it can't parse the file. If I create a clone of the Drill down and take out the USE, things work nicely. Except the report is incomplete.
I suggest you add a USE CLEAR * to clear out the USE structure in memory, just in case. An alternative may be to code USE FILEA AS FILEC in the drilldown fex, so that there is no possible conflict on the names.
Posts: 44 | Location: New York City | Registered: May 23, 2004
Read-Only Topic