DataTable problem with SSRS in C#

Question

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: http://www.sevakabedi.com/IVR_Reports.zip

Raja Krishnamurthy · Answer

Hi Sevak 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 Nair · Answer

In design mode you can change the formats of every controls. Check you have ChannelId control in design mode.

sevak sevak · Answer

Thank you yes for Call Date customizing the textbox worked. And the channelID name was set wrong in my DATASET DATATABLE I corrected the name and everything is fine now. thank you for helping me out

Rajesh S · Answer

Hi friend 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 calleridcallchannelno convert(varchar(10)calldate101) ivrnodeidivrnodename from tablename