Skip to Content
avatar image
Former Member

Crystal for Enterprise 4

Hi Masters,

I need help for this requirement, There is a measure for Sales and
Customer Sales $.

We need to provide the Selection/Parameters for this Measure in Crystal Enterprise. We need to make it to Two selection only.

Parameter 1: Sales
PADM_1001 Sales

Parameter 2: Customer Sales $

PADM_6000 Customer Sales $
PADM_5100 Customer Sales $
PADM_1005 Customer Sales $
PADM_1006 Customer Sales $

How to make it one selection for Parameter 2: Customer Sales $ it contains 4 different data.

Please help me out for this requirment.

Regards,
Bharathi

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 02 at 12:02 PM

    Hi Bharathi,

    Could you please elaborate on "How to make it one selection for Parameter 2"?

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 02 at 02:25 PM

    Create a formula that looks like this: (Assuming that the field names match what's in the parameter...)

    Switch(
    {Customer Sales $} = 'PADM_6000 Customer Sales $', {MyTable.PADM_6000},
    {Customer Sales $} = 'PADM_5100 Customer Sales $', {MyTable.PADM_5100},
    {Customer Sales $} = 'PADM_1005 Customer Sales $', {MyTable.PADM_1005},
    {Customer Sales $} = 'PADM_1006 Customer Sales $', {MyTable.PADM_1006},
    true, null)

    Use this formula on your report instead of the field. You'll also be able to use this formula in any summary that you may need.

    -Dell

    Add comment
    10|10000 characters needed characters exceeded