Problems using Dynamic parameters with Crystal Reports and SBO 8.8

[Former Member]

Has anyone been able to successfully use a dynamic parameter in Crystal Reports with 8.8 using the Business One connector? When we try we get an additional logon to the database that pops up and the logon fails.

We need this because we want to return live lists of PO documents from the server for selection. We are also trying to use nested dynamic parameters, because we want to first return the PO document based on the PO number, and then chose specific rows based on a field value in POR1.

It works if we don't use the Business One connector, but then the report doesn't function properly inside of SAP.

Any ideas would be appreciated.

[Former Member]

Hi,

Have you searched the forum?

You may check this to start:

Thanks,

Gordon

[Former Member]

I have tried using tokens but they are too simple. I need something like a subselect where you first select one value and then another that is a subset of those values. Apparently the tokens can't even use a "where" clause.

SAP dances around Dynamic parameters, but won't come out and say that they can't be used with the B1 connector. If that is the case then they should just say so and stop wasting our time. Apparently Crystal is not truely interfaced with B1, just sort of hanging out with it.

I don't really care other than I have to do this select, subselect. If someone has a way to do that with tokens I would love to hear it.

Thanks,

Roy