Grouping Problem - Page break at end

Question

Post reply

Grouping Problem - Page break at end

lost in SQL

SSC Enthusiast

Points: 183
More actions
March 18, 2008 at 3:01 am

#187529

I am using a group with "Page break at end" property as true or selected .
I have a small summary details after this group, and those are getting printed on new page due to the above property.
I want details to be printed at the end of last group value on the same page.
Any clue on this...:)

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Niels Naglé Ten Centuries Points: 1058 More actions · Answer 1

Good morning,

If i understand you correctly you have some information and followed after each group is a summary?

If this is correct:

Just disable the function "Page break at end"of the grouping and the summary will be placed beneath the group and add a pagebreak after the summary if wanted.

Or do you mean that you have several groups of information and at the last group you would like to have the summary over all of the groups?

If this is correct:

I need some more information about the report. How many groups and groupings do you have in the report and the summary is this in the same table or not? That kind of information .....

Just let me know if you need more information

Niels Naglé

lost in SQL SSC Enthusiast Points: 183 More actions · Answer 2

Thanks Niels for your point...

Actual Data to be printed(Data Table):

Group1HeaderPage break at end = true

Details having fields

Group1FooterPage break at end = true

Table after Data Table (Summary Table):

Group1HeaderCount(Field)

Now my problem is Summary Table is getting printed on new page, which I don’t want. I want it to print on its previous page, where Data Table (1st table) is finishing its printing and at the same time I don’t want to change “Page break at end” property of Data Table (1st Table).

I.e. for last value of Group1, “Page break at end” should become false or something similar. I know, 99% it’s not possible but still looking for 1%.

I hope this might give you more idea...

Thanks..:)

RB

Niels Naglé Ten Centuries Points: 1058 More actions · Answer 3

Good morning,

Thanks for the extra information, this helps but i still got a question about the summary table.

What kind of summary table do you show is this the summary of the data over all of the groupings in the table above?

Niels Naglé

lost in SQL SSC Enthusiast Points: 183 More actions · Answer 4

Yep you got it right...

it's summary data of above table...Data Table

Niels Naglé Ten Centuries Points: 1058 More actions · Answer 5

OK.

Then you have the ability to plase this beneath the last datatable instead of on a new page.

Just add another group above of the datagroup and place the information counts information in this group so it is al in one table then it will be automatically placed after the last datagroup.

So it's gonna look something like:

AnotherGroupHeader

Group1Header Page break at end = true

Details having fields

Group1Footer Page break at end = true

AnotherGroupRow Place the counts information in here

AnothergroupFooter

If you have any questions just let me know

Niels Naglé

lost in SQL SSC Enthusiast Points: 183 More actions · Answer 6

Thanks Mate...

Note yet checked... will get back to you on this...