Microsoft Reporting Services -- Matrix "rowNumber" wrong ?

Posted on 2012-09-10
Last Modified: 2012-09-12
How can I get the attached to display 1,2,3,4,5,6,... ?

Doing below textbox "EXPRESSION" fail

=RowNumber("PROJECT_NO") --> displays "1, 2, 4, ..." since it COUNTS the day records
=CountDistinct(Fields!EMP_NAME.Value, "PROJECT_NO") --> displays "9" on each line
=CountDistinct(Fields!EMP_NAME.Value, "matrix1_EMP_NAME") --> displays "1" on each line
Question by:finance_teacher
    1 Comment
    LVL 22

    Accepted Solution


    Open in new window


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Suggested Solutions

    How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
    From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now