-----------------------------------------------------------

New Message on BDOTNET

-----------------------------------------------------------
From: Ravikumarcbe
Message 1 in Discussion

    
Hi, 
     I need some suggestion for using crystal report. 
Which is the best approach to use crystal report? 
1.  Thru stored procedure? 
2.  Create a view and use the selection formula to select the record, in this case how 
to specify the server name and database name?  
     any sample code to use stored procedures in crystal report and also sample code 
to use view ? using vb.net 
    
I got an error while using the sp, I have ap with 2 datatime parameter, while 
designing report itself it gave me an error saying,  Not supported Details :ADO Error 
code 0x80040e14 source:microsoft oledb provider sql server description:incorrect 
syntax near the keyword CONVERT sql state: 42000 native error:156 
I have not used convert inside the sp, 
 If I remove the datetime parameter from sp it works fine 
  
Thanx in advance 
  
Rgds, 
Ravi 
  
     

-----------------------------------------------------------

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the "Remove" link below. On the pre-addressed 
e-mail message that opens, simply click "Send". Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]

Reply via email to