locked
ReportViewer shows only first record RRS feed

  • Question

  • User260076833 posted

    Hi,

    I create a ReportViewer as follows:

    • create report (rdlc) from SQLDataSource without wizard
    • drag one field from the data source onto the report
    • create a web form with a ReportViewer, attached to the report

    Then, I only see the first record, page 1 of 1.
    I cannot go to the next page, because there is only one page.

    If I use a table (Tablix?), then I see all the records in the table.
    But I would like to place the attributes at arbitrary positions on the report page, having one page per record.

    What am I doing wrong?

    Thanks
    Magnus

    Monday, May 18, 2015 1:11 PM

All replies

  • User1711366110 posted

    Then, I only see the first record, page 1 of 1.  I cannot go to the next page, because there is only one page. If I use a table (Tablix?), then I see all the records in the table.  But I would like to place the attributes at arbitrary positions on the report page, having one page per record.

       As per this case, you can do the following steps :

    1.Goto rdlc design section >> right click on corresponding tabledetails cell>>select "expression" .If use first() function then just remove it

    =First(Fields!columnname.Value)
    
    remove First() in expression like below :
    
    =Fields!columnname.Value

    2.for showing one row per page ,First add a Row Group which is a Parent of the existing top level group. In the Group By expression, enter 

    =CEILING(RowNumber(Nothing)/1) 

     where 1 is the number of records to be displayed per page.

    for more information,refer the following link :

    1. http://stackoverflow.com/questions/8389884/how-do-you-create-a-report-rdlc-that-shows-1-record-per-page 

    2. http://www.sqlchick.com/entries/2010/9/11/displaying-fixed-number-of-rows-per-ssrs-report-page.html

    --
    with regards,
    Edwin

    Tuesday, May 19, 2015 2:17 AM
  • User260076833 posted

    Hello Edwin,

    thank you very much!

    I cannot create any groups. Do I need a table to create groups?

    Remember, I don't want a tabular layout. I want to place the fields at arbitrary positions on the page, having one record per page.

    Do I need a table or can I create the group somehow without a table?

    Thanks

    Magnus

    Wednesday, May 20, 2015 4:36 AM
  • User1711366110 posted

    Do I need a table or can I create the group somehow without a table?
      
       As per this case, you can create a group based on just one column & apply that ceiling formula against that group , Then check the result & let me know.

    Friday, June 5, 2015 5:50 AM