Chart Problem

[devnaren]

Hi All,

CRXI

I created a report in which lists total number of parent records in main report for each quarter. Now to get the child percentages based on parent record, i created a subreport,

On Selection Expert, I'm using

{@DateCreated} in {?Start Date} to {?End Date} and
{Field.S_VALUE} in ["2", "3"] and
{Grid.NAME}<>"N/A" and
Not IsNull(Grid.ID}) and
{Activity.TYPE} in [413, 414, 456] and
{Status.NAME} <> "Closed - Cancelled"

By this it will list all the parent records which satisfies the conditions.

Now to get the Child records

I created formula as

@child:
If
{Child.NAME} = "Action" and
{Status_Child.NAME} <> "Closed - Cancelled"
then
"Child Record"


Now the problem is when i created a Bar chart in that i inserted

@Quarters & @Child formulas in OnChangeOf Section. for @Child formula inserted a specified order as "Child Record" and left the other records in their own places.

<Parent.ID> inserted on Summarized Fields section and selected Distinct Count as summary and
Percentage is selected for @Quarter.


when the report is generated the Parent Records percentage is shown as 100% and from that 100%, it as to give the child record percentage based on parent records.

Here child percentage is working fine, but for parent records the percentage is not shown as 100%.

i tested this with inserting a cross-tab and using the same fields in it, i found that some of the parent records showing as "0" and child record as "1". without parent record child record will not available. Here it as to show as "1" for parent record and "1" for child record.

Can anyone find how to get the soln for this.

 

[lbass]

If you inserted a distinctcount on the child formula, you will get 1 if the record doesn't meet your criteria, since it will count the default value. Try creating a new formula {@null} by opening and saving a formula without entering anything. Then change your child formula to:

If {Child.NAME} = "Action" and
{Status_Child.NAME} <> "Closed - Cancelled" then
"Child Record" else
{@null}

-LB