I am using C#, MySQL and Crystal Reports.
I am new to Crystal Reports and trying to generate monthly statement of customer. I have created a stored procedure which will return invoice number and amount, which is fine, showing many invoice number and amount.
But I need to show details of invoice by calling another stored procedure. Like if invoice number 1 contains 10 product then need to show product name in next line underneath. I don't know if this is doable using Crystal Reports or not. I have searched on internet about this. But not much information.