BusinessObjects Board

@prompt issue

building reports webintelligence
#1

HI
I need dynamic filters in my crystal reports. For This I am creating the Prompt logic in the objects.but I am getting the error when I parse. I don’t why I am getting this error. Could you please suggest where I am making mistake :

@Prompt(‘Enter Account’,‘A’,‘Account\Account Name’,multi,constrained,not_persistent,{‘WNET’})

This is the error that I am getting

Parse Failed: Exception:DBD,[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.State:42000

Thanks
Pallavi

pallavim (BOB member since 2011-05-26)

#2

The default value {‘WNET’} has to be placed earlier, not as the last parameter. The last parameter is for the Order of display of the prompt. If you are on XIR2, even after this change, the object will not parse, because the extended syntax of @prompt (not_persistent and order of prompts) is not recognised in the Universe. When you use the object in the report, it will work despite it not parsing.

nithya_raj (BOB member since 2007-02-03)

#3

Thanks a ton Nithya :slight_smile: This totally worked!

Can you also guide me how to add the option All to it?

Thanks again,
Pallavi

pallavim (BOB member since 2011-05-26)

#4

This post in the Designer FAQ is extremely useful.

https://bobj-board.org/t/15227/2

nithya_raj (BOB member since 2007-02-03)