Crystal Report & automatic catch data

naikAntena

saya x sempat nk rujuk thread lain... nk minta tolong setel problem...

1) cam nerr nk buatTEXTBOX(input data,primary key) utk automatik catch data dr DATABASE(sql server) dan keluarkan warning!! supaya data yg di masukkan tidak ada duplicate key... mcm validate ah!!

cth mcm registration ID YAHOO!! bila keluar je dr textbox(tanpa tekan butang submit) trus kuar msg warning..... cam nerkk ahh!!!


2) Crystal Report>>> cam nerkk coding dlm sistem nk export viewer  rpt.  ke .pdf...

-pastuhh cam mn nk pass data dr ddl(drop down list) page system ke crystal report...  

perisian:visual studio.net 2003 ... crystal report 9.0.....
language: .aspx

harap pakar2 dpt tolong... urgent...

yIEn

Contoh yang sering aku buat. Paling simple.

for q no 1:
set autopostback = true for textbox.

Private Sub TextBox1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox1.TextChanged
        ****your coding for checking****
End Sub


for q no 2:
........cam nerkk coding dlm sistem nk export viewer  rpt.  ke .pdf...

-> dalam crystal report, bila click print button, automatik dia akan tanya nak save atau print. Pilih save dan boleh save dalam pdf.

........-pastuhh cam mn nk pass data dr ddl(drop down list) page system ke crystal report...  
-> ni nanti org carik cemana. harap bersabar

naikAntena

A1: skang pun saya tgh try cara tuh.. kiranyerr skang kalo dlm vb mudah sket.. tp in vb.net aku br lg.... ko to x cam nerkk nk tukar
"MousePointer = vbHourglass" ke vb.net(.aspx)... saya try imports system.windows.form  x dapat!!! x declare.... humm susahh!! minggu dpn nk submit...


A2: pasal crystal report tuhh mmg blehh nk save mcm tuhh!!! tp saya buat system based on web.. and cara itu mungkinn susahkan user.. crystal report viewer.. kiranyerr cam bos suruhh export= maksud saya dalam page yg sama dia akan kuarkan output dlm 3 format.. pdf,doc,xls..... dlm waktu yg sama.. kalo ko blehh kasi link buat rujukan pun dh cukup baguss.. skang nihh setakat yg jumpe punn x byk membantu...

naikAntena

for q no 1:
set autopostback = true for textbox.

Private Sub TextBox1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox1.TextChanged
        ****your coding for checking****
End Sub

by yien.....




pass parameter or value .. from one page to another page..  atau parameter yg kita set dr page kita ke crystal report parameter nyerr... adalah dgn mengunakann SESSION hahahaha.....

nk export crystal report ke doc, pdf, xls cr sendir... hahaha coding panjang...

naikAntena

for q no 1:
set autopostback = true for textbox.

Private Sub TextBox1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox1.TextChanged
        ****your coding for checking****
End Sub

by yien.....




pass parameter or value .. from one page to another page..  atau parameter yg kita set dr page kita ke crystal report parameter nyerr... adalah dgn mengunakann SESSION hahahaha.....

nk export crystal report ke doc, pdf, xls cr sendir... hahaha coding panjang...

naikAntena

for q no 1:
set autopostback = true for textbox.

Private Sub TextBox1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox1.TextChanged
        ****your coding for checking****
End Sub

by yien.....




pass parameter or value .. from one page to another page..  atau parameter yg kita set dr page kita ke crystal report parameter nyerr... adalah dgn mengunakann SESSION hahahaha.....

nk export crystal report ke doc, pdf, xls cr sendir... hahaha coding panjang...

naikAntena

jumaat aku baru naik tarf crystal report 9 to 10.....

jd aku telupa lakk benda tuhh kn addr refence dulu.. pastuh set sket dia nyer kt web config.... pastuhh tagprevix version nyer.. ngan token dia..

so sini saper to ahh pasal crytal report 10 nyerr solution prblem aku tuh!!!aku dh r&d problem nihh kt mcm laman tp still x jumpe solution nih!!!

tolong ahh!!!thank you... minta  tlong pakar2

naikAntena

camm nerkk nk print report viewer... care js xnk.. sbb kali nih xsesuaii...
(Dim startScript As String = "<script language='javascript'>prncurrdoc();</script>"
        Page.RegisterStartupScript("outputtoprinter", startScript))


nk cara lainnn... tolong lh otai2...

[ Last edited by  naikAntena at 23-11-2007 04:15 PM ]