473,761 Members | 4,421 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 7235
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
19182
by: Stephan | last post by:
Hi, I'm using Visual Studio 2003 (C#) with the integrated Crystal Report software and have the following question: How can I assign a value (string) to an unbound (string) field in Crystal Report at runtime? Example: private void button1_Click(object sender,
5
3026
by: BStorm | last post by:
I have a transaction log file where the DataSet table's Description column is actually delimited into "subcolumns" based upon the transaction id. I would like to parse these into separate fields for reporting purposes and am wondering if anyone knows if this is easily accomplished using the .NET version of Crystal Reports? For example, the description column may be reporting on a dataentry error as follows: TXNCODE: 1010001
3
6915
by: Gheaci Maschl | last post by:
Hi all! I would like to have your opinion about my problem and my proposal how to solve it: Ingredients: - BTriev database - Crystal Reports - maybe MS Access - Liinos6 (small ERP software)
7
5021
by: p | last post by:
WE had a Crystal 8 WebApp using vs 2002 which we upgraded to VS2003. I also have Crystal 9 pro on my development machine. The web app runs fine on my dev machine but am having problems deploying. I created the websetup and built the MSI, have the bundled version. Copied to webserver and ran Websetup.msi. Said I had to remove old version, which I did, then reran WebSetup.msi and keeps giving me this error. "The installer was interrupted...
0
2347
by: Robert Warnestam | last post by:
Hello, I have some problems deploying Crystal Reports. I'm using Visual Studio 2005 Beta 1. In this version Crystal Reports (9.7.3500.0) is included. I created a small test application (ASP.NET) that shows a simple report. It work fine with on my local computer. Now I'm trying to deploy this sample application on our web server but I really need some help.
3
8924
by: VMI | last post by:
I know this may not be the best NG for this, but I feel you guys know more about this than any of the other NGs. I need to build several simple reports (over 50 of them and they get their data from sql server) and I was wondering whish of these is the better tool .. We're still not sure if they'll be loaded from an existing VB6 application or if I'll have to make a separate module for them (in .Net). In general, which is the better tool?...
1
4316
by: Lyners | last post by:
Hello all, I have created an ASP.NET website that uses Crystal Reports that works on the localhost (my PC), but when I copy it to the server it does not. The problem is ExcelUseConstantColumnWidth = False. On my PC when exporting a report, it works - columns are varible width to fit the field, from the server it does not - I get constant width columns. I suspect it is a DLL issue, but so far all my comparisons are coming out the same.
2
446
by: =?Utf-8?B?Um9zcyBNYXNvbg==?= | last post by:
Hi I am interested in using crystal reports for the first time but have a few questions that someone maybe able to help with before I get started. The background to my query is that a client is interested in using crystal reports as a web based reporting tool to get data out of a sql server database and we have always created our own bespoke reporting tools but this particular client wishes to go down the crystal reports route. 1) We...
3
3824
by: Miro | last post by:
Hi, Just wondering what a good book is on visual studios 2008 ( or 2005 if no 2008 ) that teaches you how to properly use crystal reports with it. Or im assuming that as long as I can create a dataset and link it to a reportviewer than any Crystal Report book will do. I use vb.net but im assuming most books would show you vb and c
1
8145
by: =?Utf-8?B?Q2lhcmFuIE8nJ0Rvbm5lbGw=?= | last post by:
On reflection, you could possibly make the app a self extracting zip file which extracts the EXE and a settings file and then starts the app, then when you app closes, it can repack the settings file and itself into the exe. You would probably want a tool for this bit which could be in the zip too. So the app isnt single exe when running but when not running, it is. Just an idea for you to think about. Another option would possibly be to...
0
9353
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10123
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9975
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9788
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7342
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6623
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5241
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5384
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3889
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.