Forum Discussion
Paginated reports
I'm using two datasets in the paginated report but i'm creating the expression in the textbox by using the Dataset1 only expression is COUNT(IIF( month(Fields!NextFollowUpDate.Value)<month(today(...
Phaneendrababu normally the paginated reports or SSRS doesnt work with the aggregation and after that a countif.
Your dataset1 is from SQL or from PowerBI dataset? in both cases, my recomendation is to create a new dataset that it is aggregated with all the conditions that you need. it is not efficient but it works