Crystal reports and multiple tables in asp.net

Question

User533542888 posted

Please help me to access this asp.net code for crystal report. it is working with vb.net but not with asp.net

dim dts as integer=1
Dim ds As New DataSet
Dim da As New SqlDataAdapter("select * from Billinfo b, Item_Sold i where b.iBill_no=IBill_No and b.iBill_no = " & dts, conn)
Openconnection()

da.Fill(ds, "Item_Sold")

Dim obj As New TransactionReportPrint
obj.Database.Tables(0).SetDataSource(ds.Tables("Item_Sold"))
CrystalReportViewer1.ReportSource = obj
conn.Close()

Answer 1

User1711366110 posted

Hi jodelegend,  
   As per your case, Refer the following link which may guide you to retrieve the data from db & fill into Crystal report in ASP.Net.
http://www.aspsnippets.com/Articles/Crystal-Report-ASPNet-Example-using-DataSet-or-DataTable-in-C-VBNet-and-Visual-Studio-2010.aspx

--
with regards,
Edwin

Answer 2

User533542888 posted

Hi E. Gurus,

I considered the link but it only uses one table and it has no condition(i.e select from tablename where ............)

I've really tried it numerous times but no luck

Answer 3

User1711366110 posted

Hi Jodelegend,
 

I considered the link but it only uses one table and it has no condition(i.e select from tablename where ............)

As per this case, You have to create stored procedure in DB .Then pull that SP into crystal report.
For your reference,Check the following link :

http://www.aspsnippets.com/Articles/Create-Crystal-Report-using-Stored-Procedure-in-ASPNet-with-C-and-VBNet.aspx

--
with regards,
Edwin