Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Expandability in Excel Crystal report Post Reply Post New Topic
Author Message
Ashwini
Newbie
Newbie


Joined: 25 Feb 2013
Location: India
Online Status: Offline
Posts: 4
Quote Ashwini Replybullet Topic: Expandability in Excel Crystal report
     Posted: 25 Feb 2013 at 8:19pm
Hi,
 
I am using Crystal reports 11 in VS 2010.
 
I am not getting how to create expandability feature in excel crystal report format,is it possile to create Using CR 11 or we need to write a code to do the above functionality.
 
Please help me regarding this.
 
 
IP IP Logged
Sastry
Moderator
Moderator
Avatar

Joined: 16 Jul 2012
Online Status: Offline
Posts: 537
Quote Sastry Replybullet Posted: 26 Feb 2013 at 7:24pm
Hi

Not getting what is expandability  ?.. u mean while exporting report to excel you are loosing formatting ?

or

You need more rows in excel  ?
Thanks,
Sastry
IP IP Logged
Ashwini
Newbie
Newbie


Joined: 25 Feb 2013
Location: India
Online Status: Offline
Posts: 4
Quote Ashwini Replybullet Posted: 26 Feb 2013 at 8:11pm
I mean grouping in Crystal reports ("SubTotal in Excel") with plus and minus signs.
 
 
I am using ExcelDataOnlyFormatOptions, so i am able to apply formatting and colour but i am not sure about the grouping in crystal reports 11.Is it possible achieve in crystal reports 11 or we need to do excel programming.
 
 
Ashwini
IP IP Logged
Sastry
Moderator
Moderator
Avatar

Joined: 16 Jul 2012
Online Status: Offline
Posts: 537
Quote Sastry Replybullet Posted: 26 Feb 2013 at 11:51pm
HI

Yes.. it is possible to group and insert totals / sub totals / group totals through crystal reports 11.
Thanks,
Sastry
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 27 Feb 2013 at 3:42am
Do you mean having the Expand and Collapse in Excel as if you're using an Excel Pivot Table?  If that's the case, it's not possible. 
-Dell
Proviti, Data & Analytics Practice
www.protiviti.com/US-en/data-management-advanced-analytics
IP IP Logged
Ashwini
Newbie
Newbie


Joined: 25 Feb 2013
Location: India
Online Status: Offline
Posts: 4
Quote Ashwini Replybullet Posted: 28 Feb 2013 at 12:14am
If its possible can u tell me the procedure to do grouping in crystal reports.
Ashwini
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 28 Feb 2013 at 6:46am
Click on the "Group" button and add a group.  Or you can do grouping by using a cross-tab with your data.  It all depends on what your data looks like and what you're trying to do with it.
 
-Dell
Proviti, Data & Analytics Practice
www.protiviti.com/US-en/data-management-advanced-analytics
IP IP Logged
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | BAEZL

© 2004-2026 Brian Bischof. All Rights Reserved.