Home Forums Reporting Services Reporting Services Counting Rows on a LookupSet Function in Reporting Services RE: Counting Rows on a LookupSet Function in Reporting Services

  • September 11, 2012 at 4:21 am

    #1536119

    Use the following expression in the textbox :

    =LookupSet(Fields!PRODUCT_BRAND_CODE.Value, Fields!PRODUCT_BRAND_CODE.Value, Fields!PRODUCT_NUMBER.Value, "Product").Length

    From Ref: http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/135ef7c9-a4d0-4f16-9828-5ca8c2ee00ab

    BI Developer
    SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
    Please visit... ApplyBI