SSRS Experts

[sanbk]

1. Calculated Fields Add chesi (Involving Aggregations) then Data ni Filter ela cheyyali on top of dataset including calculated fields

2. Oka Dataset base chesukoni 4 reports design chesa (Okate Report) page break use chesi export chesa excel ki so it will be shared across 4 tabs. Is there a way to display only report based on parameter. 2nd di ardam avuthado ledo 

[loveindia]

I didn't understand both but for first one you need to use expressions man.. And then you can build filters on top of that as needed.

[PhillyDotNetGuy]

nuvvu anni stored procedure lone cheyachu kada......

I usually avoid doing calculations/filters with in the report

[loveindia]

Just now, PhillyDotNetGuy said:

nuvvu anni stored procedure lone cheyachu kada......

I usually avoid doing calculations/filters with in the report

True that extra time for rendering man..

[sanbk]

Idi na expression

=Sum(((Fields!SHARE_PAR_VALUE.Value / Sum(Fields!SHARE_PAR_VALUE.Value)) * Fields!PRIMARY_PRICE.Value))

Idi error when I preview the report

The expression used for the calculated field ' = =Sum(((Fields!SHARE_PAR_VALUE.Value / Sum(Fields!SHARE_PAR_VALUE.Value)) * Fields!PRIMARY_PRICE.Value)) includes an aggregate, RowNumber, RunningValue, Previous or lookup function. 
Aggregate, RowNumber, Runningvalue, Previous and lookup functions cannot be used in calculated field expression.

I guess I can't use report variables too in this scenario..