I have a program created using VB 2005 and MS Access 2003. In the program i have created a data grid which is connected using JET.4.0 OLEDB data provider. The data is been entered from text boxes to the data grid. I want to create a report using crystal report parameter passing which comes with vb 2005 itself pro grammatically.
In my program there are 7 text boxes & they are Receipt No,Item No, Description, Qty, Price, Value, Grand Total. There are also 5 Buttons Called Add, Edit, Delete,clear, Print Report. There is a data grid control use to view the data within the table Sales.
The receipt no should generate automatically using the previous receipt numbers countered.
The report or the receipt is generated at the end of each transaction. The grand total is based on total values entered to the data grid within one transaction.
The invoice is based at each change in receipt no. The receipt should have Item No, Description, Qty, Price, Value and at the end Grand total.
That's why I need to pass parameters within crystal reports.
Please give some advice or help to solve this problem. Thank you