Hi all,
I am using VB6 and Crystal Reports 9. I have to show the transaction in the report day by day. I have shown all the reports but what I wanted is I want to show the transaction with colors. I mean to say I want to show the transactions line by line with alternate colors. Is it possible in Crystal Reports 9? The database is too large so it is quite hard to view it because it shows the name and the amount. So, it is not easy to match the name with the amount, if it can be shown in colors then it will be easy to the users to view.
Thanks in advance.
coolminded.
7  5136 
You need to write formula for color from the font tab for that particular field.
QVeen72 1,445
Recognized Expert Top Contributor
Hi,
Go to CR Designer, right-click on Details Section to (extreme) left go to menu :
"Section Expert", Click on "Color" Tab
Check the option "BackgroundColo r"
Click on "Formula Button"
and give this in Formula button: - If RecordNumber mod 2 = 0 then
-
crSilver
-
Else
-
crAqua
Check the CR Color Constants and change to whatever colours you want.
Regards
Veena
Go to CR Designer ...
Hi Veena
Thanks a lot for the help. It really worked.
Hi,
Go to CR Designer, right-click on Details Section to (extreme) left go to menu :
"Section Expert", Click on "Color" Tab
Check the option "BackgroundColo r"
Click on "Formula Button"
and give this in Formula button:
- If RecordNumber mod 2 = 0 then
-
crSilver
-
Else
-
crAqua
Check the CR Color Constants and change to whatever colours you want.
Regards
Veena
hi veena,
i did as u said and it works fine.
but is it possible to use some other colors except the inbuilt colors like
crblue, crsilver , craqua and so on
i want to use custom colors instead of these.
thanx
regards
sayamishiraj
Hi Veena
Is it also possible to show the line by line with alternate colors in the report designer that is built in vb 6.0?
QVeen72 1,445
Recognized Expert Top Contributor
hi veena,
i want to use custom colors instead of these.
thanx
regards
sayamishiraj
Hi Sayam,
You can use the Crystal Function : Color(red,green ,blue)
red ,green and blue are Numbers : value between 0 and 255.
This is equivalent to RGB function of VB.
Regards
Veena
QVeen72 1,445
Recognized Expert Top Contributor
Hi Veena
Is it also possible to show the line by line with alternate colors in the report designer that is built in vb 6.0?
Hi Lotus,
I dont think DataReports have that option of Alternate Colors.
We can change the BackColor/ForColor of Controls on the Report during Runtime, This would change the color of all the records displayed in that control..
may be we can write some sort of Formula.. I'am not very sure, I will check and tell you..
Regards
Veena
Sign in to post your reply or Sign up for a free account.
Similar topics | |
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,
|
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
|
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)
|
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...
|
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.
| | |
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?...
|
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.
|
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...
|
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
|
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...
|
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,...
| | |
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...
|
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...
|
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...
|
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...
|
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();...
|
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...
| | |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
