I need help in ReportViewer

Question

0.00/5 (No votes)

See more:

Two queries retrieve data at the same time into two Dataset that they populated separately so that using them in one report like below. One of them retrieves sales details the other payment details both have relationship and as you can see one sales details row related two payment rows and we need to show them under sales details.

I mean this, how do I add Dataset2's PaymentType and PaymentAmount below of DataSet1's rows as a result of its payment's details like above that screen capture. And There is something I need to emphasis that PaymentType can be two, three row but most of it can be only one row. How Do I do this? Help me please I'm open ideas..

Posted 1-Feb-14 17:22pm

Socarsky

Add a Solution

Comments

thatraja 3-Feb-14 5:18am

ReportViewer? which one? Crystal reports? ssrs?

Socarsky 3-Feb-14 5:25am

I think there is only one ReportViewer around which contains exactly those letters together in Visual Studio.

thatraja 3-Feb-14 5:34am

Most of the reporting tools has reportviewers. To save your & time time, include complete details so that you could get quick response.

Socarsky 3-Feb-14 5:45am

I see, well That is Microsoft's origin component.. Actually the issue much more stays on Reports design side and coding. ReportViewer of MS shows reports result. I mean it comes as second step in my case.

thatraja 3-Feb-14 5:51am

I think you forgot to include screenshot(use imgur.com)

Socarsky 3-Feb-14 5:53am

I couldn't add screen shots sorry.. Two images are still staying https://imageshack.com/

Socarsky 3-Feb-14 5:58am

http://imageshack.com/a/img703/4756/28jz.png
http://imageshack.com/a/img690/6803/rhch.png
Hope the way to add their link here like above don't bother you

thatraja 3-Feb-14 6:12am

This is fine but hereafter don't forget to add links in your question. I mentioned that site(imgur) because some people uploads screenshots in NSFW sites.

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 · Answer 1 · 2014-02-03T00:10:00

Solution 1

I think you could do that using Table[^] or Matrix[^]. Probably customization needed.

For more, see http://gotreportviewer.com/[^]

Posted 3-Feb-14 0:10am

thatraja

Comments

Socarsky 3-Feb-14 6:24am

I think those two links' tutorials don't contain two DataSet(s) solution, as far as I checked.

thatraja 3-Feb-14 6:41am

Yep, You could do that using multiple tables. As you know you could add multiple tables in dataset for reports. Check this one

Socarsky 3-Feb-14 6:54am

You've given me good articles that they contains well information to figure out things better in Reports, thanks

thatraja 3-Feb-14 7:41am

Glad to hear that, welcome