Skip to Content
Former Member
Jan 28, 2010 at 03:07 PM

Modify Dynamic Prompt Values based on User Name



I did some searching for this issue on the forum and could not quite find anyone with the same problem. If I missed something, please except my apologies in advance.

I have created a report within Crystal Reports 2008 with dynamic prompts. The report pulls possible values for the report directly from my database (MS SQL 2005). This works well.

I have deployed the report, with eclipse, under tomcat using the free JRC components provided by SAP.

This is a financial report which allows users to view the budget of a department. Each user will have one or many departments that they should have access to. Not everyone sees the same departmental information. I have a table that contains the user name of each individual and the department code they should have access to.

One of the dynamic parameters I have in the report now lists all department codes. Would it be possible to pass to the report a user name that would limit the listing within the department code parameter to only those departments the user name has access to (as specified in the security table I have setup for this)?

I need to do this within the JRC and not the Business Objects EDGE server. With this in mind, I do not believe I can use any of the RAS components of the JRC.

Thanks, in advance, for any advice or help you may be able to provide,