Submit Your Suggestions for Viewpoint Team

Currently the lookups are not using the job security that Vista uses when users lookup the jobs to run reports. When you have a lot of jobs, this can become cumbersome when most users only have access to 1 or 2 max. Also, we do not like our users to see a list of all jobs we have done or are doing since some of these are pre-con, not yet awarded etc, so having everyone see them is a concern.

In HFF with an SSRS report, we can use a parameter that looks at each user's AuthToken that can be linked back to Vista so only their jobs show. It's a lot of work to have to manually change every crystal report and every stored procedure and sql view to add this customization, but this should be something that could be coded by Analytics to happen automatically in the backend since the conenctiosn are already there.

This is what I use in HFF for the Report Library reports for the Jobs datasource.

JobList

as

(SELECT p.Job,j.Description as JobName

FROM JCJP p inner join JCJM j

ON p.JCCo=j.JCCo and p.Job=j.Job INNER JOIN DDDS on p.JCCo = DDDS.Qualifier and p.Job= DDDS.Instance and DDDS.Datatype = 'bJob'

INNER JOIN DDSU on DDDS.SecurityGroup = DDSU.SecurityGroup

INNER JOIN [KDS-HRIM].dbo.HRAuthToken on DDSU.VPUserName = HRAuthToken.VPUserName and HRAuthToken.AuthToken = @AuthToken

where p.JCCo=1
)