Skip to main content
Solved

Report Generation Issue in Sandbox

  • September 8, 2021
  • 5 replies
  • 95 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.

View original
Did this topic help you find an answer to your question?

5 replies

Forum|alt.badge.img+6
  • Captain II
  • 578 replies
  • 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 I
  • 105 replies
  • September 9, 2021

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

 


Forum|alt.badge.img+6
  • Captain II
  • 578 replies
  • 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 I
  • 105 replies
  • 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+6
  • Captain II
  • 578 replies
  • 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.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings