Can user access some data in one sheet which access is rejected in other sheets?

[#1]

hi,

I want to use section access to do this. But if use data reduction, all sheets' data is reduced. Can I control this separately.?

[#2]

Hi Manesh,

I mean I have to write many set-analysis expression in hundreds of charts. Can this be simpler?

[maneshkhottcpl]

Hi,

I will try to find some solution and revert u back.

[michael_anthony]

If you use an OnActivate sheet action (or event for v8) when the user switches sheets. You could then force the selection of the relevant year(s) and lock the selection using a macro.

Also, might pay to create a COPYYEAR field which is what you apply to selection on. You could also designate COPYYEAR as a system field (Use HidePrefix method) which makes it a bit harder for user to undo your select / lock step.

Wasn't sure from your requirements if the sheet should only show certain years for all users, or if a sheet should show certain years depending the user. eg. John sees 2010 and 2011 in sheet2, but Bob can only see 2010 in sheet2. If so, makes the macro a bit more complex, but not unworkable.

An alternative may be to create a listbox that includes the set analysis formula as a selection expression and have the macro select the valid values in the listbox. eg. =If(Count({set expr} COPYYEAR)>1,COPYYEAR)

[#5]

My requirements is: if a sheet should show certain years depending the user. eg. John sees 2010/2011 in sheet2 and 2009 in sheet3 , but Bob can only see 2010 in sheet2.

[#6]

hi Michael

Could you pls show me the details about the Macro.

[#7]

Any good idea?

This question worried me many days.

[#8]

Any one can help me .

I'm thinking about this for many days.

[#9]

Hi,

A very simple solution to your problem, could be to use two diffrent qvw files and tie them together with document chaining.

If not to heavy (not to many rows and fields) , with transfer status and open in same window (Ajax client) the user would not notice the change of qvw file....

Both document of corse have to use the Section Access described above.

You could have a master document to do the fully load then have the two qvw file do a binary load from the master. After the binary you could reduce the year accordingly and distribute them.

BR Hans

[#10]

Hello Hansiola,

I'm very interested by your solution, because i'm stucked with the same problem.

Could you give please more expalanation about the solution by loading the two qvw files into one master qvw file?

Regards