RSV-VAL-0010 Failed to load the report

[diasbrad]

Hi Friends,

I have a query item which is a calculated field, when I drop this on the report and validate the report I get the following error.

When I  remove this Query Item from the report and re - validate the reprot. I validates without any error.

RSV-VAL-0010 Failed to load the report specification. CCL_ASSERT(!"__Logic error)

Can anyone help me fix this issue.

Thanks & Regards
Brad

[BigChris]

Hi Brad - it would help if you posted the calculation...

[Raghuvir]

Hi BigChris,

the calculation is

if ([row] =1)

then
(total(if([Subtotal Type]=1) then ([Jan Bud]) else (0) for report))
else
(0)

we have made the aggregate function to "total" and roll up aggregation function to "automatic"

we dont know what exactly is the issue.

Regards

[Lynn]

Does simplifying the logic help? With this expression and aggregation set to total it should sum up the values for you. You would only need the total function with a "for" scope if you want that same total value to compute with every record of the result set within the specified scope.

With aggregate function set to total:

Code Select Expand


if ( [Subtotal Type] = 1 and [row] = 1 ) then ( [Jan Bud] ) else (0)


or

With aggregate function set to none (because you've already explicitly said what you want):

Code Select Expand


total ( if ( [Subtotal Type] = 1 and [row] = 1 ) then ( [Jan Bud] ) else (0) for report )


[BigChris]

Lynn's answer is a lot neater than mine...this is what I was going to suggest:

Hi - I can't see anything obvious in there that would cause an error. Have you tried deconstructing the query item and building it back up in stages?

e.g. if([Subtotal Type] = 1) then ([Jan Bud]) else (0)

then

total(if([Subtotal Type] = 1) then ([Jan Bud]) else (0) for report)

then

if([row] = 1) then (total(if([Subtotal Type] = 1) then ([Jan Bud]) else (0) for report)) else (0)

That might just throw up the error at a particular point and that might help you pinpoint what the problem is.

[Sandeep Chandran]

Hi Folks,

I am facing the same issue RSV-VAL-0010 Failed to load the report specification.CCL_ASSERT(!"__Logic Error__") when adding a new measure to the report --> Total(Sales for category) , I tried to change the aggregate to "None" on Summary and detailed aggregation, still the issue is not resolved.  Looking for some assistance.

Thanks
Sandeep