Capturing Username from logon screen & Changing Brio query dynamically

[quezak]

Hi,

I want to capture the Username from the Brio logon screen after it is validated, and based on this username I would want to generate the Brio report dynamically based on the roles he has defined in a table Eg Access to country -Belgium.In this case I want to limit the user to view data for country Belgium only.

Thanks in advance,
Zak

 

[neel07]

Try writing a EIS screen as a login. Ask the User to enter the User name and password check that with a query (Pass them as Limits to the Query).

 

[milsky]

ActiveDocument.Sections["Query"].Limits["Rlso User Name"].SelectedValues.Add(ActiveDocument.ODSUsername)
ActiveDocument.Sections["Query"].Process()

Use the ODSUsername to limit