Crystal Report Dynamic Parameter for SAP B1 version 8.8

[Former Member]

Hi, does anyone have problem with the dynamic parameter prompt for Crystal Report in SAP B1 version 8.8?

For example:

1. For static parameter that allows multiple value --> In SAP B1 v8.8, there is a check-box and a "..." button next to it. When you click the "..." button, a new window appear with a list of values to choose.

2. For static parameter that does not allow multiple value --> In SAP B1 v8.8, there is one field with a drop-down menu.

3. For dynamic parameter that allows multiple value and does not allow range values --> In SAP B1 v8.8, just one field for us to key in the value. Shouldn't this be the same as No. 1?

4. For dynamic parameter that does not allow multiple value and does not allow range values --> In SAP B1 v8.8, same as No.3 above. Shouldn't this be the same as No. 2?

How do I get no. 3 dynamic parameter that allows multiple value and does not allow range values to have a check-box and a "..." button next to it to allow us to select multiple values?

[Former Member]

Hi,

I guess the best way of looking into this is understanding the purpose of the parameter and token introduced in 8.8 rater than the name they are called.

In Crystal report, dynamic parameter populate the list of values from the database.

The parater token introduced in 8.8 gives the same benefits.

Ie, you create a parameter in Crystal report, and by using the token eg:Mytest@select * from OCRD, it gives you the benefits of selecting the list from the database.

Creating it as dynamic parameter is not relevant here.

In regards to your question:

#3. For dynamic parameter that allows multiple value and does not allow range values --> In SAP B1 v8.8, just one field for us to key in the value. Shouldn't this be the same as No. 1?

Answer : Dynamic parameter is irrelevant when you are using SAP token. You will notice that by creating a dynamic parameter and publish within SAP B1 8.8.

[Former Member]

Hi Shwu Hua Gan,

Thank you for your reply.

Please forgive me as I don't really understand what you are saying here. To be honest, I'm very new to Crystal Report and my understanding of CR is just the very basics. I'm actually not from a technical background which makes it more difficult.

In your reply:

Ie, you create a parameter in Crystal report, and by using the token eg:Mytest@select * from OCRD, it gives you the benefits of selecting the list from the database.

How do you do this by using the token? All I did is just select the parameter type (dynamic) and then select the table. When I preview the report in SAP B1 8.8, it doesn't prompt me like how I expect it to be. It is a blank field that I have to key in the value myself and then only the report will generate. Sometimes I don't remember what value to key in, so I have to do a formatted search for the blank field. After the report is generated, I can reselect the value (multiple values) from the CR viewer panel toolbar and refresh the report.

[Former Member]

Hi Joyce,

Have you ocated & worked through the SAP documentation on creating Crystal reports for SAP B1? This explains the creation & use of tokens and the correct connection methods.

You will find this document on the SAP Portal

[Former Member]

Joyce,

Please do what Julie suggested. When go to SAP Portal, search in Document Resource Center.

There are extensive list of documentation for SAP B1. You will find you save a lot of time by going through them.

[Former Member]

Hey guys, I got it now. Thank you so much for the replies.

[former_member209066]

Hi  Joyce Tan ,

Please tell me the Answer.

Thanks,

Nithi

[Former Member]

Hi Nithi,

I used SAP tokens.