Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Two Coss-Tabs in One Report Post Reply Post New Topic
Author Message
sheriey
Newbie
Newbie


Joined: 11 May 2010
Online Status: Offline
Posts: 2
Quote sheriey Replybullet Topic: Two Coss-Tabs in One Report
     Posted: 11 May 2010 at 9:50am
Hi,
I need some help urgently.

I am working in Crystal 2008.

I have a report with a chart and a cross-tab table with a SUM in summary field. It looks fine. Now I want to include another cross-tab with the percentage in the summary field. When I do this it destroys the results in the first cross-tab table and in a chart also.

Both these cross-tab tables are using different data sets but the same universe.

P.S - I cannot use the sub-report as I eventually have to bring this report into live office and live office does not support sub-reporting feature.

Any help will be greatly appreciate it.

Thanks,
Sheriey
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 11 May 2010 at 9:53am
When you say it destroys the other CT and chart do you mean because you are running it with a different set up data (e.g. last FY vs. this FY)?

Edited by DBlank - 11 May 2010 at 11:02am
IP IP Logged
sheriey
Newbie
Newbie


Joined: 11 May 2010
Online Status: Offline
Posts: 2
Quote sheriey Replybullet Posted: 11 May 2010 at 10:58am
Yes !!.
And as soon as I delete the 2nd CT the data in the 1st CT automatically get corrected.
 
Thanks :)
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 11 May 2010 at 11:01am
Do you have date parameters to select the data you want?
If so you can alter the select statement o grab both FY data.
Create a formula field to split it into each Fiscal Year.
Create a Group on this FY formula.
Place your crosstabs (and other charts) into the Fiscal Year level Group Header. 
THis will limit each CT to only showing data that falls into that FY.
Does that work for your set up?


Edited by DBlank - 11 May 2010 at 11:03am
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 | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.