How to move a prebuilt datatable to reportviewer

Question

0.00/5 (No votes)

See more:

, +

I have a table for our employees to view which we need to print and have them sign.

To do this I'm using the ReportViewer (or trying to. I'm open to other suggestions).

I've read this article but I don't think it's quite what i'm looking for - but close, and if this is the best there is i'll go this method in the end Using-the-ASP-NET-ReportViewer-in-Local-Mode[^]

Q: How to I get my table to the reportviewer? It's not just straight up from a datatable. It's more like - take 5 tables with data from multiple employees on certain jobs and calculate efficiency and report on how this employee measures up sort of table. But it's already made! Can I just pass it through?!

Thank you for your time

What I have tried:

I've read a few of the articles here and looked at many youtube videos to setup everything with the report1.rdlc and reportviewer inside the form. It runs and it's perfect but now I need to get my custom table into the table on the report, that's where I'm stuck.

Posted 8-Sep-16 10:38am

RavonX

Updated 9-Sep-16 11:00am

v3

Add a Solution

Comments

RavonX 8-Sep-16 18:08pm

comment: it seems like maybe the best solution is here in this post http://www.codeproject.com/Articles/473844/Using-Custom-Data-Source-to-create-RDLC-Reports

Where I'll need to create a couple classes and convert my custom table to a list. IDK though. why can't it just take the table?! Still searching around.

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)

RavonX · Accepted Answer · 2016-09-09T11:00:00

Solution 1

found the answer on this page
Binding-Datatable-to-rdlc-report[^]

Basically:
1) setup a new dataset with a datatable defined EXACTLY as your table is
2) use mock dataset in the RDLC to bind to table / list / matrix / etc..
3) link the table to the report using
'ReportViewer1.LocalReport.DataSources.Add(New ReportDataSource("DataSet1", reportTable))'

Finished!

Posted 9-Sep-16 11:00am

RavonX

Comments

Sinisa Hajnal 12-Sep-16 2:30am

Good work! The best problems are the ones you resolve yourself. No quitting :)
I do the same and I'm not familiar with any better method. It works with Crystal Reports too.