Displaying default value in prompts

building reports desktopintelligence
1

Hi,
I am new to BO 6.5. I have one doubt that is it possible to display any value as default in prompts.

  Whenever i click the refresh data icon the default values automatically will appear in prompt. Is it possible in BO 6.5 Deski.

  Help me out in this issue.

  Thanks in advance

sathish811 (BOB member since 2007-11-01)

2

Since you are new to the product a search on BOB with keywords ‘default value in prompts’ would have helped before opening this post.
Out of the box a prompt cannot be defaulted to any value.

.

haider :es: (BOB member since 2005-07-18)

3

Hi haider,
I searched the same in search option but there is no relevant topic available. Thats why i posted this in forum

sathish811 (BOB member since 2007-11-01)

4

Hi,
What default value you want?
If you run teh report with a default value then it will appear next time.
As said by haider, it may not be possible, but you can try out this work around.

Omkar Paranjpe :us: (BOB member since 2006-02-13)

5

Hi Omkar,
My default value is ALL. I came to know that prompt will display value what we given in last time while run the report.

            But i need ALL should display in prompt whenever i open and run the report. I dont want to display the old value what i given piror.

           Help me out in this.

Thanks for your reply

sathish811 (BOB member since 2007-11-01)

6

Hi,
I dont think so it is possible unless you put some VBA code for that. But I am also not sure whether it will help you or not.

Omkar Paranjpe :us: (BOB member since 2006-02-13)

7

If you want a static default value to always appear on clicking refresh then a small VB code snippet can be written in the document_beforerefresh() event.
Like this

Private Sub Document_BeforeRefresh(Cancel As Boolean)
ThisDocument.Variables.Add("Enter Value").Value = "ALL"
End Sub

.

haider :es: (BOB member since 2005-07-18)

8

default date in Prompt
how to set default dates in the prompts
Default Values
Default Values in prompts
Displaying default value in a prompt
…
There are plenty more, those are just the ones found on page 1 of a search of this forum. :slight_smile:

Dave Rathbun :us: (BOB member since 2002-06-06)