Hi, I would want to use replace() function at once to
1) remove comma(,) from year 2,013 as Replace(PromptSummary();",";"")
2) replace *** Query Name:Query ***" with "Prompt Parameters:" as replace(promptsummary();"*** Query Name:Query ***";"Prompt Parameters:")
3) replace (optional) with ""
etc.
I have these separate working okay but how do I have all three together in a single statement. I did not want to use UserResponse() function in the report.
Tried =Replace(PromptSummary();",";"") and replace(promptsummary();"*** Query Name:Query ***";"Prompt Parameters:") with AND but no luck i know this is a wrong SQL.
I would appreciate your help on this
Thanks, Kris