Mukesh Kumar Tiwari

Mukesh Kumar Tiwari

  • NA
  • 980
  • 252.5k

Crystal Report Error in Linq To Sql in windows apps.

May 14 2014 6:43 AM
hey i m generating a crystal report in vs 2010 using linq to sql in desktop apps.
But i m getting this error at the click event of the print button. 
 
Error:  DataSet does not support System.Nullable<>
 
my store procedure:
alter proc wholesale_print
(
@invoice_no varchar(15),
@cust_id int
)
as
begin
select cust.customer_name,item.item_name,inv.invoice_no,inv.Qty,inv.price,
inv.item_amount,inv.disc,inv.disc_amt,inv.vat,inv.vat_amt,inv.total_amt
from inv_invoice_detail as inv
inner join Inv_Customer_Name as cust
on inv.cust_id=cust.customer_id
inner join Inv_item_master as item
on inv.item_id=item.item_id
where inv.invoice_no=@invoice_no
and inv.cust_id=@cust_id
end
 
code which i wrote at the click event of print button
 
Inventory_dataDataContext linq = new Inventory_dataDataContext();
 
var abc = linq.wholesale_print(txt_invoice.text,Convert.ToInt32(cmb_cust.selectedvalue);
rpt.SetDataSource(abc);
crystalReportViewer1.ReportSource = rpt;
crystalReportViewer1.Refresh();*/
 

Answers (1)