suppress a group in cross tab

[ridhirao22]

Hi,

First, Thanks to this wonderful site and all experts out there.

I am using CR XI and Oracle 9i

Report is display as a crosstab with user input for range
?Startdate and ?enddate. Series of SQl's generate a temp table and report is based off the temp table.
Now the report needs to show Reached % which has to cummulate for ytd. Currently, Report does for the given period. How can show the values for the given rane but only show the reache % as YTD.

Report should look like this:

2010-08
usr1 usr2 usr3
Reach % 0.7 0.34 0.74
TargetedCalls 10 12 15
Non-TargetedCalls 3 4 2

BUT looks like this and I am unable to suppress the null part in year-month
2010-08
usr1 usr2 usr3 total usr1 usr2 usr3 total
Reach % 0.76 0.72 0.84 2.32 0.7 0.34 0.74
TargetedCalls 30 45 35 110 10 12 15
Non-TargetedCalls 6 10 4 20 3 4 2

the first part of usr1 usr2 usr3 total is cummulating from Jan-2010 to Jul-2010

Using @month as
if date between ?startdate and ?endadte then
year-Month(field)

I know I couldn't be descriptive of what iam doing and what I want to do. But couldn't explain better.....


please any help or advise is appreciated

Thanks,
RR

 

[lbass]

Try adding the conditional clause to the fields you are summarizing, e.g.,

if date between ?startdate and ?enddate then
{table.call}

-LB

 

[ridhirao22]

LB -- Not sure, but hope you are in SAP's reports fest. You make so many people's day with you suggestions totackle the issue they go thru. You should be there and we all can vote you!



I tried it and didn't work as I want the summaries to show up. Here is what I did

@values
If catefory = 'Reach %' then
distinctcount(targetcall)/Totalcalls
else if date between ?startdate and ?endate
then
value

This would still show me the summareies but for reach% the values are showing p as zeros...

Thanks,
RR

 

[lbass]

Please identify the fields you were originally using for row, column, and summary, and if you were using formulas, show the contents of the formulas.

-LB