Skip to main content
Question

How do you use the "Bundle" options with a custom menu that calls a Quick Report?

  • February 10, 2021
  • 2 replies
  • 324 views

alanbclark
Sidekick (Partner)
Forum|alt.badge.img+7

I have created a custom menu that calls an IFS Quick Report with a type of Crystal Report. How do I use the bundled data in the Crystal Report. For example, the bundled data for

  • ORDER_NO looks like ‘1’,’2’,’3’,’4’.
  • RELEASE_NO looks like ‘1’,’1’,’1’,’1’
  • SEQUENCE_NO looks like ‘1’,’1’,’1’,’1’

 

How does Crystal know to break this into 4 different order numbers, release no, and sequence no values?

 

 

This topic has been closed for comments

2 replies

EntNadeeL
Hero (Partner)
Forum|alt.badge.img+10
  • Hero (Partner)
  • 181 replies
  • February 11, 2021

Hi @alanbclark ,

The Bundle Execution property on custom menus of type Quick Report enables the custom menu to operate on several objects selected in an overview window. If not used, the custom menu operation only applies to one selected object. The Quick Report must also be designed to support bundled execution. This means it must be of type "SQL Statement" and the where clause of the SQL statement must use the IN operator.

If you need to refer to an example refer below link.

Quick Report Custom Menu Sample (ifs.com)

Therefore it cannot be done with a crystal report.

But you can create a custom field with all the values together and then map it to a parameter in the crystal report and then break it accordingly in the selection formulas.

Thanks,

Kind Regards,


JusJohanU
Do Gooder
Forum|alt.badge.img+2
  • Do Gooder
  • 3 replies
  • February 23, 2021
EntNadeeL wrote:

Hi @alanbclark ,

The Bundle Execution property on custom menus of type Quick Report enables the custom menu to operate on several objects selected in an overview window. If not used, the custom menu operation only applies to one selected object. The Quick Report must also be designed to support bundled execution. This means it must be of type "SQL Statement" and the where clause of the SQL statement must use the IN operator.

If you need to refer to an example refer below link.

Quick Report Custom Menu Sample (ifs.com)

Therefore it cannot be done with a crystal report.

But you can create a custom field with all the values together and then map it to a parameter in the crystal report and then break it accordingly in the selection formulas.

Thanks,

Kind Regards,

Nice solution! I wasn't aware of this.


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