| Author |
Message |
Viresh
Newbie
Joined: 14 Jul 2009
Location: India
Online Status: Offline
Posts: 9
|
  
Topic: How to suppress the blank space between two cross
Posted: 14 Jul 2009 at 7:16am |
Hello friends,
I am using crystal XI, and working on cross tabs. I have created 3 cross tabs side by side and i want to suppress the middle one based on the condition. I have suppressed the cross tab based on condition but the issue is, i am not suppress the space. So can one plaese tell me how to suppress the space along with data. Its urgent!!!!!!!!!
Thanks for your suggestion in advance.
|
 IP Logged |
|
|
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 14 Jul 2009 at 6:52pm |
I don't think you can.
I think you would have to make another copy of the CT #3 and place it where crosstab #2 is then suppress it when CT#2 is not suppressed and suppress CT #3 (the original one on the far right) when CT#2 is suppressed.
This would make it appear the CT #3 shifts to the left on whatever your suppression condition is. Edited by DBlank - 14 Jul 2009 at 6:53pm
|
| IP Logged |
|
Viresh
Newbie
Joined: 14 Jul 2009
Location: India
Online Status: Offline
Posts: 9
|
Posted: 14 Jul 2009 at 11:08pm |
|
|
| IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 15 Jul 2009 at 7:08am |
I forgot you could also use the conditional X position on the crosstab.
Right Click on the CT and select "Size and Position".
You can use an if then formula on the X position to slide ir right and left based on your suppression formula.
|
| IP Logged |
|
Viresh
Newbie
Joined: 14 Jul 2009
Location: India
Online Status: Offline
Posts: 9
|
Posted: 15 Jul 2009 at 8:45pm |
Thanks for your input.
I tried with the formula on the X position to slide as per your suggestion but still i am getting space between cross tabs.
Also i wanted to suppress the blank lines in the CR depending on the condition. So could you plz give me some suggestion.
Thanks in advance!!!!!
|
| IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 17 Jul 2009 at 10:39am |
Make sure you use twips as the number for the position. 1440 twips= 1 inch. Example for moving it one inch...
if suppression condition=true then 1440 else 2880
What blank lines are you referring to? In the CrossTab or somewhere else?
|
| IP Logged |
|
Viresh
Newbie
Joined: 14 Jul 2009
Location: India
Online Status: Offline
Posts: 9
|
Posted: 19 Jul 2009 at 12:29am |
Thanks for your sugestion.
Blank lines refering to crystal report not the CB.
Actually i want to display the number of weeks horizontally in page header depending on the selected month. By default i am displaying 5 weeks but, if the selected month has 4 weeks then i want to display only 4 weeks by suppressing the 5th week column depending oncondition. The issue is i am not able to suppress the blank lines but i am able to suppress the column. So could you plz help me.
Thanks in advance!!!!!
|
| IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 19 Jul 2009 at 7:53pm |
I assume that the data pulled in will then have a date field in it with the correct month and year.
I would create a fomula field that uses the date field to calculate the first day of the month and the last day of the month and datediff them on days and if that # is <=28 suppress.
|
| IP Logged |
|
Viresh
Newbie
Joined: 14 Jul 2009
Location: India
Online Status: Offline
Posts: 9
|
Posted: 19 Jul 2009 at 10:40pm |
I am able to suppress the data based on the condition but the issue is lines are not supreeing. So tell me how to suppress the lines.
Thanks for your response!!!
|
| IP Logged |
|
|
|
