Group and Static Height detail band

rbuser

Hello.

I'm trying my first group report and I have some problems.

First of all, I need a detail band with static height for my report. My
report consist of one group, nothing in the group header, but something
in the group footer and only one DataSet (the header and the details are
in the same DS). So far, when I put the property Static Height to true
on the detail band and I change the height to what I want, the report
print with large space between two record.

Also, when I put a DBCalc on my Footer and I put my group as the reset
group, nothing is reset on the footer. The DBCalc keeps adding all the
elements to a huge sum. It works on the group footer, but I want to have
the sums printer on each pages, not only on the group change.

Thanks for your help.

P.s.: If you have a solution to do that in the Designer and not
programmatically it would be very nice.

JFPicard

nicocizik

Jean-Francois,

By definition a "static" height detail band will print the exact size you
define it each time the detail band is printed. If you would like the band
to shrink to the space used, you will need to use a dynamic height detail
band.

In my quick testing with RB 10.06, a DBCalc component properly reset it's
value after a group broke. Do you just want a page total or a complete
group total?

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Hi Nico, thanks for your reply. For your information, I'm on RB 10.05
and it will be difficult to me to test all my stuff on 10.06.

Is there any means to set that the height of detail band will be 4
inches or I must use an appropriate Footer with static height to do that?

For my DbCalc, I want to have the group total updated by page. I mean if
I have details to make 3500 on the first page and 1000 on the second
page (for the group; I do a page break at each group change), then I
want to see 3500 on the first page and 4500 on the second page. When I
put a DbCalc Sum with my group into the group reset in the Footer, the
DbCalc doesn't seems to reset at the group change.

If I may add another question, is there a way to change the text in the
PageSetDesc System variable ?

Thanks again.

JFPicard

nicocizik

Hi Jean-Francois,

1. If you have your detail band set to print with a static print height,
you can size it to be 4 inches and every detail band that prints will
automatically take up 4 inches of space. Are you trying to keep all detail
bands printed in a 4 inch space?

2. I'm unsure what is happening here. This is not a known issue for RB
10.05 so I believe the DBCalc component is working as designed. Are you
certain the group has broken and that the value being calculated is
incorrect? If possible, try creating a simple example that demonstrates
this behavior and send it to support@digital-metaphors.com in .zip format.

3. There is no way to change the text of a system variable however it is
very easy to mimic the behavior of that component using a TppVariable. In a
two pass report, it can be done using the Report.AbsolutePageNo and
Report.AbsolutePageCount properties.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Hello Nico.

1) I meant that I want to have the total space of the details to 4
inches for example. Not the height of the single band, but the total
height of all the details in my report.

2) It would be difficult to send you a working example without a proper
set of data in the database. If I have time, I will try to reproduce
that in one of your demo and send it to you. But I'm certain that the
group is broken since I print report with about 50 distinct items in the
group.

3) Thanks. But It would be great to be able to change the strings in the
system variables, since Page x of y is not usable in any other language
than English.

nicocizik

Depending on how much space each detail band requires, you can set the
PrintHeight to phDynamic an each detail band will only use the amount of
space that is required. It may also be possible to create a fixed subreport
with a 4 inch height and place you data inside that to restrict the size.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com