How to make a Report List of values appears in SAP

[abasilis]

Hi!

I created a sales report with two parameter, one is Date and the other is Shipping Type.

The shipping Type parameter is Dynamic, meaning that it loads the data/values from the table as soon as the Refresh button is pressed to ask for new parameter.

My issue is that when I run this report inside SAP, SAP ask for date just fine with dates values, and the Shipping type parameter appears as a text box for me to write the parameter.

How can I make the same list of values appear in SAP?

Thank you very much for your help, I really appreciate it!

[DellSC · Accepted solution]

There's information about how to do this in the Help file for Crystal with B1. There's specific syntax that you need to use for the parameter name so that B1 knows how to pull the data. Unfortunately, I can't find my copy of that help file to provide an example. IIRC, you have to include the Select statement for getting the data in the parameter name, but there's more to it as well.

-Dell

[abasilis]

Hi!

Your help guided me to search what I was looking for. It turns out that I just need to put a @Select statement net to the Parameter Name, detail in this link below:

https://answers.sap.com/questions/447880/parameter---value-options---choose-from-list.html

Thanks!

[hdolenec]

Hello,

Name your parameter "parameter@SELECT * FROM OSHP" to get choose from list field.

Name your parameter "parameter@SELECT "TrnspName", "WebSite" FROM OSHP" to get drop-down list.

See Crystal Reports guide for SAP B1 for more examples (chapter about working with tokens).

[abasilis]

Got it, thank you very much, I solved it yesterday. The other day I was looking information and I found out the PDF you recommended "Crystal Reports guide for SAP B1". I will start reading it. The tokens is a very interesting topic, I saw it, but I have not tried yet.

I found the solution here yesterday and it worked perfect.

https://answers.sap.com/questions/447880/parameter---value-options---choose-from-list.html

Thanks again!

[abasilis]

Hi Hrvoje Dolenec

I've done a lot of things and I've learned a lot with tokens, but I've been trying to change some of the values in the parameters to make a drop down list for Sales Rep to appear "All" if I want to select All (like the attached graphic) which I took from the "How to Work with SAP Crystal Reports in SAP Business One" guide, which value or how can I achieve the result I want.

Thank you very much!

[hdolenec]

Hi,

Set your parameter to allow multiple values. When you preview the report in B1, you will have three dots(...) next to parameter. Click on those dots and you will get the same screen as the one on the picture.