How to access a variable in a Formula

building reports desktopintelligence
1

Hi,

I created a cell with the following formula:

= "start date: "

Now I want to append the date the user entered in the dialog which I created in the Query Panel / Conditions. I tried
= "start date: " + @variable(‘start date’)

no go

Any help greatly appreciated
Hannes

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

2

X-cc: “hannes.heckner@mgm-edv.de” hannes.heckner@mgm-edv.de

Cell Format:
="Start
Date: " + UserResponse(“QueryName”,“PromptName”)

For example, if you set up the prompt in the query panel to be ‘Start Date?’ then it would be like this:
="Start
Date: " + UserResponse(“Query1 with XXUNI”,“Start Date?”)

If you want to format this to be just the date you could do that also.

Tim

Tim Heuer
PacifiCare Health Systems
(714) 825-5702 - office
(800) 946-4645 pin 1404017 - pager
heuer_tk@exchange.phs.com

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

3

Sent: 10. elokuuta 1998 12:34

Hi,

I created a cell with the following formula:

= "start date: "

Now I want to append the date the user entered in the dialog which I created in the Query Panel / Conditions. I tried
= "start date: " + @variable(‘start date’)

no go

Any help greatly appreciated

Besides the UserResponse() -function, you can also check out ApplicationValue()-function, eg =ApplicationValue(“BOUSER”)

-Harri

Hannes

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