Refresh on Open option for Crystal Report?

building reports crystal reports
1

Hi All,
In Business Objects Webi if we want to refresh the report when we open it.
We have an option called “Refresh On Open”.

How can I achieve that in Crystal Reports?

GNK_BO (BOB member since 2007-07-17)

2

Crystal doesn’t really persist with data like Webi does. It’s going to refresh when opened in InfoView unless you are looking at an instance.

V

Eric Vallo :us: (BOB member since 2002-08-15)

3

Hi Eric,
Thanks for the info.

I have another question.
I Webi we can capture the user entered values when we have prompts by using USERRESPONSE function to display that values in the report.

Do we have anything similar to that in Crystal Reports?

GNK_BO (BOB member since 2007-07-17)

4

I don’t actually have Crystal open in front of me but I think it is under @Functions or something like that in the field explorer. CECurrentUserName or something like that if I’m not mistaken.

If working on a universe based query, you can still use @variable(‘BOUSER’) in the query.

V

Eric Vallo :us: (BOB member since 2002-08-15)

5

I was a bit off here, sorry. Check under Special Fields on the Field Explorer. Lots of built in functions for document/user centric capabilities.

V

Eric Vallo :us: (BOB member since 2002-08-15)

6

There is no special function needed. You can just pull the prompt on to the report to show the Users Response to it.

psurphr :us: (BOB member since 2008-02-28)

7

Ack my bad. I totally misread the request. Thanks for correcting there Mitchell.

V

Eric Vallo :us: (BOB member since 2002-08-15)

8

Mitchell, I tried to click and drag the field over but it did not work!?

Any other method to get the UserReponse value?

We are using Crystal 8

di652 (BOB member since 2005-02-24)