Friday, February 10, 2012   
 Search   
 

http://www.foxfirereporting.com
Register  Login  
Forums  
      
 Forums    
SearchForum Home
  Support  Foxfire! 6.0x Support  Hiding Data Ite...
 Hiding Data Items
 
 10/26/2007 10:19:27 AM
dmillson
11 posts


Hiding Data Items

Hi.

Is it possible to create data items that are only visible to some individuals? One of my company's clients wants to incorporate cost reporting using Foxfire, but they do not want every user who has access to Foxfire to be able to see this information.

Thanks,

Dale Millson

 10/31/2007 1:19:28 PM
AndrewM
145 posts
www.aksel.com
5th


Re: Hiding Data Items
Dale,

You can certainly do this with Foxfire! - if you look at the advanced area of the Data Item Editor, you will see an option for Miscellaneous values - this is typically where you can put values that you can use for filtering out data items. The field is called RDI_MISC.

Then in the Report Set Editor, in the System Files area for your report set, you should see that you can specify filters for all of the Foxfire! meta data including the data items.

Here's a quick way of doing a filter without having to worry about using the RDI_MISC field. Let's say the COST table holds our cost reporting and you only want users SYSTEM and ACCOUNTANT to have access to it.

In the Data Items Filter, you could add the following string:

IIF(rdi_alias1="COST",INLIST(pf_user,"SYSTEM","ACCOUNTANT"), .t.)

This essentially tells Foxfire! to show all data items to all users EXCEPT the COST alias which should only be shown if the Report Set (pf_user) value is SYSTEM or ACCOUNTANT.

Make sense?

Andrew
 11/1/2007 4:55:46 PM
chick
17 posts


Re: Hiding Data Items

Just a couple of minor points to clarify Andrew's answer:

In the v6 data item editor, the field where you enter your own data item suppression codes is located on the Advanced sub-dialog (press the Advanced button from the main form). The field is labeled: "User Definable Group ID's" You can type additional codes in there, separated by commas to identify one or more fields that you want to exclude.

In v6, what Andrew called the Report Set editor was known as the Preference Set Editor (sometimes it's called the Preference Set Picker). When you bring up this form, open the sub-dialog named "Files" and you'll see four sets of two fields each. Each set names a table where a particular data dictionary element is stored (e.g. Data Items) and a field where you can enter your filter expression (e.g. rdi_misc <> "xyz"). Now assuming you entered a code of xyz into the Rdi_misc field of the data item you wanted to prevent from being seen, when you choose that Preference Set, that field will be screened out and won't show up in picklists. .

 

 

 

  Support  Foxfire! 6.0x Support  Hiding Data Ite...
   
SearchSearch  Forum HomeForum Home     
 Links    
   
  
Downloaded from DNNSkins.com