• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

LBI Crystal Reports Bursting

 2 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Carl.Seay
Veteran Member
Posts: 110
Veteran Member
8/30/2010 4:24 PM
Hello,

I'm trying to burst a report to supervisors based on the departments they cover. In Reporting Services Administration, I've been able to set this up by using Import Rights, linking the supervisors user name to a specific department.

Since supervisors change and employees change departments, is it posible to automate the process of uploading user rights with a CSV file?

Thanks in advance for any input,

Carl Seay
Chris Martin
Veteran Member
Posts: 277
Veteran Member
8/30/2010 4:31 PM
Carl,

There is no delivered way to sync the user rights. However, you could write a script to sync the data at the database level. This does require an understanding of the LBI tables.

Chris
Carl.Seay
Veteran Member
Posts: 110
Veteran Member
8/30/2010 5:00 PM
Chris,

Thanks for your reply. I was able to track down the LBI tables and see the relationships. It's not very straight forward, but it definitely looks like a possibility.

Thanks,

Carl