Click here to Skip to main content
12,633,990 members (24,353 online)
Rate this:
 
Please Sign up or sign in to vote.
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):
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 2:17am
Updated 8-Sep-12 2:35am
v5
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?

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

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.161208.2 | Last Updated 8 Sep 2012
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100