I want to print the store requisition paper I don't know how

Question

4.00/5 (1 vote)

See more:

I'm doing a small tool to make it easy for us to print store requisitions by selecting the materials from a list then filling the datagrid.
once done, all will be stored in a database as shown below. (I've done all procedures and the program lack the printing thing)

the database (STRE):

HTML

table[req]:serial(PK: auto number), project(varchar), prijectID(varchar), orddate(date)
table[det]:id(PK: auto number), serial(FK: number), matcode(varchar), matdet(varchar), unit(varchar), qty(number).

I don't know how to make the report, suppose I want to print the items which we ordered from store which having the serial number (3).

please help me if any one knows the solution.

the data must be pulled from 2 tables on the FK(det.serial).

Posted 8-Sep-12 1:17am

yasser_ja

Updated 8-Sep-12 1:35am

v5

Add a Solution

Comments

Thilina Chandima 8-Sep-12 22:07pm

please explain more. do you know how to use crystal report with C#...? do you know the methods which can use to fill the crystal report. I mean explain to us what level of knowledge you have regarding reporting in C#.

yasser_ja 9-Sep-12 1:38am

I don't know very much to be honest...
Only that it uses SQL to generate the report.
I found that in my case I gotta make a query with: SELECT + INNER JOIN + WHERE
But I don't know where to put or Edit the query.

Thilina Chandima 9-Sep-12 7:42am

actually I am not sure about you problem, are you mean "SQL to generate the report." is you using sql server reporting service or are you use any other tool like crystal report.. please explain what you are doing step by step then i hope i can help you otherwise i don't have any idea what is you doing...

yasser_ja 9-Sep-12 7:49am

Nothing is working with me.
I am confused what do I need to fill the report.
I created a Dataset and inside it I created Datatable with a test query:
SELECT Orders.Serial, Details.Descr
FROM Details INNER JOIN
Orders ON Details.Serial = Orders.Serial
WHERE (Orders.Serial LIKE '15')

And I got a result finally, but how to fix it with a report?

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)