Hi everyone, hope you can help.

How do I create dynamic formula for Record Selection.
Noting that within the formula there is a prompt id {?userId}

This prompt will appear based on user roles. There are cases that some users will not see this prompt.

Thanks Dell,

We are actually trying to merge two reports right now, one for manager and the other for clerk. The only difference between the two is the number of prompts. Because of crystal's limitation we had to create two of the same report but with different prompt.

My objective is to merge these two and I am finding it impossible to do so in crystal report, mainly for two reasons. We are not able to determine the role of the users from CSC, and we don't know how to control which prompts to show either groups.

So we resorted to Business View and we are having loads of challenges there, namely prompts and formulas... have you faced anything like this to create/generate dynamic crystal reports based on user roles?

Thanks Dell

Thanks Dell, we actually tried Stored Procedures and Business View but could not come around to achieving the above :(