By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,611 Members | 1,627 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,611 IT Pros & Developers. It's quick & easy.

Crystal Reports

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a
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

P: n/a
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

P: n/a
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.