Newbie.

[mbehna]

I have a report where there is a detail and summary - the latter printing on a separate page.

The user can request either detail report which includes summary or summary only.

How do I create such a report? I thought about using different frames but have no idea whether I can suppress the printing of one frame and whether the idea has any merit.

This is my first oracle report. Using Report Builder 6.0.8.12.2 on Windows...

And BTW, thanks in advance to all who reply.

 

[nagornyi]

You are absolutely right. Put details and summaries in separate frames. You will need PL/SQL code in the format triggers of those frames. The code (between begin and end) be something like (for detail frame):

if _det_or_sum_parameter = 'DETAIL' then return true;
else return false;
end if;

The same idea for the summary frame.