Hide Crystal report parameter while execute report into SAP Business One

[nikunjmehta2290]

Dear all,

Need to disable / Hide parameter while execute the crystal report into SAP Business One. I have tried also with "Do not show option" under Show on Panel (Viewer) but it is not working.

Need to hide parameter of document numbering ask each time while CR is running into SAP B1. 

SAP Business one with MS SQL

Regards,

Nikunj Mehta

[Stef5]

Dear Nikunj Mehta, which version of SAP B1 do you currently have? As far as I know, this feature was implemented in one of the latest versions already. But before it was ignored when you set "Do not show option". Kind Regards

[BattleshipCobra]

If you are working with the Crystal Reports runtime within the SAP Client you need to use the tokens that SAP uses.  IE, look at the default CR layouts and you will see:

DocKey@ is a static numeric parameter that SAP replaces with the DocEntry of the document.  So if you define this parameter with this specific name it hides it and feeds the report the primary key of whatever document you are making the layout for.

The ObjectId@ is also static numeric and this passes the object type (23 for quotes, 22 for POs, etc.) so you can use this too if you want.

Just copy the SAP default layout style and setup your parameters the same as SAP and it should flow through cleanly.

Let me know!

M

PS. don't forget to set this up in your report selection formula.  You have to set {OXXX.DocEntry} = {?DocKey@} for it to pass properly into the data

[nikunjmehta2290]

Hi,

It is not working for me as same steps applied above. I don't use object ID here. I have used two table direct into CR and pass the DocKey as parameter and also pass the formula here.

But issue is remain same. 

Kind regards,

Nikunj 

[BattleshipCobra]

Have you imported this into the SAP Client?

Try making the DocKey@ parameter with no tables and then drag it onto the report, save it and load it into a document layout then do a print preview. You will see that it passes the DocEntry not into Crystal Reports Designer, but it's a special token in the SAP Client.

When testing in the CRD you will still need to enter your own DocKey. ObjectId@ is not required, but can be used if needed. It's another token passed from SAP --> CR Runtime WITHIN the SAP Client, not in the CRD (Crystal Reports Designer).

I hope this makes more sense, M