Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Dragonist
Starting Member
9 Posts |
 Posted - 2004-07-26 : 22:55:21
|
| Hi, I am trying to select specific data that should be assigned row by row, such as now that, I am having a datagrid like below:CHEMICAL CODE NO. MANUFACTURER AREA USED ARGON GS0001AA Malaysian Oxygen Berhad AM1 DA LAB ARGON GS0001AA Malaysian Oxygen Berhad AM1 FASL ASSEMBLY (FOL) ARGON GS0001AA Malaysian Oxygen Berhad AM1 FASL MOLD ARGON GS0001AA Malaysian Oxygen Berhad AM1 GAS STORAGE AREA BUEHLER FS0025AA Buehler, Ltd AM1 EPOXY CLEANING ROOM BUEHLER FS0025AA Buehler, Ltd AM2 DA LAB ...............I wish to change it into a style like this:CHEMICAL CODE NO. MANUFACTURER AREA USED ARGON GS0001AA Malaysian Oxygen Berhad AM1 DA LAB AM1 FASL ASSEMBLY (FOL) AM1 FASL MOLD AM1 GAS STORAGE AREA BUEHLER FS0025AA Buehler, Ltd AM1 EPOXY CLEANING ROOM AM2 DA LAB ...............The data is sort by "CHEMICAL", I am trying to figure out what method should I use so that the redundant data can be "checked" and return as "null" value, so no matter which field is sorted by, once the data is redundant should not be shown. This is a report to the end-user.Thanx for ur help in advance. |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2004-07-27 : 00:51:34
|
| Have you considered looking at MS reporting Services?Duane. |
 |
|
|
Dragonist
Starting Member
9 Posts |
Posted - 2004-07-27 : 23:33:58
|
| Arrgg... the format does not show as I have designed it to be.Well, I am currently connecting to an existing Access database and using VB.Net to do the coding. My company does not have MS SQL Server at the moment in my pc yet. Firstly, I create a Dataset and bind the whole Dataset to the datagrid, so it looks such as below:ARGON GS0001AA Malaysian Oxygen Berhad AM1 DA LAB ARGON GS0001AA Malaysian Oxygen Berhad AM1 FASL ASSEMBLY (FOL) ARGON GS0001AA Malaysian Oxygen Berhad AM1 FASL MOLD ARGON GS0001AA Malaysian Oxygen Berhad AM1 GAS STORAGE AREA BUEHLER FS0025AA Buehler, Ltd AM1 EPOXY CLEANING ROOM BUEHLER FS0025AA Buehler, Ltd AM2 DA LAB ..........Now they are requesting that, data that are redundant should not be displayed. Such as, the data "ARGON" is displayed repeatedly, like:ARGONARGONARGONARGONIs to be changed into a format like:ARGON"Null Value""Null Value""Null Value""Null Value"This apply same to "GS0001AA", and "Malaysian Oxygen Berhad" as well.How should I do it in order to generate a report in this kind of format? Can it be done in the datagrid itself? |
|
|
|
Dragonist
Starting Member
9 Posts |
Posted - 2004-07-30 : 00:01:33
|
| Thanx man I think I solve the problem already.^_^ lolz |
|
|
|
|
|
|
|
|
Manage data row by row in DataGrid