User Response

building reports desktopintelligence
1

I would like to have current month qty and year-to-date qty on the same report.

My data is stored by Period (month). In my condition I have Less Than Or Equal To Prompt (“YTD through Period?”).

I have accomplished the year-to-date column.

How can I use the User Response function to only give me the period selected? For example, this month, I would like to show January and February in the YTD column and only February in the Month column.

Any suggestions?

Thanks.
Susan Fowler
ISM Fastening Systems

Listserv Archives (BOB member since 2002-06-25)

2

Susan,
You can use it as
UserResponse(Dataprovider(,“YTD through Period?”)

You can either type the prompt as it is or select it from the List of prompts in the Add Variables dialog box .

thx,
Vikas

Listserv Archives (BOB member since 2002-06-25)