sanbk Posted May 23, 2016 Report Share Posted May 23, 2016 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 Quote Link to comment Share on other sites More sharing options...
loveindia Posted May 23, 2016 Report Share Posted May 23, 2016 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. Quote Link to comment Share on other sites More sharing options...
PhillyDotNetGuy Posted May 23, 2016 Report Share Posted May 23, 2016 nuvvu anni stored procedure lone cheyachu kada...... I usually avoid doing calculations/filters with in the report Quote Link to comment Share on other sites More sharing options...
loveindia Posted May 23, 2016 Report Share Posted May 23, 2016 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.. Quote Link to comment Share on other sites More sharing options...
sanbk Posted May 23, 2016 Author Report Share Posted May 23, 2016 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.. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.