Possible solution: Open Crystal Reports Print Layout from UDO form

Advertisement

Hi all,
I recently had to print information of a UDO which I have on a new form. I searched through the forum and found different solutions, but none that used the new "integrated" crystal reports viewer. So I came up with this workaround, which so far works great. I post it here for anybody else needing this kind of workaround, or in case somebody has a better solution, pick that up.
Here it is:
1) Create your Crystal Report file and import using the Reports and Layouts screen in SAP Business One. Give it a meaningful name and location in the menu. Have at least one parameter to take the DocNum or DocEntry, or whatever your primary key is. (Note: I know the import can be done by SDK, but as far as I can see there's no way to place it in the menu structure just yet.)
2) In your Add-On in the event ID 520 (print), call the following function with the Document Number grabbed from the open form:
public static bool printUDO(string strDocNum)
            // get menu UID of report
            Recordset oRS = (Recordset)B1Connections.diCompany.GetBusinessObject(BoObjectTypes.BoRecordset);
            oRS.DoQuery("SELECT MenuUID FROM OCMN WHERE Name = 'ReportName' AND Type = 'C'");
            if (oRS.RecordCount == 0)
                B1Connections.theAppl.MessageBox("Report layout 'ReportName' not found.", 0, "OK", null, null);
                return false;
            // execute menu and enter document number
            B1Connections.theAppl.ActivateMenuItem(oRS.Fields.Item(0).Value.ToString());
            Form form = B1Connections.theAppl.Forms.ActiveForm;
            ((EditText)form.Items.Item("1000003").Specific).String = strDocNum;
            form.Items.Item("1").Click(BoCellClickType.ct_Regular); // abrir reporte
            return true;
I know it's kind of a dirty solution, but it works, and if you have any suggestions, I'd be happy to hear them.
Thanks!
Joerg.

Advertisement

Hi Joerg,
It's not a dirty solution... I like it and i'm using it
Thanks!
Best regards,
Ana Silva

November 30, -0001

Possible solution: Open Crystal Reports Print Layout from UDO form

Hi all, I recently had to print information of a UDO which I have on a new form. I searched through the forum and found different solutions, but none that used the new "integrated" crystal reports viewer. So I came up with this workaround, which

Crystal report using ABAP from SAP ECC6.0 EHP 3.0

Hi Gurus, Can i create crystal report using ABAP in SAP ECC 6.0 EHP 3 . as i am not able to see this link in SPRO. IMG > SAP NetWeaver > Application Server > SAP List Viewer > Maintain SAP GUI Specific Settings. Kindly guide me urgently.http:/

Importing form field layout from one form to another ?

I often create forms in both English and French. Many are long and complicated and I have to create them all individually. Is there any way I could use the form field layout from one form, for another form? That would be fantastic.Sure. To replace th

Printing Crystal Reports from UDO form

Dear Experts, I want to open a Crystal report from an addon. I've already found [the following thread|http://forums.sdn.sap.com/thread.jspa?threadID=2039424&start=0&tstart=0] and the [mentioned blog post|http://www.sdn.sap.com/irj/scn/weblogs?blog

Crystal Report Print Engine API calls  from Powerbuilder

I am using Crystal Report XI R2 with Powerbuilder 9.0. I  am using Crystal Report API calls using crpe32.dll to display my reports. When i run my reports from my development machine where Crystal Reports is installed the reports run properly, but whe

Open Crystal report from SAP BW

Hi, is it possible to open and refresh (thus passing parameters/values) a certain Crystal report (version 2008 SP3) from a SAP BW system (version 7.10), e.g. with a RFC call? If it's possible, which transaction do I have to call to setup this call? W

How to open Crystal Reports from Business Content Ext BW

Hi friends, I have activated 0CR_FIAA_M20_Q0007 Crystal Reports from Business Content Ext BW and I have configurated BW_Publisher services in BW but I do´t see reports in /CRYSTAL/RPTADMIN. I check RFC connection and it´s ok Here I can´t get a role a

Problem opening Crystal Report from SAP GUI through VPN

Hi Everyone,   I am facing an issue with opening the crystal report from SAP BW Role menu(SAP GUI). The issue is only with the BW Users who are connecting to the Client systems through VPN. All the settings are done perfectly in the Transaction /CRYS

Crystal Reports not editable from Mobile Sales in CRM 7.0

Hello Experts, We are using Crystal Reports in 4.0 and they are working well. I can open the reports in report Designer and can check all the details. Now we have performed a upgrade from 4.0 to 7.0 and getting some issue while executing one of the r

Crystal report print directly without crystal viewer

HI ! In my addon i use Crystal Report. What would be the code i need to add if i want to print directly instead of having to go thru the crystal viewer. The crystal viewer gives me lots of problems with painting the screen when i move the form and it

How to set Command Timeout in Crystal report while calling from C# code

I am using Crystal report XI R2.  I am calling SQL server 2005 stored procedure as source in the report. I want the report should timeout from the website if the stored procedure doesn't return resultset after 5 minute. Could you please assist how sh

Problem of installing Crystal Reports Print Control(ActiveX)

Environment Windows 20003 SP1 ASP.NET 2.0 Crystal Reports XI SP4 Background I am converting ASP application to ASP.NET. I used ActiveX Viewer on ASP. Now, I decide to use CrystalReportViewer and PrintControl(ActiveX) on ASP.NET. CrystalReportViewer.P

Where can I find a copy of the Crystal Report Print Control

Hello, Our users have access to a report portal developed in house which uses the Crystal Report Viewer to display the Crystal Reports created in Visual Studio 2010. the first time they open the portal and try to print the report the loading dialog b

Crystal report printing problem in Malayalam

Hi, I have a printing problem in Malayalam in crystal report.The viewer displays the correct font but the printed output displays the square boxes.I have installed the font.I am using Visual studio 2010 and crystal report 13.0 version.what could be t

How to access a Crystal Report .rpt file from with in SAP B1?

Dear Experts, Please explain me the steps involved in accessing a .rpt crystal report file from within SAP B1. Thanks in adv. Regards AnandHai Gordon, I do not have Crystal Reports Add-on Installed on the system. Should I get it installed on my syste

Open Crystal Report full screen at InfoView and hide navigation panel

Dear all, In InfoView, how to globally set so that Crystal Report document will be opened as full screen and also hiding the navigation panel. I know InfoView > Preference can open in full screen, but this must be done for each user. How to set it gl

Library of Crystal Reports (not Layouts) for 8.8

Hello All, Is there a library of sample CRystal Reports for SBO 8.8. I don't mean Layouts. I mean Crystal Reports for typical business reports like Ageing, Stock LIstings, SAles Analysis etc..Hi Christian Here is the latest version for you with 64 Bi

Crystal Reports Server install from download

I have been tasked by my manager to install & evaluate Crystal Reports Server. I have gone to the evaluation download site and downloaded the part 1 & 2 files. Part 1 extracts and give an error message stating that the archive is incomplete.  Once

Infoview error when opening crystal report

Anyone experienced this type of problem and managed to resolve it? Kindly assist. ThanksSorry I did not provide all the information. I get the error message u201CThe database login information for this report is either incomplete or incorrect".  This

How to avoid IE pop-ups when running BIP reports(w/ SSO) from Oracle Forms?

Hi all, We have an OID/SSO integrated Oracle Forms and BI Publisher environment in place. We/users expect the same behavior when running Oracle Reports or BIP reports from Oracle Forms... which means receiving no intermediate pop-ups and simply getti