Crystal Tokens in SAP B1 Hana

[julie_jamieson2]

I have a Crystal Report based on a command which contains the following parameter:

{?BUDGET@SELECT "AbsID","Name" FROM OBGS}

In SQL B1 that would pop up a drop down list for me to select which Budget Scenario I want to select to run the report based on.

When I import the report into SAP Hana, the parameter appears with a drop down arrow, but no list appears.

What needs to change to allow this to work?

[vinod_memane1]

Hi Julie,

Either you can provide this parameter as Static and manually import all of them in the parameter values itself or you can define this parameter as Dynamic and then assign AbsID as a value.

Both ways, you will see list of Budgets as a drop down."Dynamic" is recommended way for your case.

Regards,

Vinod