Total
Hai
I have a field called Income. I added Income_total in data window in Totals. When I add Income_total
in report and when I run I get the sum of the field Income but the sum is double the value. I have added another field also but the same doubling of sum comes. What is the problem?.
Thanks
I have a field called Income. I added Income_total in data window in Totals. When I add Income_total
in report and when I run I get the sum of the field Income but the sum is double the value. I have added another field also but the same doubling of sum comes. What is the problem?.
Thanks
Comments
can you upload the frx file so we can get a better idea of whats going on.
Best Regards,
Keeper
I use sql 2008 as database
con is the connection string
I use this code in vb
'PreviewCont is a preview control added on a form
'Rpt_Main is a report control on form
Dim ReportName As String
ReportName = Environment.CurrentDirectory & "\FReport\LedgerPersonalCash.frx"
Rpt_Main.Load(ReportName)
Rpt_Main.Dictionary.Connections(0).ConnectionString = Con.ConnectionString
Rpt_Main.Preview = PreviewCont
Rpt_Main.Prepare()
Rpt_Main.Show()