473,385 Members | 1,610 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Manipulate Color in the Application With Crystal Report

Hello there...
I want to ask about using crystal report in VB.Net...involving SQL Server 2000

first of all, my application is a win-based application n i used VB.Net...

i have created 2 forms, first is call the Inquiry and second is called the Details...

so, the process is like this...

User need to pick color in the Details form...
and then he/she will click a Save button on the form to save all the Details data into database (i use SQL Server 2000)
so, i make the application save the color as a code into the database...
the field is: ColorCode, datatype is: Nvarchar, Length is:64...

because i don't know to save in what datatype...do u have any suggestion please let me know thanks...

so, my problem is act i want to retrieve back the color from the database and show it in the report which is the crystal report i've created...

but i've studied that because i save it in code...so, in the crystal report also show a code such as "-16538"...

if this kind of data show in the report, it will cause a headache to the user who don't know the code of the color...

the process is when user click a "Print" button on the Inquiry form, a report will appear n show what they want...

well, anybody there can help me please...???

how can i show a color in the crystal report by retrieving the color data from SQL Server 2000???
Nov 20 '07 #1
0 1000

Sign in to post your reply or Sign up for a free account.

Similar topics

1
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...
0
by: Dr. Indera | last post by:
hello, i previously posted the questions below on several crystal reports newsgroups, including the one for the company that makes crystal reports, but never got an answer, so i'm hoping that...
4
by: Mike | last post by:
Hello All, I'm trying to deploy my windows-based application using crystal report. i package the setup by including the crystal report file, the exe file, and two merge modules for the crystal...
0
by: Simon | last post by:
Hi, I am using ASP.NET with C# and Crystal Report. I have a textbox et a asp.net button. I send a number in the texte, I push the button and I want to see the report with value related to the...
5
by: wrytat | last post by:
If I want to print report in a web application, should I use Crystal Report? Is it supported by all windows web server? I also read that I can only make a user view a Crystal Report in a web...
2
by: Ray | last post by:
Dear all, I have used Setup Winzard to deploy a windows application with crystal viewer to show a crystal report. I am using vb.net 2003. However, after I have installed the Setup in a computer...
1
by: John R. Dougherty | last post by:
I have a VB.NET 2003 application which is using the built-in Crystal Reports control for viewing an .RPT file. The .RPT files reside on the server, and the data pulled by these reports is in a SQL...
1
by: Duong Nguyen | last post by:
Hello, I write my application in VS.NET 2005. But I don't know how to deployment this application in order to all the report (Crystal Report in VS.NET) works well. It's so silly to setup whole...
2
by: Hexman | last post by:
Hello All, I'm nearing the end of my current project and the users came up with 2 more requests. I'll talk about the first one in this message. I've developed (with much help from this group)...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
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...
0
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,...
0
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...

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.