Skip to main content
Answer

Report Generation Issue in Sandbox

  • September 8, 2021
  • 5 replies
  • 121 views

Forum|alt.badge.img+2

I have customized the Sales Order Report (so641010.rpx) in my dev instance and report generation occurs as expected.

When I export the customization project to the sandbox instance, add the necessary information in the Sales Order Screen and run the report I get the report with no data. If anyone could suggest why this happens it would be great.

Best answer by Django

I would be tempted to make that join a left join so that the image record is not required to be there.  With an inner join, if the item doesn’t have an image associated with it, then the detail line won’t appear in the result set either.

5 replies

Forum|alt.badge.img+7
  • Captain II
  • September 8, 2021

Did you join to a custom table?  Did you add any additional filtering to the report?


Forum|alt.badge.img+2
  • Author
  • Pro III
  • September 9, 2021

@ddunn  I added four additional joins to fulfill requirements but no filtering.

 


Forum|alt.badge.img+7
  • Captain II
  • September 9, 2021

I would start there with figuring out why the report isn’t showing you any data.  Try turning equal joins to left joins and so on.


Forum|alt.badge.img+2
  • Author
  • Pro III
  • September 9, 2021

@ddunn thanks for the response, I have inner joins to show inventory item’s image and showing that requires inner joins according to the S150 report designer documentation.


Forum|alt.badge.img+7
  • Captain II
  • Answer
  • September 9, 2021

I would be tempted to make that join a left join so that the image record is not required to be there.  With an inner join, if the item doesn’t have an image associated with it, then the detail line won’t appear in the result set either.