Crystal Reports SBO 8.8 - Token paramters that includes another parameter

[Jacqueline]

Dear Experts,

I need some help with the following:

I have created an crystal report with 2 Token-Parameters like this:

1.

Customer@SELECT CardCode FROM OCRD

2.

Items@SELECT distinct dln1.itemcode FROM ODLN INNER JOIN DLN1 ON ODLN.DocEntry = DLN1.DocEntry WHERE (ODLN.CardCode = '@Customer')

The second paramter includes the first one and so far everything works fine. If I choose with the first parameter the customer, the second paramter shows all items for the customer in table ODLN/DLN1.

But now, when I allow multiple values the list of items is empty.

Any ideas?

SBO Version 8.8 PL13

Thanks.

[Former Member]

Hi guys

I am experiencing the same issue with putting a parameter within a parameter using SAP tokens. When i do not allow multiple values, it works. But as soon as I allow multiple values, the select list is empty...

Has anyone managed to find a solution to this?

[Former Member]

Have you tried using the full text for your parameter instead of just @customer? EG @Customer@SELECT CardCode FROM OCRD?

If you look in the formula editor, this is how they show.

The other way is within the parameter creation, to put the other parameter in as a value field? I don't have my test system with me but recall seeing something on the Crystal reports forum on how to create parameters dependant on other parameters. It may not work with the SAP tokens though, there are a number of issues with development ne.g. optional parameters not working and default values not working.

[Jacqueline]

If I use "@Customer@SELECT CardCode FROM OCRD" I get no results.

Edited by: Jacqueline Wutke on Sep 10, 2010 2:25 PM

[Former Member]

Hi,

On which one you are allowing multiple values?

Thanks,

Gordon

[Jacqueline]

Hi,

I want to allow multiple values for the second parameter to select multiple items.

Thanks

[Former Member]

Have you tested if you change Customer to fixed one, not a parameter?

[Jacqueline]

Hi Gordon,

I've tested it, but its the same result.

As soon as I allow multiple values, the list is empty.

[Former Member]

That means: you can only have single value instead of multiple values.