Forum Discussion

RBunting's avatar
RBunting
Icon for Advocate III rankAdvocate III
7 years ago
Solved

Paginated Reports "All" parameter

I have connected Paginated Reports to a dataset that I have previously published in Power BI. I'd like to have a parameter to limit the results by Manufacturing Plant. But I'd also like to be able to...
Need Help
  • RBunting's avatar
    RBunting
    7 years ago

    Blast.  It was a picky little syntax error.

     

    EVALUATE
 ( ...

    The command shown above is no good.  Report Builder does not like that white space between the EVALUATE keyword and the open pren.  The following variation worked fine.

    EVALUATE( ...

    Thanks for taking the time to look into the problem.  

     

     

     

     

mvabalaitis's avatar
mvabalaitis
Frequent Visitor
6 years ago

RBunting - Thanks so much for all the info, super helpful in converting our SSRS to Paginated. One question regarding the addition of the "All" value. I was able to get the union working in my dataset, however when I attempt to add the ORDER BY functionality the expression breaks throwing the following error: "A single value column cannot be determined". The issue is resolved by removing the union, which gets me back to square one.

 

Has anyone ran into this issue and can offer any advice?