ReportBuilder Breakgroup+Conditional Display of lines

Discussion forum about all things Report Builder (all versions).
hassler.w

ReportBuilder Breakgroup+Conditional Display of lines

Post by hassler.w » 02 May 2011, 14:09

Hi,
trouble in ReportBuilder when using a defined BreakGroup with the property "Keep Group: OnPage".

-> See my testcase -> after each 20 data rows a break with "Keep Group: On Page" is done. I define the "Page Header" with showing a line only on the first page and a line showing on follow pages. When "keep Group: OnPage" is not used, everything works fine. If "keep Group: OnPage" is used, no Conditional Display on the "Page Header" works.

Tested with TD 6.x SPx

thx Werner
You do not have the required permissions to view the files attached to this post.

Jeff Luther

Re: ReportBuilder Breakgroup+Conditional Display of lines

Post by Jeff Luther » 02 May 2011, 17:51

Problem is, even though you filter for 21, that If still falls through to the end of the function where there is a Return TRUE. Change your If to:

Code: Select all

If SalNumberMod( nNr, 21 ) = 0
   Set nBreak=1
   ! JL added
   Return FALSE
and your report page prints 20 detail lines only.

hassler.w

Re: ReportBuilder Breakgroup+Conditional Display of lines

Post by hassler.w » 03 May 2011, 07:14

Hallo Jeff,

thanks for answer.
In my testcase i like to restart each 20 rows the group Break, after 100 rows the report is finished (It looks like x-time a group of 20 rows. First 20 rows on page 1, next 20 rows should printed on page 2 and so on. On Page 2 the line of the page header should change). So the "Return True" is ok.

Werner

hassler.w

Re: ReportBuilder Breakgroup+Conditional Display of lines

Post by hassler.w » 06 May 2011, 08:31

Hi Jeff,

some news with this case?

thanks
Werner

hassler.w

Re: ReportBuilder Breakgroup+Conditional Display of lines

Post by hassler.w » 16 May 2011, 12:38

Hi,

some news with this case?

thanks
Werner

Welskop

Re: ReportBuilder Breakgroup+Conditional Display of lines

Post by Welskop » 10 Jun 2011, 13:24

Where can I find the option "Keep Group: OnPage" in Report Builder 6? Maybe I am blind but I can't find this option!

Kind regards,
Frank

User avatar
Charlie
Canada
Posts: 652
Joined: 07 Mar 2017, 18:52
Location: Fredericton, New Brunswick, Canada

Re: ReportBuilder Breakgroup+Conditional Display of lines

Post by Charlie » 13 Jun 2011, 15:26

Hi Frank,

Right-click on the "Header:" label right next to the button that collapses the group. Click on Properties. You'll find everything you need in the resulting dialog box.
PROPERTIES_FOR_GROUP.jpg
Cheers.
You do not have the required permissions to view the files attached to this post.

Return to “General Discussion Report Builder”

Who is online

Users browsing this forum: [Ccbot] and 0 guests