Crystal Report UF to Read all Line Items On UF - SQL Report

Carla van Zyl

• February 28, 2024 07:03

Good day, 

I have a SQL Report UF that brings up all Open Sales Orders. On the screen there is a button to generate a Crystal Report with the Need for the it to read from The SQL Reports screen that contains multiple rows. So I would need it to run a lineloop or work with Store functionality. Is there a way that this could be added on the Crystal Report UF Configuration button. At the moment, it only reads the first row. 

 

Vote

0

• 

  Geoff Booth

  • February 28, 2024 14:01

  Hi Carla,

  I may not be understanding the issue correctly but here goes:

  1. The button on the SQL Report would call an UF type Line Loop (or the Battleship Cobra "While" code
  2. The LL function would then call your CR function for each selected row. (do you want the CR for every row or only ones manually selected?)

  Let me know if I am missing something
   

Please sign in to leave a comment.