tylerjones
Programmer
Okay, I've got to create an invoice for a customer and someone on a message board told me that crystal reports is the best way to do this. So, I've tried playing around with it a bit, but from what I see, it looks like I have to create one big query that spits out the results on the form. Unfortunately, the way our database is set up, I have to run about 3 different queries to generate the page. So, for example, I need to put the billing and shipping addresses at the top of the page, so for shipping, I'd do something like....
select * from addresses where addresstype = 0
and then display the address info in the shipping portion. Then I need to do the same thing for billing, but where addresstype = 1. Then I have to go through all the customers order info too. So, as you can see, there's quite a bit that I have to pull in on one page and one query isn't going to do it all for me. So, can anyone tell me how to create multiple queries for one report?
Question number 2 has to do with feeding in the order information. In order to generate the form, it will all be based off of an order id. So, I'm used to asp which would do something like...
select * from orders where orderid = " & request.querystring("orderID"
... but I have no idea how to make the form dynamic like this in crystal reports. So, again, anyone know how to do this?
I guess if anyone knows of any tutorials that address this subject specifically, that would be wonderful. Thanks for any help you can offer!!!
select * from addresses where addresstype = 0
and then display the address info in the shipping portion. Then I need to do the same thing for billing, but where addresstype = 1. Then I have to go through all the customers order info too. So, as you can see, there's quite a bit that I have to pull in on one page and one query isn't going to do it all for me. So, can anyone tell me how to create multiple queries for one report?
Question number 2 has to do with feeding in the order information. In order to generate the form, it will all be based off of an order id. So, I'm used to asp which would do something like...
select * from orders where orderid = " & request.querystring("orderID"
... but I have no idea how to make the form dynamic like this in crystal reports. So, again, anyone know how to do this?
I guess if anyone knows of any tutorials that address this subject specifically, that would be wonderful. Thanks for any help you can offer!!!