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?
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
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
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