How do you pass the data from a SBO process to a crystal report laout

[Former Member]

Hi Everyone

Can someone please assist or direct me to documentation that could be of help.

I do production orders in SBO.

I have a crystal report that I have imported as a layout to print these production orders.

The report was developed the normal way, linking to the tables and returning data(all data for all production orders ever done)

The production print option is set to make use of this layout.

What I would like to see is that when I create production order 12345 and click on print preview I get the data of the mentioned order only displayed in my crystal layout(that is set to default)

What I get however is all the data from the tables.

Where am I going wrong. With my design already or is there a different way to pass the data to my report/layout direct from my SBO production order screen

This is quite urgen

Regards

Burger

[Former Member]

Hi All

The solution i was looking for is:

In Crystal create the parameter called DocKey@

This is recognized by sap and the active document number is passed to the report layout.

In crystal itself also do a filter {<Table>.<Column Name>} = {?DocKey}

So simple once you know how.

Hope this help someone else that is as stuck as I was.

Regards

Burger

[Former Member]

It sounds like you need to set up a parameter for the value you want, then in the select expert, set the parameter to be equal to the value/field you need.

ie: Parameter

{?SelectNum}

Type = Number

Select Expert

{?SelectNum}={YourTable.YourField}

When the report is run,it will ask the user to enter the {?SelectNum} parameter then will return only the records where {yourTable.YourField} is equal to the value entered for {?SelectNum}