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 callerid,callchannelno, convert(varchar(10),calldate,101) ,ivrnodeid,ivrnodename from tablename