Creating the report in CPS

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.

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

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

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

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.

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.

2 Comments

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

Jonas Nielsen February 4, 2015 at 9:47 am

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!

like (0)
1. Nanda Kumar February 4, 2015 at 6:56 pm
  
  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
  
  like (0)