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

Comments

  • edited 5:15AM
    Hi,

    can you upload the frx file so we can get a better idea of whats going on.

    Best Regards,
    Keeper
  • edited October 2013
    When i use preview from designer window then total is correct but when i run from vb .net then total is double
    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()

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.