Page Break

[hgg21]

Hi,

I have a question here.
Can I force page break in a report based on a field?

I have one field. If it is A then this field will display "A" then all the details with respect to A. If it is B then it will automatically page break and display "B" then all the details of B.

Please advise.
Thanks
Jerry

 

[hgg21]

Hi,

Basically this is what I want now:

The page header will have a field "Hedge Fund List" then the group#1 will show all the records that belong to Hedge Fund List.

Then a page break when, the page header will change to "Manager Money List" and group#1 will now show all the records that belong to Manager Money List.

How do I connect the header field, group field and page break to get what I want?? I only know for page break u need to click off the "New Page After" rite?

Thanks for any help!
Please, I really need help.
Jerry

 

[dgillz]

I do not understand exactly what you are trying to do. If you want each group to start on a new pagem then turn your "New page after" button to on in the group footer. Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[hgg21]

Sorry to trouble you again.

But this is a bit complicated to say.

Okie,
basically I have 2 groups. group#1 is BUCKET.BUCKETNAME
group#2 is FundList.FundGroup. Their relationship is like that.

BucketName FundGroup
AAAA HEGD
AAAA HEGD
AAAA MMGL
AAAA MMGL
BBBB HEGD
BBBB MMGL
CCCC HEGD
CCCC HEGD
and so on.....


Now I would like to present the report like:

HEGD
BucketName FundGroup
AAAA HEDG
BBBB HEGD
CCCC HEDG

(page break)

MMGL
BucketName FundGroup
AAAA MMLG
BBBB MMLG
CCCC MMLG

The details of the BucketName have to be suppressed as there will be duplicates.

Do u have any ideas how i can sort or group to get the above?

Thanks for any help!
Jerry

 

[hgg21]

My problem is now what I m getting is:

BucketName FundGroup
AAAA HEDG

(page break)

BucketName FundGroup
AAAA MMLG

(page break)

BucketName FundGroup
BBBB HEDG

(page break)

BucketName FundGroup
BBBB MMLG

 

[hgg21]

I know what I want now.

Can I have a group under a group???
Like a subgroup.

First I will group FundList.FundGroup
then I will group Bucket.BucketName under the above group.

How can I do that? IS there such a function?

Please help as this is urgent.
Thanks!!!!!
Jerry

 

[hgg21]

I have managed to solve the above problem.

Now I have one small problem though.

I have the groupname field in the page header section.
How do I make it change as the details change?

For example it will display "HEDG" when this page shows HEDG details and display "MMLG" when the page shows MMLG details.

Thanks
Jerry

 

[synapsevampire]

The group won't change in the page header section as the page header is updated only once, unless you're creating a new page as a result of a group change (new before or after).

I tried to follow your problem and solutoin along, but it isn't real clear, except that Crystal isn't your native language

I think you should have Group 1 as Fundgroup, and Group 2 as Bucketname.

The Group 1 header will have the Group name turned on and bolded.

The group footer for bucketname will display your data (you don't even need a bucketname group if this is all you're going to display, I assue that you have some summaries, or some such for bucketname).

All other groups and details are suppressed.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[hgg21]

hi,
u are absolutely correct!

I have Group 1 as Fundgroup, and Group 2 as Bucketname now.

Now, my group header for bucketname display my data (I need to group the bucketname as I want to suppress the details for it as there are duplicates. Yes u are rite that I have some summaries for bucketname). I have suppressed group 1 header and footer and group 2 footer.

All other groups and details are suppressed.

For the header field, I have inserted this formula:
If {FundList.Fundgroup} = "HEDG" then "HEDG"
else
If {FundList.Fundgroup} = "MMLG" then "MMLG"

Now I want to calculate the total for HEDG and the total for MMLG.

But I do not know where to insert the total fields for it.
Cant be groupfooter.

Thanks for replying.
Jerry