Print Page | Close Window

Need help to design Stock Report

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=5467
Printed Date: 16 May 2024 at 7:33pm


Topic: Need help to design Stock Report
Posted By: palanikumar
Subject: Need help to design Stock Report
Date Posted: 09 Feb 2009 at 7:19pm
Hi to all,
 
I want to desing a stock report like this
 
 
Date           Material           Type       S/P        Quantity
 
10/02/2009  Pen              Geltype   Sold       10 Items
                     Paper          A3           Sold         1 Bundal
                     Note Book   Scribling  Sold         5 Books
 
11/02/2009  Notebook    Scribling  Purchase 10 Books
                    Pen              Geltype   Purchase  5 Items
                    Paper           A4           Purchase  2 Bundals
 
 
In this report i am using more than 3 access tables,I run a query and
bind the data to a dataset.
 
and by using this code
 
report.setdatsource(dset)
crystalreportviewer1.Reportsource = report
 
but the dataset data is not reflecting in the report...
while design I connect the database by using  command only
in command ... the query i written was "SELECT  date,material,type,sp,quantity from stock"
 
Kindly help me to get output from this probs
 
 
 
 
 
 


Print Page | Close Window