Report Viewer Using 2 tables

Question

0.00/5 (No votes)

See more:

Hello Every One,

Good Afternoon !!

Can someone please Help Me ? I have created a report using Report Viewer, i have 2 tables i am able to get the data from both the tables, problem is something like below.

In one table purchase are saved. & in other all my sales saved.

now what i want to show in the report is something like this.

in a report i want all column from Purchase table & only sum of sales where purchase bill no is xyz. which will give me the over view of balance stock as per my purchase invoice.

say like under invoice no :- PPY001 I have purchased 6 phones & I sold 3 phones from same purchase invoice no in 2 parts(1-2). so the report should show me like.

Purchase :- qty 6 sold 3 balance 3

i will be glade if someone can help me on this.

Posted 19-Nov-14 21:59pm

Vinit Mumbai

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)

Praneet Nadkar · Answer 1 · 2014-11-20T00:58:00

Solution 1

Hi Vinit,

Why dont you do that by writing a query in your database and returning you table from their. This way you can easily bind your table to report and show the data and manipulation and maintenance will also be easy.

Posted 20-Nov-14 0:58am

Praneet Nadkar

Comments

Vinit Mumbai 20-Nov-14 7:37am

Hey Good Evening Praneet,

Let me first thank you for replying my query Thank You !!!

However I am new in Coding I dont know much can you please help me with Query ????

[no name] 20-Nov-14 7:39am

Yes, but you need to paste the code here first, for both tables which are being used or reeturned.

Vinit Mumbai 20-Nov-14 7:46am

Hey Dear I have not written any codes yet, what i generally do, from new Items i select data set & USE SQL Statement option there i click on Query Build select both the tables. This auto generates codes for me I am making a windows application in V.S 2013.

member86215483 21-Nov-14 0:09am

Hi Vinit, as Praneet said, you need to write a stored procedure(SP) in the SQL SERVER . Then call this SP from Visual Studio and fetch the table into your dataset.
Search "How to write SP in SQL" in Google

Vinit Mumbai 21-Nov-14 1:06am

Hello Good Morning Praneet,

Thank you for your reply let me try, SP if i still have any prob, i will bother you again. :-)

[no name] 21-Nov-14 1:10am

Yes. np