Exporting to Excel

[GMAN33]

Hi All

Using Crystal Reports Developer XI against Oracle 10 DB.

I have a report that contains a couple of groups

The way the report is formatted now, looks very nice but they would like it in Excel and not PDF

When I export to Excel, the grouped fields repeat multiple times as expected...

Is there a way of not repeating the group fields when they contain several detail lines

So now I have

CASE 1 date1 date1
CASE 1 date2 date2
...

I need for it to be
CASE 1 date1 date1
date2 date2

Any help would be appreciated

Thanks

 

[Madawc]

Excel with show more or less what the report shows, though columns can slip. If you want a different look, add a parameter and show the main report in two different formats, one for its own use and one for export.

If columns slip, adding a blank text box in the correct position may cure it.

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP

 

[SkipVought]

Hi,

That can be handled very nicely in Excel using a Conditional Format, to color the font WHITE or the same shade as the cell interior.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[lbass]

What report section is being displayed--group header, group footer, detail? It looks like it is actually the detail section, not a group header or footer. If it is a detail section, you should be able to suppress the group field, by just using:

{table.groupfield} = previous({table.groupfield})

-LB