none
Report layout issue. Cannot display record in same row.

    Question

  • Hi guys. I got a problem in designing report. I have a sql that fetch the record containing username, date, and detail. My report  is then group by username in row and date in column.

    Now, my report is showing like below image. the record detail cannot be display in a same row. Can I know how to solve this issue?

    Many Thanks.
    Tuesday, June 25, 2013 6:31 AM

All replies

  • Hello,

    I try to reproduce the issue in my test environment. However, when I display the report data with Matrix and put the string data type values in the detail cell. The report render the first value of each column group in the datail row.

    What's the version of the SSRS instance you using? Did you designe the report with Matrix control? 
    Please post a screen shot of the report designe structure and the dataset with sample data to us by the following E-mail address?  It is benefit for us to do further analysis.
    E-mail: sqltnsp@microsoft.com

    Regards,
    Fanny Liu


    Fanny Liu
    TechNet Community Support

    Saturday, June 29, 2013 8:43 AM
    Moderator