/support/notes/service/sap_logo.png){kind=logo}
SAP Knowledge Base Article - PublicSymptom
Exporting a report to Microsoft Excel causes shifted columns and blank rows to be inserted in the exported file.
Cause
< p > T h i s b e h a v i o r o c c u r s b e c a u s e e x p o r t i n g t o E x c e l p l a c e s r e p o r t
o b j e c t s i n t o c e l l s . C r y s t a l R e p o r t s w i l l t r y t o p u t o b j e c t s i n t o
c e l l s i n s u c h a w a y a s t o p r e s e r v e t h e l o o k o f t h e o r i g i n a l
r e p o r t . < / p >
Resolution
< p > T o i m p r o v e t h e a p p e a r a n c e o f r e p o r t s e x p o r t e d t o E x c e l , t h e r e p o r t m u s t b e f o r m a t t e d p r e c i s e l y b e f o r e e x p o r t i n g . F o l l o w t h e s e d e s i g n a n d e x p o r t i n g g u i d e l i n e s . < / p > < d i v > E n a b l e S n a p t o G r i d : < / d i v > < o l s t a r t = " 1 " > < l i > C l i c k < s t r o n g > F i l e < / s t r o n g > & g t ; < s t r o n g > O p t i o n s < / s t r o n g > . < / l i > < l i > C l i c k t h e < s t r o n g > L a y o u t < / s t r o n g > t a b , t h e n s e l e c t < s t r o n g > S n a p t o G r i d < / s t r o n g > i n t h e < s t r o n g > G r i d O p t i o n s < / s t r o n g > s e c t i o n . < / l i > < l i > < d i v > C l i c k < s t r o n g > O K < / s t r o n g > t o r e t u r n t o t h e r e p o r t . < / d i v > < / l i > < / o l > < d i v > U s e g u i d e l i n e s : < / d i v > < o l s t a r t = " 1 " > < l i > C l i c k < s t r o n g > F i l e < / s t r o n g > & g t ; < s t r o n g > O p t i o n s < / s t r o n g > . < / l i > < l i > C l i c k t h e < s t r o n g > L a y o u t < / s t r o n g > t a b , t h e n c l i c k ' S h o w g u i d e l i n e s i n D e s i g n ' a n d ' S h o w g u i d e l i n e s i n P r e v i e w ' i n t h e ' V i e w O p t i o n s ' s e c t i o n . < / l i > < l i > C l i c k ' O K ' t o r e t u r n t o t h e r e p o r t . < / l i > < l i > C l i c k t h e h o r i z o n t a l o r v e r t i c a l r u l e r ( a b o v e o r t o t h e l e f t o f t h e r e p o r t ) w h e r e y o u w a n t t o i n s e r t a g u i d e l i n e . A n e w g u i d e l i n e i s i n s e r t e d a t t h e p o i n t y o u c l i c k e d . O b j e c t s d r a g g e d t o g u i d e l i n e s ' s n a p ' t o t h e m . < / l i > < / o l > < d i v > E n s u r e f i e l d s a n d o b j e c t s d o n o t o v e r l a p : < / d i v > < o l s t a r t = " 1 " > < l i > C l i c k t h e < s t r o n g > D e s i g n < / s t r o n g > t a b . < / l i > < l i > < d i v > M o v e o r r e s i z e a l l o b j e c t s s o t h a t t h e i r b o r d e r s d o n o t t o u c h o r o v e r l a p . < / d i v > < / l i > < l i > < d i v > S e t a l l o b j e c t s i n t h e s a m e r o w t o t h e s a m e h e i g h t , a n d i n t h e s a m e c o l u m n t o t h e s a m e w i d t h . < / d i v > < / l i > < l i > < d i v > M i n i m i z e g a p s b e t w e e n o b j e c t s . S e t g a p s t o t h e s a m e h e i g h t a n d w i d t h . < / d i v > < / l i > < l i > < d i v > S e t t h e w i d t h o f a l l o b j e c t s t o t h e m i n i m u m r e q u i r e d t o d i s p l a y t h e w h o l e o b j e c t . < / d i v > < / l i > < / o l > < d i v > E x p o r t i n g s u g g e s t i o n : < / d i v > < o l s t a r t = " 1 " > < l i > U n d e r < s t r o n g > C o l u m n W i d t h < / s t r o n g > , c h o o s e < s t r o n g > C o l u m n w i d t h b a s e d o n o b j e c t s i n t h e < / s t r o n g > a n d t h e n s e l e c t t h e s e c t i o n t h a t c o n t a i n s t h e w i d e s t o b j e c t s ( s u c h a s D e t a i l s o r a G r o u p F o o t e r ) . < / l i > < / o l > < t a b l e b o r d e r = " 0 " c e l l p a d d i n g = " 5 " s t y l e = " w i d t h : 1 0 0 % ; b o r d e r - c o l l a p s e : c o l l a p s e " > < t b o d y > < t r > < t d s t y l e = " v e r t i c a l - a l i g n : t o p ; w i d t h : 7 0 p x ; b o r d e r : b l a c k 1 p x s o l i d " > < p a l i g n = " c e n t e r " > < s t r o n g > N O T E < / s t r o n g > < / p > < / t d > < t d s t y l e = " v e r t i c a l - a l i g n : t o p ; b o r d e r : b l a c k 1 p x s o l i d " > < p > I f n o p a r t i c u l a r s e c t i o n c o n t a i n s t h e m a j o r i t y o f t h e r e p o r t d a t a , s e l e c t t h e < s t r o n g > C o n s t a n t C o l u m n W i d t h < / s t r o n g > o p t i o n a n d e x p e r i m e n t w i t h w i d t h s . < / p > < / t d > < / t r > < / t b o d y > < / t a b l e >
See Also
For more information about exporting to Excel, refer to the article Crystal Reports Designer Version 10: Exporting to Microsoft Excel on SCN. (The article is specific to Crystal Reports 10; however, the principles are equally valid for CR XI r1, r2, CR2008 and higher versions .)
Keywords
E X C E L E X P O R T E X P O R T I N G A L I G N M E N T C O L U M N R O W B L A N K F O R M A T T I N G F O R M A T S e a g a t e C r y s t a l R e p o r t s E x p o r t i n g t o t o a n y v e r s i o n o f E x c e l C o l u m n s c h a n g e p o s i t i o n a n d e x t r a b l a n k r o w s a r e i n s e r t e d , c 2 0 0 6 2 4 4 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To
Product
Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports XI ; SAP Crystal Reports XI R2