help group rows after exporting report to Excel! :(

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

serhio - 21 Apr 2008 16:50 GMT

Hello,

I have the following issue:
After exporting Crystal report file in Excel, I can't group the rows
in the exported file.

I mean, when I open an exported in Excel report, I can press the
"Group" button, but this haven't any result.

I don't know what exactly happens, but if a copy the content in a new
excel file, the ancient "grouped" rows appears (correctly) in group,
like I expected in the exported file.

Somebody has any idea, why this happens or how this can be fixed?

see also
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=3202637&SiteID=1

Reply to this Message

serhio - 21 Apr 2008 17:15 GMT

An example of such file can be found there:

http://serhio.atspace.com/vasile.xls

> Hello,
>
[quoted text clipped - 12 lines]
>
> see alsohttp://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=3202637&SiteID=1

Reply to this Message

serhio - 22 Apr 2008 10:29 GMT

The problem is that when exporting Crystal parametrize in a certain
manner the file, that is not like a "normal" excel file.

If I copy the content on a new workbook, keeping the original source
formatting, the "real" file contains some "changed" colors.
In the exported from Crystal reports Excel File it's impossible to
group the rows(in reality, the groupment is not reflected to the
user). In its copy - yes.

you can see a image with original report, exported file, and its copy
(here)
- http://picasaweb.google.ru/gserhio/Crystal/photo#5191995425026408306

I am afraid that this is not a excel programming problem...

> An example of such file can be found there:
>
[quoted text clipped - 16 lines]
>
> > see alsohttp://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=3202637&SiteID=1

Reply to this Message

Rate this thread: