Hello,
I have a filled DataTable and I would like to pass it to a Report in c#. before I do this I test the DataTable in a DataGridView to make sure the data is accurate in the result I get this:(LINK TO IMAGE)
so after making sure that the data within the DataTable is correct I run this code:
this.reportViewer1.LocalReport.DataSources.Clear(); this.reportViewer1.LocalReport.DataSources.Add(new ReportDataSource("dsReports", dt)); this.reportViewer1.RefreshReport(); The result that I get in the report is this:
Question no 1: Why there is no Channel ID? Question no 2: Why Why is the Call Date in long date format?
The full source code along with the Database script is available from the link below, you can download it:
Raja KrishnamurthyPosted Mar 3, 2011, 8:07 AM
For Channel ID there could be a datatype mismatch.
For Call Date give the format for that textbox as "d" that should fix the format.
HTH
Suthish NairPosted Mar 3, 2011, 1:56 PM
sevak sevakPosted Mar 3, 2011, 11:23 AM
thank you for helping me out
Rajesh SPosted Mar 3, 2011, 6:21 AM
i didnt download your file eventhough i give suggestion to one of your question. for call date you look the below query, you may get what you desire.
ex: select callerid,callchannelno,convert(varchar(10),calldate,101),ivrnodeid,ivrnodename from tablename