Crystal Report Invoice Problem

See more:

C#

reporting

hi
I have a winform invoice, it calculate correctly and show total invoice ...

After save I have to print the invoice

I use the store procedure

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[PrintInvoice]

@iInvoiceno int

AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
SELECT *
FROM dbo.acc_Invoice_v
Where dbo.acc_Invoice_v.iInvoiceno = @iInvoiceno
Order by dbo.acc_Invoice_v.iLine
END

acc_Invoice_v is a view for parent and child invoice for multiple items

when print crystal report the total invoice is wrong which is not as shown on the screen and saved

the total invoice is a field in the view

thanks in advance