Crystal Reports running totals with Live office

I am trying to insert a few running total amounts into an Xcelsius document but I cannot see the fields when I browse to the report. The running totals are present on the report group footer, but don’t show up when I browse through Live Office. Anything we need to do to use CR Running totals with Live Office?


Abhi719 :us: (BOB member since 2010-12-10)

I did a quick test. You have to make sure you switch to parts instead of fields when adding the report. But using parts instead of fields for Live Office can be tricky. I know that if the groups change (i.e., grouped by employees, but there is no data for an employee during a certain time period), LO will give an error.

If you need a running total displayed in the spreadsheet. It might be better just to have a report with the running total and have a live office connection to it. It is a nuisance, but it works.

I hope this helps.


kevlray :us: (BOB member since 2010-06-23)