Oracle Reports: Compress PDF

specifies which components are permitted to make use of the PDFCOMP keyword

PDFCOMP-Enabled Components are Listed Below.

rwclient = yes 
rwrun = yes 
rwbuilder = no 
rwconverter = no 
rwservlet = yes 
rwserver = no

Description  

Specify whether or not the PDF output should be compressed using the PDFCOMP command.

Syntax PDFCOMP=value|{YES|NO}
Values 

• Value Any number between 0 and 9. A value of 0 indicates that no compression will be applied to PDF output. A compression level of 1 through 9 will be applied to the PDF output, and users will be able to adjust the amount of compression.
• YES Compression level 6 is used to compress the output.
• NO Compresses the output to the lowest possible compression level (no compression).

Default 6

I hope it's helpful for you. If you have any queries, don't hesitate to contact me.

Name : Muhammad Sahal Qasim

E-mail : s.m.sahal789@gmail.com

Thank you.

Read More

Direct Print using Webutil

Step 01:

First you have to create the procedure with the name of Print_Directly.

========================================================================

Step 02:

Procedure Print_Directly(In_Server_Name Varchar2,

                          In_Rep_Name    Varchar2,
                          In_Obj_Name    Varchar2) Is
  Lc$rep           Varchar2(100);
  Lc$rep_Status    Varchar2(20);
  Lc$ln$adobe_Path Varchar2(500);
  Ln$process_Id    Webutil_Host.Process_Id;
  Repid            Report_Object;
  Lc$file_Path     Varchar2(1024);
  Printer_Path     Varchar2(2000);
  Lc$temp_Path Constant Varchar2(256) := '\\192.168.10.5\temp\';
  Pl_Id Paramlist;
Begin
  Pl_Id := Get_Parameter_List('tmpdata');

  If Not Id_Null(Pl_Id) Then
    Destroy_Parameter_List(Pl_Id);
  End If;

  Pl_Id := Create_Parameter_List('tmpdata');
  Add_Parameter(Pl_Id, 'v_id ', Text_Parameter, :Vn);
  Lc$file_Path := Lc$temp_Path || In_Rep_Name || To_Char(Sysdate, 'hhmiss') ||'.pdf';  
  Repid := Find_Report_Object(In_Obj_Name);
  Set_Report_Object_Property(Repid, Report_Filename, In_Rep_Name);--'<Directory_Location>\myreport.rdf'
  Set_Report_Object_Property(Repid, Report_Server, 'rep01');
  Set_Report_Object_Property(Repid, Report_Execution_Mode, Batch);
  Set_Report_Object_Property(Repid, Report_Comm_Mode, Synchronous);
  Set_Report_Object_Property(Repid, Report_Destype, File);
  --File name must be unique otherwise it will override the old file with same name  
  Set_Report_Object_Property(Repid, Report_Desname, Lc$file_Path);
  Set_Report_Object_Property(Repid, Report_Desformat, 'pdf');
  --Add_Parameter(pl_id,'repot paramter', TEXT_PARAMETER, form parameter);
  Lc$rep        := Run_Report_Object(Repid, Pl_Id);
  Lc$rep_Status := Report_Object_Status(Lc$rep);
  While Lc$rep_Status In ('RUNNING', 'OPENING_REPORT', 'ENQUEUED') Loop
    Lc$rep_Status := Report_Object_Status(Lc$rep);
  End Loop;
  If Lc$rep_Status = 'FINISHED' Then
    --IF WEBUTIL_FILE_TRANSFER.IS_AS_READABLE (LC$FILE_PATH)  
    -- THEN  
    -- Try to get the correct instaled version of Adobe Reader program  
    For i In Reverse 5 .. 13 Loop
      Begin
        Lc$ln$adobe_Path := Client_Win_Api_Environment.
                            Read_Registry('HKEY_LOCAL_MACHINE\SOFTWARE\Adobe\Acrobat Reader\' || i ||
                                          '.0\Installer',
                                          'Path',
                                          True);
      Exception
        When No_Data_Found Then
          --If path not exists in Registery, it will raise NO_DATA_FOUND EXCEPTION  
          Null;
        When Others Then
          Message('others');
      End;
      If Lc$ln$adobe_Path Is Not Null Then
        Exit;
      End If;
    End Loop;
  
    Begin
      Ln$process_Id := Webutil_Host.
                       Nonblocking('cmd.exe /c start AcroRd32.exe' ||
                                   ' /H /P ' || Lc$file_Path);
    Exception
      When Others Then
        Null;
    End;
    --sleep for sometime until printing is finished  
    Dbms_Lock.Sleep(3);
    -- Teminate PDF Reader Program Process  
    If Not Webutil_Host.Id_Null(Ln$process_Id) Then
      Webutil_Host.Terminate_Process(Ln$process_Id);
    End If;
  Else
    Message(Lc$file_Path || ' is unreadable path at application server');
  End If;

========================================================================

Step 03:

Now Call this procedure to button where you want to call it.

I hope it's helpful for you. If you have any queries, don't hesitate to contact me.

Name : Muhammad Sahal Qasim

E-mail : s.m.sahal789@gmail.com

Thank you.

Read More

SAP Certified Development Associate - ABAP with SAP NetWeaver 7.50 Part -4

 

Question 26

Ques:- You need to create a piece of code that can be used by multiple programs. Which of the following

techniques for modul arization does SAP recommend? (2 Correct)

1. A function module in a function group

2. A method in a global class

3. A subroutine in a program

4. A method in a local class

Correct Answer : 1,2

Question 27

Ques:- Which of the following is correct?

1. The screen attributes can be modified in the PROCESS BEFORE OUTPUT event block.

2. None of the above.

3. The screen attributes can be modified in the PROCESS AFTER INPUT event block.

4. The screen attributes can be modified in the PROCESS BEFORE OUTPUT and PROCESS AFTER

INPUT event blocks.

Correct Answer : 1

Question 28

Ques:- How can you maintain documentation for input fields on your screen?

1. Define text tables for the underlying structure.

2. Add documentation to the SCREEN table at PROCESS BEFORE OUTPUT (PBO).

3. Add documentation to the SCREEN table at PROCESS AFTER INPUT (PAI).

4. Add documentation to the underlying data element.

Correct Answer : 4

Question 29

Ques:- What scheduling technique is used by the ABAP debugger dispatcher for processing user

requests?

1. Shortest First

2. Multiple Queue

3. Round Robin

4. First in, First out

Correct Answer : 4

Question 30

Ques:- How many kinds of internal tables are supported in the ABAP language?

1. 2

2. 3

3. 1

4. 5

Correct Answer : 2

Question 31

Ques:- Identify the key capabilities of SAP NetWeaver. (3 Correct)

1. Service-oriented architecture (SOA) middleware

2. Security and Identity management

3. Business intelligence

4. Customer Relationship Management

5. Supply Chain Management

Correct Answer : 1,2,3

Question 32

Ques:- Java is an object-oriented and a platform-independent programming language.

1. TRUE

2. FALSE

Correct Answer : 1

Question 33

Ques:- In a three-tier client-server configuration, the application layer processes can be spread across

multiple hosts.

1. TRUE

2. FALSE

Correct Answer : 1

Question 34

Ques:- What are the advantages of a three-tier client-server configuration as compared with a single-tier

or two-tier configuration? (2 Correct)

1. Simpler scalability

2. Simpler administration

3. Load balancing

4. None of the above

Correct Answer : 1,3

Question 35

Ques:- Which of the following is true about the key areas of SAP products? (3 Correct)

1. On premise

2. On mobile

3. On demand

4. On request

5. On device

Correct Answer : 1,3,5

Question 36

Ques:- SAP Business All-in-One is the ideal solution for small and midsize companies with stable

processes and that want to use a preconfigured system from SAP.

1. TRUE

2. FALSE

Correct Answer : 1

Question 37

Ques:- Which of the following stores the user data in SAP systems ?

1. User record

2. User master record

3. Stored record

Correct Answer : 2

Question 38

Ques:- The following strings are valid entries in the command field in the SAP Easy Access screen. (4

Correct)

1. /nend

2. /nex

3. ?SM04

4. /nsm04

5. From SAP Easy Access: SM04

Correct Answer : 1,2,4,5

Question 39

Ques:- Identify the statements that accurately describe a client in an SAP system. (2 Correct)

1. A client represents a completely independent business entity.

2. A client has its own database.

3. A client corresponds to a customer.

4. A client may represent an entire company.

Correct Answer : 1,4

Question 40

Ques:- Which of the following personalization options are available in the SAP GUI. (3 Correct)

1. You can change the font size in the SAP GUI within a certain range.

2. You can display system messages in a dialog box.

3. You can vary the size of input fields.

4. You can deactivate the display of pictures in the SAP GUI.

5. You can integrate your picture into the SAP Easy Access screen.

Correct Answer : 1,2,4

Question 41

Ques:- Which of the following is a true statement? (2 Correct)

1. A standard table should always have a unique key.

2. A standard table should always have a multiple key.

3. A hashed table should always have a unique table key.

4. A sorted table can have a unique or a non-unique key.

Correct Answer : 3,4

Question 42

Ques:- In which program types can you create dialog screens? (3 Correct)

1. Interface pool

2. Module pool

3. Executable program

4. Function group

5. Class pool

Correct Answer : 2,3,4

Question 43

Ques:- Using the screen system table, what can you modify through a LOOP AT SCREEN … ENDLOOP

construct?

1. Screen status

2. Function code of buttons

3. Attributes of screen elements

4. Values of screen elements

Correct Answer : 3

Question 44

Ques:- Which of the following are incorrect statements? (2 Correct)

1. TYPES: Str TYPE STRING LENGTH 20.

2. TYPES: carrid_ty LIKE spfli-s-carr_id.

3. TYPES: date_ty TYPE D LENGTH 10.

4. TYPES: werks TYPE C LENGTH 4.

Correct Answer : 1,3

Question 45

Ques:- Which parameter types can be used in the signature of a functional method? (2 Correct)

1. CHANGING

2. IMPORTING

3. EXPORTING

4. RETURNING

Correct Answer : 2,4

Question 46

Ques:- Can you search for suitable classic Business Add-Ins(BAdIs)? (2 Correct)

1. Search for suitable entries in the relevant component in the Implementation Guide (IMG)

2. Use the SAP menu Tools -> ABAP Workbench -> Development -> Business Object Builder

3. Search in an application program for the method GET_INSTANCE of class CL_EXITHANDLER

4. Search in the Repository Information System and choose Enhancements - >Customer Exits

Correct Answer : 1,3

Question 47

Ques:- Which of the following are valid control level changes within a loop over an internal table? (2

Correct)

1. SUM

2. COLLECT

3. LAST

4. END of

Correct Answer : 3,4

Question 48

Ques:- You want to display a dialog box in your ABAP program. Which statement do you use?

1. SET SCREEN 200.

2. CALL SCREEN 200.

3. CALL SCREEN 200 STARTING AT 5 5.

4. WINDOW 200 STARTING AT 5 5.

Correct Answer : 3

Question 49

Ques:- What is the allowed length of the ABAP Dictionary data type DF16_DEC?

1. The allowed length is 16 digits.

2. The allowed length is between 0 and 16 digits.

3. The allowed length is between 1 and 15 digits.

4. The allowed length is between 0 and 15 digits.

Correct Answer : 3

Question 50

Ques:- When is an ENDSELECT not required for a SELECT? (3 Correct)

1. When you do a SELECT SINGLE

2. When the FROM is a view

3. When you specify into a table

4. When you specify a join of tables

5. When you specify appending a table

Correct Answer : 1,3,5

 

I hope it's helpful for you. If you have any queries, don't hesitate to contact me.

Name : Muhammad Sahal Qasim

E-mail : s.m.sahal789@gmail.com

Thank you.

Read More

SAP Certified Development Associate - ABAP with SAP NetWeaver 7.50 Part -3

 Question 1 

Ques:- Which statement ends a screen sequence and starts from initial screen?

1.       CALL SCREEN

2.       LEAVE SCREEN

3.       SET SCREEN 0

4.       LEAVE TO SCREEN

Correct Answer : 3
Question 2 

Ques:- Which of the following predefined data types are character types? (3 Correct)

1.       N

2.       D

3.       X

4.       T

5.       P

Correct Answer : 1,2,4
Question 3 

Ques:- Your colleague has asked you to analyze and ABAP program that does not behave correctly when a button is pressed on the initial screen. You want to start Debugger when the button is pressed so that you can perform your analysis. What do you type in the command field?

1.       /n

2.       /hx

3.       /h

4.       Jdbg

Correct Answer : 3
Question 4 

Ques:- What is the event block that all of your code changes belongs to if you do not explicitly code any event blocks in an executable program?

1.       AT SELECTION-SCREEN OUTPUT

2.       LOAD-OF-PROGRAM

3.       INITIALIZATION

4.       START-OF-SELECTION

Correct Answer : 4

Question 5 

Ques:- Which of the following rules must you follow when creating subscreens? (2 Correct)

1.       Subscreens CANNOT have an AT EXIT-COMMAND module.

2.       Subscreens can have a dialog module containing SET PF-STATUS.

3.       Subscreens can call other subscreens.

4.       Subscreens CANNOT have a field of type OK.

Correct Answer : 1,4

Question 6 

Ques:- What options do you have when setting a watchpoint? (2 Correct)

1.       Stop at any change of a specific variable.

2.       Stop at predefined conditions for all variables.

3.       Stop at any change of all variables.

4.       Stop at predefined conditions for a specific variable.

Correct Answer : 1,4

Question 7 

Ques:- What is the difference between SAP Basis and SAP NetWeaver?

1.       All versions of SAP NetWeaver require the use of Unicode.

2.       There is no difference; the name change was driven by marketing alone.

3.       All versions of SAP NetWeaver include the ability to handle HTTP requests.

4.       All versions of SAP NetWeaver require the use of UTF-8.

Correct Answer : 3

Question 8 

Ques:- A view can only be displayed in which circumstances?

1.       It cannot always be displayed.

2.       It contains an inbound and outbound plug.

3.       It has been embedded in a window.

4.       It can always be displayed.

Correct Answer : 3

Question 9 

Ques:- When is a foreign key check performed on an input/output field?

1.       If the field refers to the dictionary field for which a search is defined

2.       If the field refers to the dictionary field for which a append search is defined

3.       If the field refers to the dictionary field for which a check table is defined

4.       If the field refers to the dictionary field for which a value help is defined

Correct Answer : 3

Question 10 

Ques:- Which message types behave the same regardless of the context in which they are called? (2 Correct)

1.       X

2.       S

3.       A

4.       W

5.       E

6.       I

Correct Answer : 1,3

Question 11 

Ques:- In a subclass, you want to redefine a method of the super class. Which of the following conditions must be fulfilled? (2 Correct)

1.       The subclass method has a lower visibility than the super class method

2.       The superclass method is an instance method

3.       The subclass method has same visibility as the super class method

4.       The super class method is abstract

Correct Answer : 2,3

Question 12 

Ques:- What is the default length of the type C data type?

1.       10

2.       1

3.       1–65535

4.       100

Correct Answer : 2

Question 13 

Ques:- You want to translate dynamic text in a web dynpro. From which abstract class should you inherit?

1.       CL_WD_COMPONENT_ASSISTANCE

2.       CL_WD_CONTEXT_SERVICES

3.       CL_WD_CONFIGURATION_MODEL

4.       CL_WD_COMPONENT_SERVICES

Correct Answer : 1

Question 14 

Ques:- Which of the following statements dynamically changes the data type of field z1?

1.       Move z1 to

2.       Unassign

3.       Assign z1 to casting

4.       Assign z1 to

Correct Answer : 3

Question 15 

Ques:- Which of the following can you do with the ABAP debugger? (3 Correct)

1.       Analyze memory usage.

2.       Analyze SQL traces.

3.       Change source code.

4.       Compare data objects.

5.       Analyze internal tables

Correct Answer : 1,4,5

Question 16 

Ques:- A work process…

1.       Stays linked toa screen through the dispatcher.

2.       Becomes inactive while waiting for a user.

3.       Becomes active while waiting for a user.

4.       Uses a common memory area called shared memory.

Correct Answer : 4

Question 17 

Ques:- Where can you define global data types that are visible system-wide? (3 Correct)

1.       In a global interface

2.       In the ABAP Dictionary

3.       In a method of a global class

4.       In a function module

5.       In a global class

Correct Answer : 1,2,5

Question 18 

Ques:- A structure has enhancement category 3, can be enhanced (character-type). Which set of elementary types is allowed for the new fields?

1.       F,I,P,X

2.       D,I,string,T

3.       C,D,N,T

4.       C,D,N,X

Correct Answer : 3

Question 19 

Ques:- Which of the following is a true statement? (2 Correct)

1.       An access key is required to implement business add-ins.

2.       An access key is required to implement an implicit enhancement point.

3.       An access key is required to enhance an SAP application using a user exit.

4.       An access key is required to modify SAP repository objects.

Correct Answer : 3,4

Question 20 

Ques:- What can be part of the signature of an instance constructor? (2 Correct)

1.       Export parameters

2.       Exceptions

3.       Changing parameters

4.       Import parameters

Correct Answer : 2,4

Question 21 

Ques:- How do you use a sorted internal table? (2 Correct)

1.       You need to specify a key in the table declaration

2.       You can read the records by index or key

3.       You can resort the table with SORT

4.       You use APPEND to insert records at the correct position

Correct Answer : 1,2

Question 22 

Ques:- You enhance an SAP standard global class by defining a post-method for an SAP method. The original SAP method has an EXPORT parameter named PARM1. Which parameters does the postmethod have?

1.       An OMPORT parameter named PARM1

2.       A RETURNING parameter named PARM1

3.       A CHANGING parameter named PARM1

4.       An EXPORT parameter named PARM1

Correct Answer : 3

Question 23 

Ques:- Function modules provide which types of parameters? (4 Correct)

1.       Output

2.       Exceptions

3.       Input/output (changing)

4.       Input

5.       Return values

Correct Answer : 1,2,3,4

Question 24 

Ques:- Which statement is true?

1.       A database LUW must be placed without an SAP LUW.

2.       A database LUW cannot be placed within an SAP LUW.

3.       An SAP LUW must be placed within a database LUW.

4.       A database LUW must be placed within an SAP LUW.

Correct Answer : 3

Question 25 

Ques:- When are the changes to the VB* table transferred to the database?

1.       When an update function module is executed

2.       When the enqueue work process is executed

3.       When the update work process is executed

4.       When the main program is executed

Correct Answer : 3

I hope it's helpful for you. If you have any queries, don't hesitate to contact me.

Name : Muhammad Sahal Qasim

E-mail : s.m.sahal789@gmail.com

Thank you.

Read More