Hello every1;

- How to display the results of a view and a stored procedure in the same crystal report
i have the following view :

create view ViewPurchaseInvoiceProducts
as
SELECT dbo.PurchaseInvoices.PInvoiceId, dbo.Drugs.Drug, PurchaseInvoicesproducts.Quantity
FROM PurchaseInvoicesproducts INNER JOIN
PurchaseInvoices ON dbo.PurchaseInvoicesproducts.InvoiceId = dbo.PurchaseInvoices.PInvoiceId INNER JOIN
Drugs ON dbo.PurchaseInvoicesproducts.DrugId = dbo.Drugs.DrugId
go

the report should contain the Purchase invoice id in the title and in the details section it should be the list of products(drugs) and their quantity ,

and there is the client name and its address come from another stored procedure.
- How to pass a parameter from the code behind to the crystal report by the statement SetParameterValue() method.
- How to allow the user to customize the crystal report as he wants so that the user add or remove the columns that appear in the report.