Print & Delivery Mass Configuration SQL Variable Pass To Crystal

Answered

Simon Simms

• August 10, 2021 13:18

Is there a way to pass the SQL variable from the Mass delivery configuration to a parameter defined within a crystal report used in the report configuration?

I need to pass a date from and a date to from the variable to a parameter.

Vote

1

• 

  Rasmus Jensen

  • August 10, 2021 13:55

  I assume you are talking about the [%0] syntax. If so I'm afraid that is not possible because B1P&D needs to be able to use the Crystal Definitions in both interactive mode (aka in the B1 Client) and non-interactive mode (in the server component)... And since there in the server-component is no-one to input the value it would not work
• 

  Simon Simms

  • August 10, 2021 14:19

  Hi Rasmus,

  You are correct.
  Absolutely appreciate that fact the nature of a variable would mean that it needs to be run in the UI not the server component, is it possible though as long as it is clear that if this is used in that way it would only be a UI interface that could run this type of report in the mass delivery?
• 

  Luca Zanni

  • August 11, 2021 07:19

  Hi Simon,

  I managed to pass variables to a Crystal Report using mass delivery (and the scheduler) by creating a UDT with different parameters as columns and one row of data, and querying it within the Crystal Report itself. By doing this, you bypass the whole UI limitation of variables, but you need to set it up in a different window rather than being asked by the mass delivery everytime you run it.

  There is a video from Boyum IT that illustrates this process in detail at this link https://www.youtube.com/watch?v=9QMcWgmASdk&t=2s

  Regards

  Luca Zanni
• 

  Rasmus Jensen

  • August 11, 2021 09:47

  Move it back as a Feature Request...

Please sign in to leave a comment.