[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1496
  • Last Modified:

A Simple Oracle Report Builder Problem

lets say i have a reportdesign like

-----------master group Frame
XXXXX XXXXX
-----------detail group Frame
XXXXX XXXXX   VALUE
----------end detail
                      [TOTALVALUE]
XXXXX XXXXX
----------end master

the records in the detail can have various heights,
so that one master can spaned over multiple pages

now i want to have

-----------master group Frame
XXXXX XXXXX
                      [TRANSFER VALUE PREVIOUS PAGE]
-----------detail group Frame
XXXXX XXXXX   VALUE
----------end detail
                      [INTERMEDIATE TOTAL VALUE]
                      [TOTALVALUE]
XXXXX XXXXX
----------end master

whereas
[TRANSFER VALUE PREVIOUS PAGE] should be only printed
on followup pages of one master
[INTERMEDIATE TOTAL VALUE] should be only printed if pages to one master are followed
[TOTALVALUE] should be only printed on the last page of one master

contents
[INTERMEDIATE TOTAL VALUE] is the sum of VALUE of one Page plus [TRANSFER VALUE PREVIOUS PAGE]

[TRANSFER VALUE PREVIOUS PAGE] is the [INTERMEDIATE TOTAL VALUE] of the previous page

any hints how to archive this?
if unclear, just ask.

meikl ;-)
0
kretzschmar
Asked:
kretzschmar
  • 5
  • 5
1 Solution
 
makhanCommented:
Hi,

Please right click on the object that u want to have a controlled printing.

Select the options "Print object on" there are several options "First page" "Last Page" "All Pages" etc. etc.

Regards,

M. A. Khan
0
 
makhanCommented:
Sorry a correction

Select the Property "Print object on"
0
 
kretzschmarAuthor Commented:
thanks for your reply, makhan

i know about this options, but if i do so i get an error:

REP-1216: M_FRAME_X has an invalid printoption
(or similar (translated from my localized version))

specially if i adjust
-print on last page
-print on all pages but not last page

so i have to invoke an format-trigger to show/hide the frame

additional i have following problems:
- to know for followup pages
- to get the [TRANSFER VALUE PREVIOUS PAGE]
- to calculate [INTERMEDIATE TOTAL VALUE]
- to know which logical page per master-record is currently to print

i know how to get the [INTERMEDIATE TOTAL VALUE] for one page
(sum-formula with reset-option on page, but this formula can't be used to transfer its value to an placeholdercolumn for ex. nor it is usable for a format-trigger (not allowed))

a three page sample

-----------page one
XXXXX XXXXX
-----------detail group Frame
XXXXX XXXXX   5
XXXXX XXXXX   5
XXXXX XXXXX   5
XXXXX XXXXX   5
----------end detail
                       20  <- intermediate total
XXXXX XXXXX
----------end page one

-----------page two
XXXXX XXXXX
                      20 <- tansfer value previous page
-----------detail group Frame
XXXXX XXXXX   5
XXXXX XXXXX   5
           XXXXX  
XXXXX XXXXX   5
----------end detail
                       35 <- intermediate total
XXXXX XXXXX
----------end page two

-----------page three
XXXXX XXXXX
                      35 <- tansfer value previous page
-----------detail group Frame
XXXXX XXXXX   5
XXXXX XXXXX   5
----------end detail
                       45 <- total
XXXXX XXXXX
----------end page three

usual it is a standard issue, to have such sums.

btw. it is not an option to limit the count of detail-records per page
(grouping with modulo), because the height of the records do vary (1 up to 5 lines per record, with page protect option)

any further hints?

meikl ;-)
0
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 
makhanCommented:
some more tips.

1. u can keep the size of your detail frame to variable. again this is a settable property.
2. The error of invalid print option is bec. you need to keep all the objects in a group attached to a frame

ex.

f1
-------------------------------
     f1.o1
     f1.o2
     f1.o3
   f2
   --------------------
   f2.o1
   f2.o2
   f2.o3
   ------------------- end f2
   
-------------------------- end f1
if at any time the frames get overlapped or the objects get mis linked this error will be shown.

you can check this out in Objects browser.

Hope this helps to some extent.
0
 
kretzschmarAuthor Commented:
hmm, currently my design looks like


f1
-------------------------------
     f1.o1
     f1.o2
     f1.o3
   f2
   --------------------
   f2.o1
   f2.o2
   f2.o3
   ------------------- end f2
     f1.o4
     f1.o5
-------------------------- end f1

>you need to keep all the objects in a group attached to a frame
this is alread so, like ([] indicates mFrame)


[f1
-------------------------------
     f1.o1
     f1.o2
     f1.o3
                     [T-Value]  <-- currently PlaceholderColumn in f1 (problem show/hide/ValueContent)
  [f2
   --------------------
   f2.o1
   f2.o2
   f2.o3
   ------------------- end f2]
                     [I-Total]  <- PageSum in f1 (problem show/hide/calculate (plus T-Value))
                     [Total]    <- Total per f1 (no prob, except how to show/hide)
     f1.o4
     f1.o5
-------------------------- end f1]

meikl ;-)
0
 
makhanCommented:
Can u post a sample output.
0
 
kretzschmarAuthor Commented:
what kind of output do you mean?
0
 
makhanCommented:
I mean some 2 or 3 pages of the output of your report from your live data... u may mail it to my id mashoodakhan@yahoo.com
0
 
kretzschmarAuthor Commented:
well,
this is currently not allowed for me, because of customer-data,
but i can setup sample data next monday. would be nice, if you could wait until then

meikl ;-)
0
 
kretzschmarAuthor Commented:
hi,

i have solved the problem by calculating the page, maxpages and needed totals within a
source view for the report, and adding a pagegroup.

i would like to paq this q, if there are no other opinions

meikl ;-)
0
 
moduloCommented:
PAQed with points refunded (500)

modulo
Community Support Moderator
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 5
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now