Hmm... boleh juga tambahan infonya.... trims y bro "shooter"
  ----- Original Message ----- 
  From:   Agus Sudana   
  To: [email protected]   
  Sent: Friday, March 28, 2008 6:58 PM
  Subject: Re: [indoprog-vb] laporan   crystal report
  

        
hi, 
coba bantu ya, ini yg biasa sy pakai :
(tapi, pakai komponen   tmbhan truedb Date.)
1. berdasar tanggal
CR1.ReportFileName = App.Path   & "\report\rptJual.rpt"
CR1.Formulas(0) = "xDate1='" &   TxtDate1.Value & "'"
CR1.Formulas(1) = "xDate2='" &   TxtDate2.Value & "'"
CR1.SelectionFormula =   "{Sales.salesDate}=#" & TxtDate1.Value & "#"
CR1.Action =   1
CR1.PageZoom 95

2. per periode:
CR1ReportFileName = App.Path   & "\report\rptJual.rpt"
CR1.Formulas(0) = "xDate1='" &   TxtDate1.Value & "'"
CR1.Formulas(1) = "xDate2='" &   TxtDate2.Value & "'"
CR1.SelectionFormula =   "{Sales.salesDate}>=#" & TxtDate1.Value & "# and   
{Sales.salesDate} <= #" & TxtDate2.Value & "#"
CR1.Action =   1
CR1.PageZoom 95

(\__/) 
(='.'=) Agus   Sudana
(")_(")

----- Original Message ----
From: mustapa_mail   <[EMAIL PROTECTED]>
To:   [email protected]
Sent:   Friday, March 28, 2008 11:20:31 AM
Subject: [indoprog-vb] laporan crystal   report

mau tanya:
1.Gmn cara membuat laporan berdasarkan   tanggal
(saya menggunakan dtpicker)
2.Membuat laporan   perperiode
(menggunakan dtpickter1 dan dtpickter2)
3.Menampilkan laporan   dari nomor 1 sampai 3
(menggunakan text1 dan text2)
nb:laporan crystal   report saya buat terpisah dengan vb

makasih banyak atas bantuannya,,   ,,


<!--

#ygrp-mkp{
border:1px solid   #d8d8d8;font-family:Arial;margin:14px 0px;padding:0px   
14px;}
#ygrp-mkp hr{
border:1px solid #d8d8d8;}
#ygrp-mkp   #hd{
color:#628c2a;font-size:85%;font-weight:bold;line-height:122%;margin:10px   
0px;}
#ygrp-mkp #ads{
margin-bottom:10px;}
#ygrp-mkp   .ad{
padding:0 0;}
#ygrp-mkp .ad   a{
color:#0000ff;text-decoration:none;}
-->

<!--

#ygrp-sponsor   #ygrp-lc{
font-family:Arial;}
#ygrp-sponsor #ygrp-lc   #hd{
margin:10px   0px;font-weight:bold;font-size:78%;line-height:122%;}
#ygrp-sponsor   #ygrp-lc .ad{
margin-bottom:10px;padding:0   0;}
-->

<!--

#ygrp-mlmsg   {font-size:13px;font-family:arial, helvetica, clean,   
sans-serif;}
#ygrp-mlmsg table   {font-size:inherit;font:100%;}
#ygrp-mlmsg select, input,   textarea {font:99% arial, helvetica, clean, 
sans-serif;}
#ygrp-mlmsg pre,   code {font:115% monospace;}
#ygrp-mlmsg *   {line-height:1.22em;}
#ygrp-text{
font-family:Georgia;
}
#ygrp-text   p{
margin:0 0 1em   0;}
#ygrp-tpmsgs{
font-family:Arial;
clear:both;}
#ygrp-vitnav{
padding-top:10px;font-family:Verdana;font-size:77%;margin:0;}
#ygrp-vitnav   a{
padding:0 1px;}
#ygrp-actbar{
clear:both;margin:25px   0;white-space:nowrap;color:#666;text-align:right;}
#ygrp-actbar   ..left{
float:left;white-space:nowrap;}
.bld{font-weight:bold;}
#ygrp-grft{
font-family:Verdana;font-size:77%;padding:15px   0;}
#ygrp-ft{
font-family:verdana;font-size:77%;border-top:1px   solid #666;
padding:5px 0;
}
#ygrp-mlmsg   #logo{
padding-bottom:10px;}

#ygrp-reco   {
margin-bottom:20px;padding:0px;}
#ygrp-reco #reco-head   {
font-weight:bold;color:#ff7900;}

#reco-grpname{
font-weight:bold;margin-top:10px;}
#reco-category{
font-size:77%;}
#reco-desc{
font-size:77%;}

#ygrp-vital{
background-color:#e0ecee;margin-bottom:20px;padding:2px   0 8px 8px;}
#ygrp-vital   #vithd{
font-size:77%;font-family:Verdana;font-weight:bold;color:#333;text-transform:uppercase;}
#ygrp-vital   ul{
padding:0;margin:2px 0;}
#ygrp-vital ul   li{
list-style-type:none;clear:both;border:1px solid   #e0ecee;
}
#ygrp-vital ul li   ..ct{
font-weight:bold;color:#ff7900;float:right;width:2em;text-align:right;padding-right:.5em;}
#ygrp-vital   ul li .cat{
font-weight:bold;}
#ygrp-vital   a{
text-decoration:none;}

#ygrp-vital   a:hover{
text-decoration:underline;}

#ygrp-sponsor   #hd{
color:#999;font-size:77%;}
#ygrp-sponsor   #ov{
padding:6px   13px;background-color:#e0ecee;margin-bottom:20px;}
#ygrp-sponsor   #ov ul{
padding:0 0 0 8px;margin:0;}
#ygrp-sponsor #ov   li{
list-style-type:square;padding:6px   0;font-size:77%;}
#ygrp-sponsor #ov li   a{
text-decoration:none;font-size:130%;}
#ygrp-sponsor   #nc{
background-color:#eee;margin-bottom:20px;padding:0   8px;}
#ygrp-sponsor .ad{
padding:8px 0;}
#ygrp-sponsor .ad   #hd1{
font-family:Arial;font-weight:bold;color:#628c2a;font-size:100%;line-height:122%;}
#ygrp-sponsor   .ad a{
text-decoration:none;}
#ygrp-sponsor .ad   a:hover{
text-decoration:underline;}
#ygrp-sponsor .ad   p{
margin:0;}
o{font-size:0;}
.MsoNormal{
margin:0 0 0   0;}
#ygrp-text tt{
font-size:120%;}
blockquote{margin:0 0 0   4px;}
.replbq{margin:4;}
-->


__________________________________________________________
Never   miss a thing. Make Yahoo your home page. 
http://www.yahoo.com/r/hs

[Non-text   portions of this message have been removed]



 

__________ NOD32 2993 (20080401)   Information __________

This message was checked by NOD32 antivirus   system.
http://www.eset.com
#ygrp-mkp {     BORDER-RIGHT: #d8d8d8 1px solid; PADDING-RIGHT: 14px; 
BORDER-TOP: #d8d8d8 1px solid; PADDING-LEFT: 14px; PADDING-BOTTOM: 0px; MARGIN: 
14px 0px; BORDER-LEFT: #d8d8d8 1px solid; PADDING-TOP: 0px; BORDER-BOTTOM: 
#d8d8d8 1px solid; FONT-FAMILY: Arial}#ygrp-mkp HR {   BORDER-RIGHT: #d8d8d8 
1px solid; BORDER-TOP: #d8d8d8 1px solid; BORDER-LEFT: #d8d8d8 1px solid; 
BORDER-BOTTOM: #d8d8d8 1px solid}#ygrp-mkp #hd {        FONT-WEIGHT: bold; 
FONT-SIZE: 85%; MARGIN: 10px 0px; COLOR: #628c2a; LINE-HEIGHT: 122%}#ygrp-mkp 
#ads { MARGIN-BOTTOM: 10px}#ygrp-mkp .ad {     PADDING-RIGHT: 0px; 
PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; PADDING-TOP: 0px}#ygrp-mkp .ad A {  
COLOR: #0000ff; TEXT-DECORATION: none}          
       
---------------------------------
You rock. That's why Blockbuster's offering you one month of Blockbuster Total 
Access, No Cost.

[Non-text portions of this message have been removed]

Kirim email ke