468,719 Members | 1,705 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,719 developers. It's quick & easy.

Crystal Reports

Ave
Hi

I am hoping someone can help me or even point me in the
right direction, this problem has been doing my head in,
I have a report which has 3 groups say currency, payment
method and bankable, i have totals in the footers of these
groups, when any of the fields specifed on the groups
change the footer is displayed which is how crystal does
it, but what i want is if any of the fields used for the
groups change i only want one group footer to display and
not all, is there a way that you can say if all 3 or any
or more than one of the fields you use as your group change
only display one group footer ?

Thanks in advance.
Any help on this is much appreciated !!!

Ave,
Jul 21 '05 #1
3 6062
that you can do by puting formula on group footer by comparing value of
footer data if it return true then display or else not that u can implement
in group footer (show/visible/hide) one of them property is there u can put
formula on that
"Ave" wrote:
Hi

I am hoping someone can help me or even point me in the
right direction, this problem has been doing my head in,
I have a report which has 3 groups say currency, payment
method and bankable, i have totals in the footers of these
groups, when any of the fields specifed on the groups
change the footer is displayed which is how crystal does
it, but what i want is if any of the fields used for the
groups change i only want one group footer to display and
not all, is there a way that you can say if all 3 or any
or more than one of the fields you use as your group change
only display one group footer ?

Thanks in advance.
Any help on this is much appreciated !!!

Ave,

Jul 21 '05 #2
Ave
Hi

Thanks for your reply,
How can i know if the field used for the group, as in say
currency which groups all currency types together has
changed, when you setup a group you select a field to
group on say its currency, well how do i know if this has
changed and the group footer is going to write, that what
i need to check, so if i check this and it has changed and
the group footer is going to write i need to say dont
write the other groups footers if the grouped field on
them has changed, if you know what i mean. i hope you
understand what i am trying to say as i'm not sure how to
explain it if you know what i mean.

-----Original Message-----
that you can do by puting formula on group footer by comparing value offooter data if it return true then display or else not that u can implementin group footer (show/visible/hide) one of them property is there u can putformula on that
"Ave" wrote:
Hi

I am hoping someone can help me or even point me in the
right direction, this problem has been doing my head in,
I have a report which has 3 groups say currency, payment method and bankable, i have totals in the footers of these groups, when any of the fields specifed on the groups
change the footer is displayed which is how crystal does it, but what i want is if any of the fields used for the groups change i only want one group footer to display and not all, is there a way that you can say if all 3 or any or more than one of the fields you use as your group change only display one group footer ?

Thanks in advance.
Any help on this is much appreciated !!!

Ave,

.

Jul 21 '05 #3
is group fields are dynamic if no then you can take global varaiable in which
keep older value then and chack older value between new values if change is
there perform ur operation first time older value value is zero u have to
explicaitly handle that.
if fields r dynamic u can keep the field name into variable and perform ur
operation
"Ave" wrote:
Hi

Thanks for your reply,
How can i know if the field used for the group, as in say
currency which groups all currency types together has
changed, when you setup a group you select a field to
group on say its currency, well how do i know if this has
changed and the group footer is going to write, that what
i need to check, so if i check this and it has changed and
the group footer is going to write i need to say dont
write the other groups footers if the grouped field on
them has changed, if you know what i mean. i hope you
understand what i am trying to say as i'm not sure how to
explain it if you know what i mean.

-----Original Message-----
that you can do by puting formula on group footer by

comparing value of
footer data if it return true then display or else not

that u can implement
in group footer (show/visible/hide) one of them property

is there u can put
formula on that
"Ave" wrote:
Hi

I am hoping someone can help me or even point me in the
right direction, this problem has been doing my head in,
I have a report which has 3 groups say currency, payment method and bankable, i have totals in the footers of these groups, when any of the fields specifed on the groups
change the footer is displayed which is how crystal does it, but what i want is if any of the fields used for the groups change i only want one group footer to display and not all, is there a way that you can say if all 3 or any or more than one of the fields you use as your group change only display one group footer ?

Thanks in advance.
Any help on this is much appreciated !!!

Ave,

.

Jul 21 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Stephan | last post: by
3 posts views Thread by Gheaci Maschl | last post: by
7 posts views Thread by p | last post: by
reply views Thread by Robert Warnestam | last post: by
2 posts views Thread by =?Utf-8?B?Um9zcyBNYXNvbg==?= | last post: by
3 posts views Thread by Miro | last post: by
1 post views Thread by =?Utf-8?B?Q2lhcmFuIE8nJ0Rvbm5lbGw=?= | last post: by
1 post views Thread by CARIGAR | last post: by
1 post views Thread by Oskars | last post: by
9 posts views Thread by bryonone | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.