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     Problem testing drill downs

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Problem testing drill downs
 Login/Join
 
Platinum Member
posted
Hi all,

I am developing a report that has many drill downs into a detail report.

When testing this report I find that if I click on a drill down that I have already clicked on once before, the browser just gives me the results from the previous click.

For example I received an error message when clicking on a drill down link for the first time. I then corrected the report that I am drilling down to. Then when I go back to drill down on my data again, instead of running the corrected fex it just instantly gives me the error message again.

It seems that the only way to test the new code, is to re-run the calling report and click on a drill down that I have not yet clicked on. If I click on one I have used before it just pulls the last results from memory.

I have tried clearing my cache (Ctrl-F5) but this doesn't work. Any ideas?

Thanks


WebFocus 765. iSeries v5r4
 
Posts: 175 | Location: England | Registered: April 11, 2006Report This Post
Platinum Member
posted Hide Post
We use a random number in the drill-down parameters to avoid this. The way IE (and I'm assuming many other browsers) work is that if it sees a url string that it's already been to (that hasn't expired) then it will just pull that from cache. You could go and fiddle with your browser settings, but that only helps you, not all your customers.

So, to avoid this, make the URL to the drill-down different every time you run the "parent" report. As I said, we use a random number.

Somewhere in your "parent" report, have the following set command to generate the random number.
-SET &RANDOM = RDUNIF(D5) * RDUNIF(D5) * 10000;


and then in the drill-down, add the random value as a parameter -- note that the drill-down report doesn't have to have that as an actual amper variable -- you're simply making the url different.

FOCEXEC=app/reportfi(x=&x ...more parms... RANDOM='&RANDOM'),



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
 
Posts: 230 | Location: Wichita, KS | Registered: May 27, 2005Report This Post
Platinum Member
posted Hide Post
Thanks Trav, thats worked a treat! Good One


WebFocus 765. iSeries v5r4
 
Posts: 175 | Location: England | Registered: April 11, 2006Report This Post
Virtuoso
posted Hide Post
Smart solution Trav....
I always hit F5 (refresh) but if the drill down opens a PDF or Excel file that F5 does not work.

I have to build this in a lot of applications...




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
Guru
posted Hide Post
Please explain to me how this supposed to work because I haven't grasp the idea of Trav's solution.

If every time a new value is given to &RANDOM in the drill-down fex will have a new webpage, the same should apply to my current drill-down fex(I have not yet apply this techque):
Say the parameters consists of one column value and one &variable from HTM prompt. During design time, I plugged in some dummy values to the parameters and ran the fex as I coded it. At the end, those dummy values are removed. Everything (seemed?) working properly, until I selected the column value same as the dummy value I set before, with &variable has different value, the old page was displayed!

What about TARGET = '_blank' when defining the drill-down, will it give you a new window every time? What makes it different that &RAMDON and my &variable?

Thanks

Hua


Developer Studio 7.6.11
AS400 - V5R4
HTML,PDF,XLS
 
Posts: 305 | Location: Winnipeg,MB | Registered: May 12, 2008Report This Post
Guru
posted Hide Post
Hi Hua,

You are correct that there will be no caching if you are passing a unique combinations of variables. The problem is that it is possible to drill UP, which is where you go to a report that you have previously seen. It is likely that IE will try to help you by displaying whatever is in the browser cache, which does not always work. By including a random number, it will always re-generate the report from scratch, which will often solve random display issues (especially if you are building images / graphs and storing them at the file system level).


-WebFOCUS 8.2.01 on Windows
 
Posts: 318 | Location: Los Angeles, CA | Registered: November 15, 2005Report This Post
Guru
posted Hide Post
Moogle,

Thank you for your explainations. I'll keep this solution in mind when coding drilldowns.

Have a nice day!

Hua


Developer Studio 7.6.11
AS400 - V5R4
HTML,PDF,XLS
 
Posts: 305 | Location: Winnipeg,MB | Registered: May 12, 2008Report 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     Problem testing drill downs

Copyright © 1996-2020 Information Builders