Report & Layout Manager

[former_member275826]

Hi,

I have created User defined form. Now i have to display report when click on Preview button (Same as Standard document).

Can we use report & layout manager to display report.

Regards,

Pravin

[Former Member]

Hello

possible with development, and it is pending from the B1 version.

Easy solutions are:

- 8.81 you can use Crystal Reports and PLD

- 2007 you can use PLD only or CR integration addon

in Crystal:

- You can create your layout and you can import into the system as report (not layout) into a specific folder

- When you press the print or print preview button (eg menu action is indicated, menu id "520", "519"), then you can find the crystal report in the OCMN table with the following query

select MenuUID from OCMN where Name = N'YOUR_REPORT_NAME'

- next step is call the report with ActivateMenuItem and fill the parameters.

Complete code for crystal

            Dim oRs As SAPbobsCOM.Recordset = oCompany.GetBusinessObject(BoObjectTypes.BoRecordset)
            Dim sQuery As String
            Dim sMenuID As String
            sQuery = "select MenuUID from OCMN where Name = N'YOUR_REPORT_NAME"
            oRs.DoQuery(sQuery)
            If oRs.Fields.Count > 0 Then
                sMenuID = oRs.Fields.Item("MenuUID").Value.ToString
                m_SBO_Application.ActivateMenuItem(sMenuID)
                Dim oForm As SAPbouiCOM.Form = SBO_Application.Forms.ActiveForm
                oForm.Items.Item("1000003").Specific.String = docentry
                m_CrystalCriteriaFormID = oForm.UniqueID
                oForm.Items.Item("1").Click(BoCellClickType.ct_Regular)
            Else : m_SBO_Application.MessageBox("NO PRINTING LAYOUT EXISTS!")
            End If

In PLD, the logic is the same, but you must activate the User Queries print layout, and locate the report in the matrix.

Regards

János

[former_member275826]

Thanx Janos Sir for ur reply.

Iam using SAP 8.8.

I have imported Sales quoation, Sales order report through Report & layout manager.

Now i have created user defined form say Dispatch Memo. I am saving data of form in table Say ODSP & DSP1.

I have created crystal report for Dispatch memo form (Say crptDespath.rpt).

Can i import this report against Dispatch Memo form using report & layout manager?

Plz sir help me out.