Hello,

from this forum I've learned about Accordion reports. This option could be very usefull. I've build a testreport, but when I try to drill (clicking on the "+-icon"), it doesn't work:

A new IE-window is shown with address: "javascript:toggle("table1","by_10");
and title: "Can't find the server..."
In the window: "The page cannot be shown"

The code that is used:

TABLE FILE VWXAUTH0001
SUM
CLOSE
TIMEOUT
SHUTDOWN
NOREASON
TASKMAN
CRASH
OTHER
TOTAAL
AANTAL
BY WEEKNR
BY USERNAME
BY DATUM
WHERE WEEKNR GE '200801
ON TABLE SET ASNAMES ON
ON TABLE SET EXPANDABLE ON
END
-RUN

This generates a HTML-report with WEEKNRs and a "+" at the first position of each line. When the cursor hovers over a "+" in the statusline is shown:

javascript:toggle("table1","by_10")

If I look at the source of the report, I see code like (this is only an excerpt):

...
<TR ibiattrc="1" ibiattr="by" ibirwtype=1>
<TD NOWRAP ibiattrc="1" ibiattr="by">
<A href='javascript:toggle("table1","by_10");'><img border=0 ibiattr="by_10" src='/ibi_html/javaassist/icons/plus.gif'></A>
200810</TD>
<TD NOWRAP ibiattrc="2" ibiattr="by_10" STYLE="display: none; " >
<A href='javascript:toggle("table1","by_10_1");'><img border=0 ibiattr="by_10_1" src='/ibi_html/javaassist/icons/plus.gif'></A>
AB</TD>
<TD ibiattrc="3" ibiattr="by_10_1" STYLE="display: none; " >
2008/03/04</TD>
<TD ALIGN=RIGHT ibiattrc="3" ibiattr="by_10_1" STYLE="display: none; " >
4</TD>
<TD ALIGN=RIGHT ibiattrc="3" ibiattr="by_10_1" STYLE="display: none; " >
 </TD>
...
...
...
</TABLE>
<script language='javascript'>
ibigblWriteDivs();
</script>
</BODY>
</HTML>

As I am no expert on Java, I hope somebody can explain me what's wrong here.
I don't think it has to do with the data, so I didn't use the CAR data.

Ton

quote:

A new IE-window is shown

Ton,

It shouldn't open a new window, it should just expand the section to which the link relates. Are you right clicking to open in new window?

Oh, and it's JavaScript not Java. JavaScript and Java are two different beasts.

T

This message has been edited. Last edited by: Tony A,

Tony A, you're right: It shouldn't open a new window.

My mistake, in the code before there was the line:

SET TARGETFRAME=_BLANK

I've deleted this line.

But now when I drill on the +, my IE-session gets blocked (nothing else happens). I have to kill the IE-session with the Task manager.

Windows gives the notification:
"This program is not responding ..."
and I have to use the "End now"-button.

Ton

Ton,

Try this code to see if you get the same problem -

APP PREPENDPATH IBISAMP
TABLE FILE CAR
SUM RCOST
    DCOST
 BY COUNTRY
 BY CAR
 BY MODEL
ON TABLE SET HTMLCSS ON
ON TABLE SET PAGE NOLEAD
ON TABLE SET EXPANDABLE ON
ON TABLE SET STYLE *
  SIZE=9, GRID=OFF, $
ENDSTYLE
END

T

Tony A,

the CAR-example works!

My own example doesn't. I've tried some variations, but no ...

Question: can it be that the masterfile has to have more than 1 segmentname?

CAR.MAS has 7 segment.
VWXAUTH0001.MAS has only 1.

Ton

Ton,

Shouldn't have any affect at all.

With it being single segment, you can't have the dreaded "testing in independant sets of data" error.

What effects are you getting now, since you've removed the target frame code?

T

Hello,

I've got results now. It wasn't a matter of not working but of not performing. The data I retrieve is more than 30000 records, in 3 levels. When I drill on the +-sign it takes minutes to have results (which I mistakingly interpreted as hanging of Internet Explorer).

Using an indexed FOCUS HOLD-file does not improve the performance.

Does anybody know:
1 How I can improve the performance?
2 If this can not be done, then what number of records is the maximum to give reasonable performance?

Ton

Ton,

This is difficult question to answer. It is not just the number of rows, but also the number of columns, that has an effect on accordion performance, the granularity of the data and the level at which you are opening also has an effect.

Accordion reports operate within the browser and do not return to the server to get any data, so the performance is down to how javascript effectively handles the HTML DOM. IE is pretty poor, Firefox a lot faster. I believe that IE also has a couple of bugs that will stop the programmers from utilising the theoretically best approach with javascript.

So it is very much try your report and find the best approach, sometimes it is a balance between accordion and drill down.

I would probably not use anything much in excess of 1000 rows of 20 columns for 'instant' results. You say you have 30000 rows at 3 levels, which is large and with large granularity, so performance will be a real issue. In these circumstances it may be better and faster to return to the server and get the data.

Tony A and Alan B,

thank you for your excellent answers.

At this moment I've no more questions on this subject.

Ton