Hello Friends,

I am writing this is with referance to the question where one of our friend want to extract some information from system with the help of report.

To Create the report in CPS, once loged in into CPS go to “Definition–>Reports”. Right click to Report and choose New Report (you can duplicate the already created report too).

Step 1: Fill in the basic required details.

report1.JPG

if you want to fetch the data from database table then please provide the table name in the query.

reporttable.JPG

Step 2: Please add the column which you want to display in the output and you want to use in selection filter.

reportcolumn.JPG

Step 3: If you want then please add the selection.

reportselection.JPG

Step 3: Please cross check the report preview in “Report Privew” tab.

Step 4: Once done with all above step please SAVE the report created.

Step 5: Then for getting output submit the report.

Step 6: Please select the report format you want and submit the report.

reportformat.JPG

Step 7: Then please find the out put file and do the needful.

Hope this will clear how to create the report.

Please correct me in case any mistake/Correction in the content.

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

  1. Jonas Nielsen

    Thanks for this.

    However, I´m trying to extract a list of the following parameters from our Job Defintions: JOBNAME, ABAP_PROGRAM_NAME, ABAP_VARIANT_NAME and EMAILALERTADDRESS and I´m unable to do so. Seems like it picking up the information from the running jobs, and not from the Job Deifination on the Defintions tab. Any ideas?


    Thanks!

    (0) 
    1. Nanda Kumar

      hey Jonas,

      The table – Job doesn’t have information you’re requesting. They are part of JobDefinitionParameter Table.

      the default reporting cannot be used to create the report you are requesting. It is a little complex and you can do it using Redwood script.

      Gerben Blom have already provided a simple query from which you can improvise for your requirement

      thanks

      Nanda

      (0) 

Leave a Reply