Dynamo3209
Programmer
Hi,
I am pulling out some records from the database like ClientName, OrderID, ClientLocation, Productsordered.
I have to generate a report in coldfusion for total orders received by client name and location and give a breakup of products ordered.
Something like this
I can get the query to display
but the problem is how do I display this in one row in a report format like I mentioned above
Thanks,
Dynamo
I am pulling out some records from the database like ClientName, OrderID, ClientLocation, Productsordered.
I have to generate a report in coldfusion for total orders received by client name and location and give a breakup of products ordered.
Something like this
Code:
Client1 - Location1 TotalOrders Product1, Product2, Product3
Client1-Location2 TotalOrders Product1, Product2, Product3
Client2-Location1 TotalOrders Product1, Product2 Product3
Code:
client1 Location1 totalorders product1
client1 location1 totalorders product2
etc..
client2 location1 totalorders product1
and so on
Code:
client1 location1 totalorders(for all products) product1(#of orders) product2(no of orders)
Thanks,
Dynamo