Formatting in Excel
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=21257
Printed Date: 02 May 2024 at 1:51am
Topic: Formatting in Excel
Posted By: achandana01
Subject: Formatting in Excel
Date Posted: 06 Jan 2015 at 9:46am
Hello,
I have data like this
Dept ID CSN
100 1111
100 2222
100 3333
100 4444
100 5555
200 0000
200 6666
200 7777
I grouped it by Dept ID, However when I export this data into excel it should look like this:
Dept ID CSN
Line1 100 1111
2222
3333
4444
5555
Line2 200 0000
6666
7777
basically what I am looking for is when I export the data into excel CSN data should be in a single cell associated to dept ID. dept id
-------------
chand
|
Replies:
Posted By: lockwelle
Date Posted: 12 Jan 2015 at 7:16am
|
yeah, you would think that CR would better with exporting...what I have found is that you have to exacting in lining up all the cells and making them the same width, and then CR is usually pretty good about lining them up as desired.
|
Posted By: Vimal Nair
Date Posted: 27 Jan 2015 at 1:57am
If you need data like this After grouping Dept Id, Supress the values if duplicate in format field. With this the duplicate records wont display in your exported excel.
-------------
Born To Live
|
|