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
Hi Brad - it would help if you posted the calculation...
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
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:
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):
total ( if ( [Subtotal Type] = 1 and [row] = 1 ) then ( [Jan Bud] ) else (0) for report )
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.
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