Friday, June 22, 2012

Rowset FILL Method with JOIN / UNION Keyword

FILL method helps to fill stand alone rowset from database directly.

But sometimes it is required to fill rowset Using JOIN / UNION Keyword.

1. Using JOIN Keyword.

Local Rowset &rs = Createrowset(Record.TL_RPTD_TIME);

&rs.Fill("INNER JOIN PS_TL_RPTD_TIME TM ON TM.EMPLID = FILL.EMPLID WHERE FILL.PUNCH_TYPE = '0' AND FILL.EMPLID = :1", &emplid);



2. Using UNION Keyword.

Local Rowset &rs = Createrowset(Record.PERSON);

&rs.Fill("WHERE 1=0 UNION SELECT EMPLID, %DateOut(BIRTHDATE),BIRTHPLACE,BIRTHCOUNTRY,BIRTHSTATE,%DateOut(DT_OF_DEATH),%DateTimeOut(LAST_CHILD_UPDDTM) FROM PS_PERSON WHERE EMPLID = :1", &emplid);


Tuesday, June 5, 2012

Configuring Report Manager

 

Steps to configure and get Reports in Report manager.

1. Enable getting Reports in Report Manager.

2. Add New Folders.

3. Get new files to Process Monitor.

4. Assign/Create required Permission Lists/Roles to Users.

5. Configure the process.

6. Create a new run control id.

7. Run it.

8. Verify it.

 

For any reports to be visible to other people in Report Manager we need to do the following:

1. Activate the following Service Operations

pic1

  • · Check Active (in Default Service Operation Version)

pic2

2. To Add New Folders, add them here. This is just to group by folders and has no security tied to it.

pic3

  •   Verify they come up

pic4

3.  To get new files to Process Monitor

· Add PRL in System Settings –> Distribution File Options –> Add PRL & Description

pic5

  • Bounce the Process Scheduler
  • After running the report verify that the file is pulled up

pic6

4.  Create new permission list

pic7

  • Add Report Manager access and Report Viewer access.

pic8

  • ·Click Select All to give the Report Viewer Page access.

pic9

  • Add other Reports access. This gives the option to run the reports. If the users don’t want/need to run the reports this may be skipped.

pic10

5.  Add new Role

pic11

  • Add this role to users

pic12

  • Verify required users got the Role

pic13

6.  Change the Process Destination, set the Destination Source, Folder Name and Distribute To.

pic14

7.   Run the process

  • Create a new run control id

pic15

  • Chose the process

pic16

  • To ensure everything is correct, Click on the Job (Description)

pic17

  • Click on Distribution of required Process, we must be able to see the given Folder Name and the Role.

pic18

8.  Verify the distribution by going to Report Manager –> List

pic19

 

Thanks a lot to my friend Ranjan Patro (http://in.linkedin.com/in/ranjanpatro) for creating this document.