Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to set up a document to be distributed via PDF, and have been able to successfully distribute the report during a refresh. Now, I am trying to set up the distribution so that users only get a report of the facility the belong to. There are 5 facilities (1,2,3,4,5), and the report has them broken out, but I only want a user to see their facility, not all 5. Any suggestions?
ps. Right now, i have the section access document for the facility assigned to the individual, but when I tested it that didn't work.
You need to do a loop and reduce on the users. That should do it for you.
Bill
You need to do a loop and reduce on the users. That should do it for you.
Bill
I have the loop and reduce set up on Facility Abbr (which I have in both the section access and section application), but this doesn't seem to be working. What am i doing wrong?
Hi Mike,
This is a hard question to answer without seeing how everything is setup in section access.
Are you using the qvw just to send PDF? If so I would remove section access and build a table that links the Facility to a user and then loop and reduce on the user.
Bill
I am not using the qvw strictly for the pdf.
My section access is set up like this:
ACCESS NAME USERNAME FacilityAbbr REDUCTION
I am using FacilityAbbr in both access and application to identify what data the User should see.