Kalau mau output nya sama ngapain melalui coding, di CR nya sudah di siapkan koq fungsi SUM,
hasilnya persis sama
Jadi di CR nya kamu tampilin semua datanya saja,
kemudian insert group --> group berdasarkan LOT, kemudian pilih SUM --> masukan apa yg akan di SUM
Salam
Ronald Irawan
Pt. Sanghiang Perkasa
Gd. Graha Kirana Lt.5
Jl Yos Sudarso Kav.88
Jakarta
| "skdmdn" <[EMAIL PROTECTED]>
Sent by: [email protected] 16/02/2006 10:08 AM
|
|
Mas Ronald
Klo melalui coding dan outputnya diarahkan ke CR gimana caranya agar outputnya sama dengan yg di sql tadi?
----- Original Message -----
From: Ronald Irawan
To: [email protected]
Sent: Thursday, February 16, 2006 9:55 AM
Subject: Re: Spam Re: [Programmer-VB] Sort data
Bikin nya di crystal report, disana sudah ada fungsi SUM....
Salam
Ronald Irawan
Pt. Sanghiang Perkasa
Gd. Graha Kirana Lt.5
Jl Yos Sudarso Kav.88
Jakarta
| "skdmdn" <[EMAIL PROTECTED]>
Sent by: [email protected] 16/02/2006 09:55 AM
|
|
Klo outputnya di arahkan ke Crystal Report bisa gak? Trus gimana perintahnya?
----- Original Message -----
From: Purwedi Kurniawan
To: [email protected]
Sent: Thursday, February 16, 2006 9:09 AM
Subject: Spam Re: [Programmer-VB] Sort data
SELECT LOT, SUM(QTY) AS TOTAL FROM NAMATABLE GROUP BY LOT ORDER BY LOT
On 2/16/06, Hasan <[EMAIL PROTECTED]> wrote:
Pagi rekans...
Saya mo tanya neh..., saya punya data gini :
LOT LOC QTY
1 A 10
1 B 15
2 C 5
3 STAGE 50
3 D 15
3 E 35
Saya mo cari output yang gini...
LOT QTY
1 25
2 5
3 100
Saya udah coba cari di arsip tapi belum ketemu juga
neh,saya cari di help nya sql 2k juga blm ktm, tolong
dong kalo ada yang bisa bantu saya, gimana ya script
nya??Or kalo memang ada link nya jg ga papa....
Thanx..
Hasan
MM2100
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 267.15.9/261 - Release Date: 2/15/2006
Wahana Programmer Groups Links
<*> Untuk mengunjungi sponsor milis ini, klik link berikut:
http://wahanaprogrammer.net
<*> Untuk menghubungi owner milis ini, kirim email ke:
[EMAIL PROTECTED]
<*> Konsultasi pemrogramman bisa chat disini:
Yahoo! Messenger: wahanaprogrammer
SPONSORED LINKS
| Programmer | Indonesia | Basic programming language |
| Computer programming languages | Programming languages | Java programming language |
YAHOO! GROUPS LINKS
- Visit your group "Programmer-VB"
on the web.
- To unsubscribe from this group, send an email
to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 267.15.9/261 - Release Date: 2/15/2006
Wahana Programmer Groups Links
<*> Untuk mengunjungi sponsor milis ini, klik link berikut:
http://wahanaprogrammer.net
<*> Untuk menghubungi owner milis ini, kirim email ke:
[EMAIL PROTECTED]
<*> Konsultasi pemrogramman bisa chat disini:
Yahoo! Messenger: wahanaprogrammer
SPONSORED LINKS
| Programmer | Indonesia | Basic programming language |
| Computer programming languages | Programming languages | Java programming language |
YAHOO! GROUPS LINKS
- Visit your group "Programmer-VB"
on the web.
- To unsubscribe from this group, send an email
to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Wahana Programmer Groups Links
<*> Untuk mengunjungi sponsor milis ini, klik link berikut:
http://wahanaprogrammer.net
<*> Untuk menghubungi owner milis ini, kirim email ke:
[EMAIL PROTECTED]
<*> Konsultasi pemrogramman bisa chat disini:
Yahoo! Messenger: wahanaprogrammer
| Programmer | Indonesia | Basic programming language |
| Computer programming languages | Programming languages | Java programming language |
YAHOO! GROUPS LINKS
- Visit your group "Programmer-VB" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
