Hi
I have built a VB.NET app (in VS2003) that does (successfully) various things with SQL2000 tables and I'd like it to also do some reporting on these table.
The system revolves around us (an auto engineering company) receiving pallets containing a number of returned items from customers that are faulty.
It books in the pallet to a table called (surprisingly) Pallets, and the contents to a table called Pumps. We have other tables with Dealer and Customer data on that is relevant to this app.
I've built a couple of reports using Crystal Reports and am now extending them to allow selection by parameters.
Initially, a single parameter is fine to simply select a pallet and report the Dealer/Pallet/Pumps details in a nice elegant fashion.
I can even make it select 2 separate parameters to select by Pallet and Fault type.
Now I want the user to be able to enter all sorts of parameters on one form, then pass them all to the CR and do the record selection in there.
This is what stumps me. How do I pass the results of textboxes and pulldown selections to Crystal Reports, I dont seem to be able to 'see' any fields created in VB once I am in CR.
Any and all help gratefully received.
Thanks
I have built a VB.NET app (in VS2003) that does (successfully) various things with SQL2000 tables and I'd like it to also do some reporting on these table.
The system revolves around us (an auto engineering company) receiving pallets containing a number of returned items from customers that are faulty.
It books in the pallet to a table called (surprisingly) Pallets, and the contents to a table called Pumps. We have other tables with Dealer and Customer data on that is relevant to this app.
I've built a couple of reports using Crystal Reports and am now extending them to allow selection by parameters.
Initially, a single parameter is fine to simply select a pallet and report the Dealer/Pallet/Pumps details in a nice elegant fashion.
I can even make it select 2 separate parameters to select by Pallet and Fault type.
Now I want the user to be able to enter all sorts of parameters on one form, then pass them all to the CR and do the record selection in there.
This is what stumps me. How do I pass the results of textboxes and pulldown selections to Crystal Reports, I dont seem to be able to 'see' any fields created in VB once I am in CR.
Any and all help gratefully received.
Thanks