there are many option to choose table...such as
1.Current connection
2. History
3.favorites
4.ODBC
5. Database file
6.More Date source
7.MetaData /Query
when i explore 6th one then there are more option
a.active data
b. local file system
c.microsoft sql server
d.OLEDB
and when i explore the OLEDB then two option
i.make new connection
ii. connection using data link file
i choose 1st one make new connection and provide information about database then i get every table and views from my database but not stored procedure
when i try to Active Data through ADO(OLEDB) then same problem occurs please suggest me what can i do?
please help me ...
thanks
Rekha SinghPosted Jan 7, 2010, 6:05 AM
try adding a freash crystal report and make a new connection using these steps
select 5th from following option
1.project data
2.current connection
3.favorites
4.History
5.Create new connection
Create new connection - access/Excel(DAO)
ADO.NET
Database Files
ODBC(RDO)
OLEDB(ADO)
More Data Sources
select OLEDB(ADO) - select Microsoft OLEDB Provider for sql Server
click Next
give servername ,database name n others
click FINISH
u get ur database connected ur crystal report which includes tables views and stored procedures
see this link.. it will help u out
http://www.beansoftware.com/ASP.NET-Tutorials/Using-Crystal-Reports.aspx