davemckenna
asked on
Simple Report with VB6
Folks,
I have a small accounting package designed and running in VB6 (very simple) I want to be able to print reports based on user inputs, i.e. "SELECT PaymentsOut FROM Accounts WHERE ....." which will display the results in a form ready for printing. I have looked at using Crystal Reports which seems like the ideal choice but is too complicated at this stage for me to use as I am running out of time. So I have decided to go the Report Designer route that built into VB6. Will the report designer allow me to display records based on quires generated by user inputs? If you could offer me a simple approach using Crystal reports I would be interested. I have created reports using the report generator/wizard but I am at a loss on how to modify this to display specific quires. I other word the crystal report will generate a report of all invoices and their details, I would like to be able to display the details of just one invoice.
I am running out of time in my submission of a final year project hence the smell of desperation about this question!!
Thanks
I have a small accounting package designed and running in VB6 (very simple) I want to be able to print reports based on user inputs, i.e. "SELECT PaymentsOut FROM Accounts WHERE ....." which will display the results in a form ready for printing. I have looked at using Crystal Reports which seems like the ideal choice but is too complicated at this stage for me to use as I am running out of time. So I have decided to go the Report Designer route that built into VB6. Will the report designer allow me to display records based on quires generated by user inputs? If you could offer me a simple approach using Crystal reports I would be interested. I have created reports using the report generator/wizard but I am at a loss on how to modify this to display specific quires. I other word the crystal report will generate a report of all invoices and their details, I would like to be able to display the details of just one invoice.
I am running out of time in my submission of a final year project hence the smell of desperation about this question!!
Thanks
ASKER
Thats great, Thanks. What i would like to be able to is Show the details of an invoice which is held on one table, then show the details of another table namely InvoiceItems which shows a breakdown of the invoice with totals etc. Invoices are linked in a one-to-many relationship with InvoiceItems via InvoiceNumber. Should i look to insert a sub report? ,Or could this be handled through an SQL statement? How would i go about either of these?
Thanks
Dave
Thanks
Dave
SubReport does not exist in datareport!
You have to JOIN your tables together into the same query and use the GROUP feature to print your header.
You have to JOIN your tables together into the same query and use the GROUP feature to print your header.
ASKER
OK that explains the futility of trying sub reports!
Do i join the tables using SQL on a command whithin the DataEnviroment? Would you have a link to show me how to do this?
I know this is going away slightly from the main question, i will award points soon and start a new quesiton shortly if this gets much further.
Thanks
Dave
Do i join the tables using SQL on a command whithin the DataEnviroment? Would you have a link to show me how to do this?
I know this is going away slightly from the main question, i will award points soon and start a new quesiton shortly if this gets much further.
Thanks
Dave
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks you.
http://vbcity.com/forums/faq.asp?fid=8&cat=DataReport&#TID20722
jk