Home > Archive > Visual Basic Crystal Reports > March 2006 > Exporting reports
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Chubbly Geezer 2006-03-24, 8:04 am |
| I have a small Vb app that displays Crystal Reports with a report viewer
control. This works fine. When I export a report to Excel from my pc and
then load that report within Excel again it all works fine, with the data
nicely aligned within the relevant columns. However, when exporting the
same report from 2 other pc's, I find when I load the report within Excel
that the data is all misaligned.
Any ideas welcome please.
| |
| George Hardy 2006-03-24, 7:11 pm |
| there are two ways to export to excel. one way is export to xls, and the
other is to xls with data only.
i found that the first method seems to do a "column span" on certain long
fields, that seems to goof up certain reports.
see if this helps.
gh
"Chubbly Geezer" <chubbly_geezer@newsgroup.nospam> wrote in message
news:uLRZHC0TGHA.2244@TK2MSFTNGP14.phx.gbl...
>I have a small Vb app that displays Crystal Reports with a report viewer
>control. This works fine. When I export a report to Excel from my pc and
>then load that report within Excel again it all works fine, with the data
>nicely aligned within the relevant columns. However, when exporting the
>same report from 2 other pc's, I find when I load the report within Excel
>that the data is all misaligned.
>
> Any ideas welcome please.
>
| |
| Chubbly Geezer 2006-03-24, 7:11 pm |
| Seems to work fine thx. Not sure why both methods work on some pc's
however.
"George Hardy" <spamlessihope-ghardy@usmedequip.com> wrote in message
news:%23kgyLT2TGHA.1160@TK2MSFTNGP09.phx.gbl...
> there are two ways to export to excel. one way is export to xls, and the
> other is to xls with data only.
>
> i found that the first method seems to do a "column span" on certain long
> fields, that seems to goof up certain reports.
>
> see if this helps.
>
> gh
>
>
>
> "Chubbly Geezer" <chubbly_geezer@newsgroup.nospam> wrote in message
> news:uLRZHC0TGHA.2244@TK2MSFTNGP14.phx.gbl...
>
>
| |
| George Hardy 2006-03-24, 7:11 pm |
| my guess is different versions of MS Office. Maybe some machines have
office with certain service packs applied.
ya got me.
gh
"Chubbly Geezer" <chubbly_geezer@newsgroup.nospam> wrote in message
news:OzI17b2TGHA.3192@TK2MSFTNGP09.phx.gbl...
> Seems to work fine thx. Not sure why both methods work on some pc's
> however.
>
>
> "George Hardy" <spamlessihope-ghardy@usmedequip.com> wrote in message
> news:%23kgyLT2TGHA.1160@TK2MSFTNGP09.phx.gbl...
>
>
|
|
|
|
|