Home Devices
New Blog Posts: Merging Reports - Part 1 and Part 2

LookAhead and export to Excel

A question that probably is related to this.

https://rbwiki.digital-metaphors.com/rap/calculations-rap/lookahead-based-calcs/

In some reports we use LookAhead in conjunction with summaries. And the report works fine in preview and on output to paper. But when exporting to Excel the result is different, ie the summary values are different? How come? We can understand the added complexity with LookAhead but if the report manages to come to the correct output in print and preview mode then why not in Excel export?

Comments

  • Hi Kjell,

    Please create a simple example I can build and run in the debugger. Use standard Delphi components and RB. Use the rbDemos data or TClientDataSet. Send zip file to support@

    I tried a simple test and worked without issue.



    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • Hi Nard

    The problem was mediated for us by changing the display format of the report field.
    We have usually used # ##0.00 as display format but changing it to ,0.00### solved the problem.
    Probably it might be due to the space between the hash tags.

    Best regards,
    Kjell
Sign In or Register to comment.