I need some help with a Report Builder Calculation to do Page C

Yahoo Archive
1
Hi Todd ...

Thanks very much ...

I understand it ... now .. to see if I can get it to work ...

Thanks again ...

Mike

-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Thursday, July 11, 2002 9:21 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] I need some help with a Report Builder
Calculation to do Page Counting


I've done this but it is messy -
Set up an aggregate to count a fixed calculated field that is set to 1 and
totaled at each "detail" line - pre-pass, no-reset. I can then create a
calculated logical to force a new page every 60 (or whatever) detail lines
(calculated as whenever line-count / 60 = 1) and using a seperate band-line
containing only a "new page" line. In the heading of the report I print the
total pages as being my total lines divides by 60 (or whatever is used to
force a new page).

It gets a lot more complicated if you have sub-totals at variable numbers of
detail lines.

This is kind of kludgey due to restrictions in RB.

From the RB User's Guide (section 5 page 6):
---------------
"Because Report Builder accumulates prepass aggregates in a single
preliminary pass through the data, you cannot prepass any aggregates that
involve page formatting."
--- then a bit below this is the following statement ---
"You can not specifiy prepass processing for:
Pagination-related aggregates such as page-totals, aggregates whose
accumulation frequency has been set to once per page, and aggregates that
involve calculated fields that use the PAGE-NUMBER() function."
---------------
So it looks to me like trying to get the the Max page number is not possible
because RB does not "know" about page formatting issues at the time it does
the pre-pass aggregating. It is a design limitation in RB.

-Todd C.


-----Original Message-----
From: Michael D. Howard [mailto:mike@...]
Sent: Wednesday, July 10, 2002 1:33 PM
To: vantage@yahoogroups.com
Subject: [Vantage] I need some help with a Report Builder Calculation to do
Page Counting


Hello ...

Anybody able to tell me how to set up a calculated field
that would give me the total page count for a report?

Then I could print "Page 1 of 6" type notations on
the bottom of the page ...

I'm even more stumped than usual on this one ..

Michael D. Howard
Director
General Sheet Metal Works, Inc.
South Bend, IN



Yahoo! Groups Sponsor

<http://rd.yahoo.com/M=229641.2166546.3626727.1829184/D=egroupweb/S=17050071
83:HM/A=1142328/R=0/*http://promo.yahoo.com/debtscape/>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
2
Hello ...

Anybody able to tell me how to set up a calculated field
that would give me the total page count for a report?

Then I could print "Page 1 of 6" type notations on
the bottom of the page ...

I'm even more stumped than usual on this one ..

Michael D. Howard
Director
General Sheet Metal Works, Inc.
South Bend, IN
3
I've done this but it is messy -
Set up an aggregate to count a fixed calculated field that is set to 1 and
totaled at each "detail" line - pre-pass, no-reset. I can then create a
calculated logical to force a new page every 60 (or whatever) detail lines
(calculated as whenever line-count / 60 = 1) and using a seperate band-line
containing only a "new page" line. In the heading of the report I print the
total pages as being my total lines divides by 60 (or whatever is used to
force a new page).

It gets a lot more complicated if you have sub-totals at variable numbers of
detail lines.

This is kind of kludgey due to restrictions in RB.

From the RB User's Guide (section 5 page 6):
---------------
"Because Report Builder accumulates prepass aggregates in a single
preliminary pass through the data, you cannot prepass any aggregates that
involve page formatting."
--- then a bit below this is the following statement ---
"You can not specifiy prepass processing for:
Pagination-related aggregates such as page-totals, aggregates whose
accumulation frequency has been set to once per page, and aggregates that
involve calculated fields that use the PAGE-NUMBER() function."
---------------
So it looks to me like trying to get the the Max page number is not possible
because RB does not "know" about page formatting issues at the time it does
the pre-pass aggregating. It is a design limitation in RB.

-Todd C.


-----Original Message-----
From: Michael D. Howard [mailto:mike@...]
Sent: Wednesday, July 10, 2002 1:33 PM
To: vantage@yahoogroups.com
Subject: [Vantage] I need some help with a Report Builder Calculation to do
Page Counting


Hello ...

Anybody able to tell me how to set up a calculated field
that would give me the total page count for a report?

Then I could print "Page 1 of 6" type notations on
the bottom of the page ...

I'm even more stumped than usual on this one ..

Michael D. Howard
Director
General Sheet Metal Works, Inc.
South Bend, IN



Yahoo! Groups Sponsor

<http://rd.yahoo.com/M=229641.2166546.3626727.1829184/D=egroupweb/S=17050071
83:HM/A=1142328/R=0/*http://promo.yahoo.com/debtscape/>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]