locked
SSRS Result Set getting filtered out of the report RRS feed

  • Question

  • How is it possible that my SQL Server Stored Procedure passes back the correct result set but the Report on Report Manager Portal is filtering out the report detail?

    Andddddd if I run for the specific parameters for those missing report rows, then it comes up and appears in the report!

    So when I (Select All) they do not appear...but if I Select the specific Parameters, it does come up!

    There is no report filtering...no SSRS Dataset filtering

    What am I missing here?!?!?

    Thanks for your review and am hopeful for a reply. 

    Monday, June 17, 2019 5:24 PM

Answers

  • It was a limitation in our Table-valued Function [StringParser]
    • Marked as answer by ITBobbyP Monday, June 17, 2019 8:39 PM
    Monday, June 17, 2019 8:39 PM

All replies

  • Is there a limitation on the number of values SSRS can handle?

    Seems to be stopping at 225.

    Monday, June 17, 2019 7:34 PM
  • It was a limitation in our Table-valued Function [StringParser]
    • Marked as answer by ITBobbyP Monday, June 17, 2019 8:39 PM
    Monday, June 17, 2019 8:39 PM