export group name using formula?

[matis]

hello. i'm having a problem exporting reports to excel:
(actually happpens in all export formats)

i have a column within a crosstab that is generated by a formula. when the report is exported, the formula result does not appear, only the "group by" parameter.

if that's unclear, i'll include the specifics:
what appears in the report in CR8 is a group name, generated by a forumla:
totext({Chart.AccountID}) + ": "+{Chart.Description}

in the report, this works fine - the column displays the account ID and the account description fields combined into one text label.

when i export, only the account ID shows up. the data is grouped by account ID, so i'm assuming that the program is exporting the "group by" data instead of the result of the group name formula.

has anyone else solved this problem?
thanks,
jon

 

[matis]

ok, i answered my own question searching the knowledge base at crystaldecisions.com.

for step-by-step workaround solution, see:

http://support.crystaldecisions.com/library/kbase/articles/c2009392.asp