What exactly do you mean with the "holding" table?

Do you filter out any data in the process?

nkweke (6/5/2014)

---

Thanks again Koen, I am new here and still trying to grasp this sql stuff. Your suggestions are noted.

I added the Group By and it pops up another error:

Msg...

deeby (6/5/2014)

---

OMG. So obvious. Thanks.

For the benefit of other newbies - that otherwise very useful article tells you to set up some variables like

Those variables need...

Interesting and detailed article, thanks.

The error is pretty straight forward:

you need to add a group by clause.

DECLARE @Amount MONEY;

DECLARE @totAmn MONEY;

SELECT ISNULL(SUM(p.price*s.quantity)+ s.shippingcost,0)

FROMtbl_shoppingcarts

INNER JOINtbl_productp ON s.productid =p.productid

WHERE s.cartid =@cartid

GROUP BY s.shippingcost;

Try to format...

You can find an example here:

SSRS 2008 – Lattice Charts (Small Multiples)

You should set SuccessValue to 1.

When I execute your original statement, I get an error saying ID cannot be in the SELECT list because of the aggregation functions and there is no gruop by.

So I...

I have to ask the obvious:

can't you just join the two tables?

Check this thread:

http://forums.asp.net/t/1753385.aspx?How+to+pass+Unicode+characters+to+a+store+procedure+to+insert+unicode+type+of+data

Aside from the fact that a pie chart is a horrible visualization that is easily misinterpreted, you can solve your issue by creating a matrix with country in the columns....

Are you going from the main report to the child report using drillthrough?

I have the same set-up here in SharePoint 2013 and I have no issues with the parameter prompts.

Did you put the property EvaluateAsExpression to true on the variables?

What happens? Do you get an error somewhere?