How to create prompt in Crystal 2008 using universe

building reports crystal reports
1

Hi All,

Please can you provide steps to create a Prompt using universe.

I need to Add ‘All’ to select in Prompt.

Please can you help me out.

Thank you,
Ravek.

ravek (BOB member since 2006-08-03)

2

the only way you can create prompt using the universe connection by making your report flexible.

to do this you need to create an static prompt then indicate the data you want to view such as customer, region, country etc. the only disadvantage of this you cannot filter the report using the prompt created.

next under formula fields create formula by typing this code:

WhileReadingRecords;
SWITCH(
{?Column}=‘Country’, {Customer.Country},
{?Column}=‘Region’, {Customer.Region},
{?Column}=‘City’, {Customer.City},
{?Column}=‘Customer’, {Customer.Customer
Name},
{?Column}=‘Employee’,
{Employee.First Name}
& “ “ & {Employee.Last Name},
True, ‘ ‘
)

transfer the created formula to your report then try to refresh to view the outcome of the prompt.

i hope this can help.

nahtanoj :philippines: (BOB member since 2009-07-08)