there is no data show in my crystal report

flodi

Member
Joined
Jan 23, 2008
Messages
15
Location
Makkah Al Mukarramah, Makkah, Saudi Arabia, Saudi
Programming Experience
Beginner
hi to all
i creat a program with vb.net2005 and database sql server express 2005
i create a report with crystal report 10
i write the following code to generate the report
VB.NET:
dim crd as new reportdocument
crd.load("my report place\crystalreport1.rpt")
dim crpfds as parameterfielddefinitions
dim crpfd as parameterfielddefinition
dim crpv as new parametervalues
dim crpdv as new parameterdiscretevalue
crpdv.value=textbox1.text
crpfds=crd.datadefinition.parameterfields
crpfd=crpfds.item("my parameter name")
crpv=crpfd.currentvalues
crpv.clear
crpv.add(crpdv)
crpfd.applycurrentvalues(crpv)
crystalreportviewer1.reportsource=crd
crystalreportviewer1.refresh
the problem is its run okay but there is no data in the report!!!!
why is that happen?
another problem
when i try to make connection to my server from crystal report 10 in datadase expert > create new conection > oledb ado and then write server name which is my pc (computer\sqlexpress) it fialed and show the following message:
logon failed
ado error code:0x
sql state:28000

is that problem in connection cause the other problem that make my report blank?
thx
 
Top Bottom