Hi frineds..

I am developing an inventorycontrol s/w for a cell phone distribustor...
Developing project using VB .NET and Sql Server 2000 database. I have 
follwoing 3 tables in my database..

1) WirelssVendor
vendorID   (P)
VendorName

2) Manufacturer

manufacturerID (P)
manufacturerName

3) CellPhoneMaseter
cellphoneID (P)
vendorID(F)
manufacturerID (F)
modelNo
esnNo
Price
isSold( boolean value 0/1)
sellingDate
features
isGSM

now, I want to design a report displaying the total number  of cellphone 
sold for each cellphone model for the given date range ( for eg. 1/2/2002 to 
2/2/2002). I am using Crystal report  for vb.net to desing the report.

I desinged the report using the report wizardand/expert.. it runs the report 
successfully.. but it doesn't show the data.. what could be possible reason? 
i cheked in my database there are records which matches the given criteria.

and another question... in the privous method i specified the database 
connection property at desing time... i want to specify it at runtime.. how 
can i do it? I tried to do it using TableLogOnInfo object of 
crystalReportViewer , but i could not succeed.. can any one help me solving 
this problem. It will be very much appreciated.

thank you..

Dipika Mistry



_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com