SSRS Report problem with the datatable

Question

3.50/5 (2 votes)

See more:

, +

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:

http://sevakabedi.com/grid.jpg[^]

so after making sure that the data within the DataTable is correct I run this code:

MIDL

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:
http://www.sevakabedi.com/report.jpg[^]

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[^]

Posted 2-Mar-11 21:36pm

Mastersev

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

thatraja · Accepted Answer · 2011-03-03T02:33:00

Solution 1

OP wrote:
Question no 1: Why there is no Channel ID?

Did you mean 'Call channel No'? BTW check whether that field has any properties/formatting(visibility, color, etc,) or small width...I'm sure it will be a minor issue.

OP wrote:
Question no 2: Why Why is the Call Date in long date format?

You should change the format, you can...look at these posts.
Report Design (rdlc) - how to format a date string[^]

FormatDateTime in rdlc report[^]

BTW I can't open your project because I have VS 2008.

Posted 3-Mar-11 2:33am

thatraja

Comments

Mastersev 3-Mar-11 11:25am

the call date is fixed. I changed the textbox format to d.

thatraja 3-Mar-11 12:01pm

what about the other one? fixed that too?

Mastersev 3-Mar-11 12:11pm

just fixed it, the name of the datatable field in the DATASET was wrong, I changed it too the exact name in the query and it worked.

thatraja 4-Mar-11 11:13am

Glad you have fixed the other one yourself.
BTW we are here in CP for you all, you can come here any time. Cheers :)