If you are unable to create a new account, please email support@bspsoftware.com

 

I have a Date prompt in Report From date and Todate, I need to set From date as

Started by sudharanee@gmail.com, 21 Mar 2014 05:06:12 PM

Previous topic - Next topic

sudharanee@gmail.com

Hi All,

in detail, This Requirement is very different with regular , i m trying to understand is this requirement is feasible ??? for One set of user i  have incorporated using java script , it but this is giving me tough time.

If User A profile runs report Report should take default value for Fromdate as Todate-30 and Todate is Today

If User B profile runs report Report should take default value for Fromdate as Todate-60 and Todate is Today

If User C profile runs report Report should take default value for Fromdate as Todate-90 and Todate is Today

yOur Help would be great appreciated.
Thanks
Sudha

navissar

Let's assume you have 10 users.
Jack, Mary and Dianne are profile A
Sheila, Mark and Kathrine are profile B
Robert, Don, Fred and Claire are Profile C.
You create a parameter map with this data - the user name is a key, the profile is a value.
You set your custom date JS as usual, and you can use a macro to find the user name and look it up in the parameter map, and get the profile:
#sq($userProfileParamMap{$account.defaultName})#

If you have many users, this method won't work well - param map will burden performance. Other methods such as passing the profile as a session parameter or looking for a relevant identifying AD group.
Good luck!