Skip to Content
0

Crystal for Enterprise 4

Apr 02 at 08:28 AM

15

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Abhilash Kumar
Apr 02 at 12:02 PM
0

Hi Bharathi,

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

-Abhilash

Share
10 |10000 characters needed characters left characters exceeded
Dell Stinnett-Christy Apr 02 at 02:25 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded