Crystal Report Parameter list blank in SAP B1

[JerushaLala]

Hi All

I have created a report in crystal based on a Calculation view (Created in HANA studio)

The user wants to be able to chose one/ many or all of the accounts, depending on what they want to see.

I followed the advice from https://archive.sap.com/discussions/thread/3738459, but when I run the report in SAP, the list of parameters are blank.

SAP 9.3 PL06 (HANA), Crystal 2016 Support pack 5

Please see screenshots:

Selection Criteria in SAP

List of Parameter Command:

Parameter Setup:

Any ideas on how to fix this?

Thank you all
Jerusha

[DellSC · Accepted solution]

There are some very specific things you have to do in order to get a parameter from Crystal to link to data from B1. Unfortunately, providing the data from a command in the report will not show data for the parameter in B1. However, here is the way that you would do this:

When defining your parameter, use this as its name (you don't need the quotes):

UMAName@Select distinct AcctName from _SYS_BIC.sap.blah/PREMIUMCASHACCOUNTSFINAL

So, in the parameter name, you have to include the query that B1 will use to get the data for the parameter in order to get data to show up when running the report.

-Dell

[JerushaLala]

Hi All

I managed to find a solution and resolve the issue.

Jerusha