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

[Abdul]

Simply remove the parameter from crystal report

[nikunjmehta2290]

Hi, But When I remove the parameter then it is showing all data instead of document wise.

[BattleshipCobra]

Hi Nikunj,

Have you tried removing the field from the report and then removing the parameter?

Crystal Reports should be able to handle all of the page numbering with the "Special Fields" >> "Page N of M" or "Page Number".  You could also do a formula and output the page number or you could do a variable and do your own calculation.

Unless you have B1UP: Print & Delivery where you can just hardcode the parameter you should remove it and try another solutions.

Good luck,

Mike