optional prompt page

[pooja]

we have SORTING propmt page
but everytime we have to select atleast one value to runthe report........

Is there any way that we can make the sorting prompt to Optional  so that we can run the report directly..................

I thak you for any response

pj

[lindero]

try query macro prompts in the data item. search for query macro in FrameworkManager documentation.

try this in your sorting data item:
#prompt('PROMPT_NAME','token','1')#

Select value within your list:
Framework Manager reference to the related query item, something like [GO Sales].[Product].[Product Line Code].

cheers