By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,789 Members | 1,190 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,789 IT Pros & Developers. It's quick & easy.

Report Genterate

P: 7
H dears

this is senny, its my another module to developt the project for day to day production report, Here i am using one form to get the information of date between which date you want production report.For exampl if i want production report of 1-3-2007 to 5-3-2007, then i have to display the production report of five days.According to my project i decided to use Microsoft Excell sheet.But i have no knoledge abt Excell Design and codeing.In the report i have use the Four coloumns , the name like Ordinary,Student,Service,Amt.Can anyone tell the procudure for adding Excell sheet in project and How to check the number of days b/w dates.

regards.
senny
Mar 21 '07 #1
Share this Question
Share on Google+
2 Replies


100+
P: 149
H dears

this is senny, its my another module to developt the project for day to day production report, Here i am using one form to get the information of date between which date you want production report.For exampl if i want production report of 1-3-2007 to 5-3-2007, then i have to display the production report of five days.According to my project i decided to use Microsoft Excell sheet.But i have no knoledge abt Excell Design and codeing.In the report i have use the Four coloumns , the name like Ordinary,Student,Service,Amt.Can anyone tell the procudure for adding Excell sheet in project and How to check the number of days b/w dates.

regards.
senny
To start with you will have to Set a reference in you VB project to the Microsoft Excel Object Library.

Then you can create a new excel application, then a excel workbook and a excel worksheet etc.

thanks
ansuman sahu
Mar 21 '07 #2

100+
P: 375
Try out data reports if you can.
Put on the labels on the page header and textboxes on the details section in the datareport
Name the the textboxes in the datareport excatly similiar to your fields in database.
eg if your fields are empno,joindate,expdate then name it exactly the same.
Now go to vb
use dtpicker control for date and put down this code
'Here M2 is a recordset
M2.Open "select customer_id,orderno,delivery_date,order_date " & _
"from emp where delivery_date>=#" & DTPicker1.Value & "# and delivery_date <=# " & DTPicker2.Value & "# order by delivery_date", _
Mycon, adOpenDynamic, adLockOptimistic
Set DataReport2.DataSource = M2
DataReport2.WindowState = vbMaximized
DataReport2.Show vbModal
M2.Close
Mycon.Close

'mycon is connection
Mar 21 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.