I don't know the exact cause of this problem. But maybe following may help:

Just try this i had tried and my prob got solved..............

For Firefox

1. Open firefox and type in...

You have to put this expression into:

Textbox properties > color > select 'expression' > paste ex. and click ok.

It's more like this expression:

=iif(Fields!BRANCH_CODE.Value = MIN(Fields!BRANCH_CODE.Value, "DataSet1"), "Red", iif(Fields!BRANCH_CODE.Value = MAX(Fields!BRANCH_CODE.Value, "DataSet1"), "Green","Black"))

Steps

1) Select the desired textbox and press F4 to go to its properties section.

2) Click on the...

Use this instead:

select deliveryEntry.ID, sum(cost*(deliveryTank.grossVolume)) as Total

from deliveryEntry

inner join deliveryMapping on deliveryEntry.ID=deliveryMapping.deliveryID

inner join deliveryTank on deliveryMapping.ID=deliveryTank.deliveryID AND (deliveryTank.deliveryID=(select MAX(deliveryMapping.ID) from deliveryMapping where deliveryMapping.deliveryID=50))

inner join Tanks on deliveryEntry.simmonsPID=Tanks.Simmons_PanelID

and Tanks.Tanks_ID=deliveryTank.tankID

inner join costTag...

Right click on any column header and select Insert Column > Left / Right.

Then include only delivery_id in the select and group by clause.

output :

id productname total ...

Use the following expression in the textbox :

=LookupSet(Fields!PRODUCT_BRAND_CODE.Value, Fields!PRODUCT_BRAND_CODE.Value, Fields!PRODUCT_NUMBER.Value, "Product").Length

From Ref: http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/135ef7c9-a4d0-4f16-9828-5ca8c2ee00ab

You can try following :

1)Go to properties section of the textbox by selecting the textbox and pressing F4.

2) Go to the Format section in properties.

3) Click the drop down...

You could add a calculated field on which you should group on.

You can use mid function in the report expression for the new field and extract only first 2 words...

To...

You don't have to use a SP. you can just replace following code:

SELECT value from dbo.Fn_tsp_orderhistory(EXEC STORED_PROC_NAME

('''+@c+''')

WITH

SELECT value from dbo.Fn_tsp_orderhistory( '%' + REPLACE( @c, '*', '%') +...

Maybe this link will help:

SSRS export

I think the only way you can achieve this by using Rank & Partition in a SQL query.

And then using it in the hidden expression.

For Ex. if(new_field = 1...

Please explain what are you trying to achieve here ?

And what exact error you are getting after you...