View Single Post
  #4 (permalink)  
Old November 14th, 2007, 16:04
chrisplough's Avatar
chrisplough chrisplough is offline
Site Moderator
 
Join Date: Jun 2006
Location: West Chester, PA
Posts: 821
Blog Entries: 7
Thanks: 53
Thanked 200 Times in 121 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 10
chrisplough has a spectacular aura aboutchrisplough has a spectacular aura aboutchrisplough has a spectacular aura about
Send a message via AIM to chrisplough
Re: Can Vpd's be used to filter Records of the Report

Honestly, I've never seen VPD used in quite this way -- instead I've always seen it used to restrict the data that a user is able to see based on table/row combinations.

It may, in fact, be possible, though instead of utilizing VPD, wouldn't it be easier to simply prepend those restrictions (Shipment Refnum Qual "Company_name" and Shipment Refnum Value "ABCD") to the report query itself? If not easier, I'm sure it would perform better, since VPD can have significant performance implications, depending on the use.

--Chris
__________________
Chris Plough
MavenWire

www.MavenWire.com
Reply With Quote