How to render page per entry in the dataset?

How to render page per entry in the dataset?

Posted by: naiyin on 12 December 2024, 7:33 pm EST

• 

  naiyin

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 12 December 2024, 7:33 pm EST - Updated 12 December 2024, 8:59 pm EST

  I have a dataset called “invoices”

  

  I also have a dataset called "InvoiceDetails’

  The plan is to render pages based on the invoice dataset and then show the details based on the InvoiceDetails dataset.

  I’m having a problem to render pages per invoice entry
  
  Right now everything is working, but it just only rendering the first invoice
  
  However, I have multiple invoices

  Here is how I set up the FixedLayout dataset and grouping
  
  It only shows one single invoice, the first invoice 0000323, I can’t display the other invoices at all

  

• 

  naiyin

  • Post Options:
  • Link
    Copy

  Posted 12 December 2024, 9:35 pm EST

  I found the reason is that the “InvoiceDetails” dataset query is incorrect.

• 

  arthurnichols242

  • Post Options:
  • Link
    Copy

  Posted 3 April 2025, 1:47 am EST - Updated 4 April 2025, 12:03 am EST

  So what is the reason?

• 

  naiyin

  • Post Options:
  • Link
    Copy

  Posted 3 April 2025, 5:40 pm EST - Updated 3 April 2025, 5:40 pm EST

  Just was because my SQL query in the report was wrong

• 

  anand.sinha

  

  • Post Options:
  • Link
    Copy

  Posted 6 June 2025, 12:31 am EST

  Hi James,

  We’re glad you were able to resolve the issue! And thanks for sharing your solution here, as it may help others facing the same issue.

  Regards,
  
  Anand