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()
None
0 Points
2 Posts
Crystal reports and multiple tables in asp.net
Jan 15, 2015 03:11 PM|Jodelegend|LINK
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()Star
8544 Points
1376 Posts
Re: Crystal reports and multiple tables in asp.net
Jan 16, 2015 03:07 AM|Edwin Guru Singh|LINK
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
Edwin
None
0 Points
2 Posts
Re: Crystal reports and multiple tables in asp.net
Jan 16, 2015 01:19 PM|Jodelegend|LINK
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
Star
8544 Points
1376 Posts
Re: Crystal reports and multiple tables in asp.net
Jan 18, 2015 08:08 PM|Edwin Guru Singh|LINK
Hi Jodelegend,
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
Edwin