Something like this?

Select A.[Product Id],

(

select exp(sum(log(quantity))) from product_table B

where isprimary = 0

and CHARINDEX(Ltrim(Rtrim(A.[Product Id]))+'.',B.[Product Id]) > 0

) as Value

from product_table A

where

A.isPrimary = 1

Union

select A.[Product Id],0

from product_table A

where...

Look at my attachment. It's a zip with a sql script and a Report Project.

It's not a Virus 🙂

In Report1 you can find something like what you need.

Let me...

So you have a Table instead a Matrix. It's Right? can you attach a Desgin view of your Report?

Try this:

=IIF(Weekday(ReportItems!HeaderDate.Value) = 1 Or Weekday(ReportItems!HeaderDate.Value) = 7,"Red","Blue")

and remember to change HeaderDate with the textboxId of the columnGroup

Let me now if it works

Take a look at the attachment

Ok, probably i've got a solution:

1) Write this Custom Code and add it to your Report:

Private previousValue As Integer = 0

Public Function GetPreviousValue(ByVal runningValue) As Integer

...

I remember that you can't use Aggregate function for a group expression. You can use just "RowNumber()" and all Maths expression. You can't use Max or Min, so you need...

Probably you need a custom PaletteColor.

Take a Look at this link

http://www.mssqltips.com/sqlservertip/2797/different-ways-to-create-custom-colors-for-charts-in-sql-server-reporting-services/

or

http://www.sql2008hostingnews.com/?p=512

if you are working with ssrs2008 or greater you can do this:

1) Create a Paceholder for you textbox

2) In Paceholder poperties enable "HTML - Interpret HTML tags as style"

3) In...

Can you attach a report image in Design mode?

Where do you put your formula? in a Matrix or in a Table?

Which is the sum scope?

I need some more info...

You can try to write conditinal group expression for matrix Row Groups that depends on the selected value of the Parameters. You need three level Row Group: when one of...

Are ParameterA and ParameterB Multivalue DropDownList?

In this case the behaviour of DefaultValue is quite complicted.

Let me know and i'll try to explain....

😉

iif(Not IsNothing((Parameters!pGrade.Value) AndAlso (Parameters!pGrade.Value = "KG" OR Parameters!pGrade.Value = "01"), False, True)