473,770 Members | 2,781 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Manipulate Color in the Application With Crystal Report

2 New Member
Hello there...
I want to ask about using crystal report in VB.Net...involv ing 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 1022

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

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,
0
4495
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 someone on this board knows the answers to them. the questions are for the version of crystal that ships with visual studio.net 2003. if it helps, the reports that i create are in a visual basic.net project. it was recommended that i post the...
4
6195
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 report (crystal_managed2003.msm and crystal_Database_Access2003.msm). when i installed it on a different computer before running it. i verify the neccessary files was added. when i ran it, it return "Cannot find KeycodeV2.dll, or invalid keycode."
0
4801
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 number in the textbox. The problem is that I need to call the crystal report function in the "override protected void OnInit(EventArgs e)" function to see my graphic and picture in the report. When I push the button, the content of the textbox is not...
5
2287
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 application, but can't print it. To print, the user have to click "File|Print" in the web browser to print. Is this true? Can't I have a "Print" button on the page to print the Crystal Report?
2
2675
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 with no vs.net and crystal report. The crystal report cannot be shown. The error message is : Cannot find KeycodeV2.dll, or invalid keycode. Please help. Thanks a lot, Ray
1
1425
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 Server database. On any client PC, I can create an ODBC connection to the SQL Server database - and the DSN name for this connection is what I reference in code when setting up a user-selected report for viewing. I have created a deployment...
1
1515
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 Crystal Report components in VS.NET packages in user computer! Right? Pls help me how to solve this problem! Thanks in advance.
2
1488
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) a vb.net app and is being put into the users hands this week. I am using Crystal Report X to produce reports. The users now, rather than printing, want them emailed and produced in .pdf format also. So rather than me re-inventing the wheel, I'm...
0
9425
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
10228
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...
1
10002
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8883
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6676
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
5449
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3970
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
2
3575
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2816
bsmnconsultancy
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...

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.