locked
how to render same set of records in one page and other set of same records in another page and keep on .. RRS feed

  • Question

  • User1094269964 posted

    Lets say I have DataTable like below

    Id DocumentName UserName
    1 Legal Document John
    2 RequirementDocument Peter
    3 DesignDocument Ellen
    4 Legal Document June
    5 FunctionalDocument Rob
    6 AnalysisDocument Shaun
    7 RequirementDocument Mark
    8 Legal Document Toni

    If you look at the DocumentName column 

    LegalDocument comes 3 times

    RequirementDocument comes 2 times

    and rest of them are comes only one time

    The requirement is we need generate a report in which each document has its own header with signature and should be in same page

    -----------------------------------------------------------------------------------------

    Below documents with User Signature with more content as header
    Document Name    : Legal Document
    User Name             : John
    Date                       :
    Signature               :
    Document Name    : Legal Document
    User Name             : June
    Date                       :
    Signature               :
    Document Name    : Legal Document
    User Name             : Toni
    Date                      :

    Signature              :

    -------------------------------------------------------------------------------------------

    After this we need a page break (that is end of this Document)

    then comes the next document in next page 

    Below documents with User Signature with more content as header

    Document Name    : DesignDocument
    User Name                :Ellen
    Date                             :
    Signature                   :

    --------------------------------------------------------------------------------------------------------------------

    After this we need a page break (end of this document)

    then comes the next document in the next page

    Below documents with User Signature with more content as header
    Document Name    : RequirementDocument
    User Name                : Peter
    Date                             :
    Signature                   :
    Document Name    : Legal Document
    User Name                : Mark
    Date                             :
    Signature                   :

    After this we need a page break (end of this document)

    then comes the next document in the next page

    like this we need to generate a report. Please help 

    Thursday, August 11, 2016 3:47 PM

All replies

  • User-359936451 posted

    Show some of your code that builds this table output.

    You could query the results of the datatable and populate a new datatable for each unique results set, then create your documents from that. Output each unique datatable separately.

    You may need to write some queries to separate your content here.

    Thursday, August 11, 2016 8:57 PM
  • User1094269964 posted

    I am willing to change the table structure and create more datatables.

    But I dont know how to do this in report which control to use and how to design this sort of report. Could you please suggest me 

    Friday, August 12, 2016 1:38 AM
  • User-359936451 posted

    Not sure I can help you much given your current state. You should try to set some of this up and we can point you in the right direction from there. But maybe try something like this.

    Customers table

         keyID        Name

    Document table

        keyID     docName    cust_keyID

    Now you can query each customers documents based on their ID be related to the documents table.

    Friday, August 12, 2016 3:47 PM