Like to have Prompt Values show in the report

Hi, All

I have difficulties to show prompt values in the report. For example, “From 05/02/2004 to 05/15/2004”.

Here is the situation, users like to see distinct customer number count between 05/02/2004 to 05/15/2004, and prompt values “05/02/2004” and “05/15/2004” is based on calendar day. If I select “Calendar Day” as object, the distinct count numbers are much higher because it also group by calendar day. However, if I don’t include “Calendar Day”, the Prompt Value is not able to show.

PromptFromValue=UserResponse(DataProvider() ,“From Date:”)

Can someone please help me out?

Thanks,
Xiangqun


xwang (BOB member since 2004-01-13)

Did you try Insert/Special Field/Query Prompt?


Cindy Clayton :us: (BOB member since 2002-06-11)

Cindy,

I tried Insert/Special Field/Query Prompt. It works…

Thanks for your help!

Xiangqun


xwang (BOB member since 2004-01-13)

My pleasure.

Welcome to BOB :mrgreen: and don’t forget to search.


Cindy Clayton :us: (BOB member since 2002-06-11)