Prompt defaults

[JuliaM]

Hi all,

I have a report that uses filter defined in frameworks for each user for their sales territory. In some cases there are more that one territory. I have a prompt that allows changing territory for the report. The problem is - I can't default report to all territories initially, it comes up blank, untill territory is selected. I can't manage to default to the pre-defined filter data. Help!
Thanks!

[wyconian]

Hi

have you set the filter on your report to be optional?  If you do the report should show all regions if you don't select anything in the prompt.

[JuliaM]

Hi,
Thanks for your answer. Yeah, filters are optional, the problem is - I don't want ALL data, I only want the data from filters.
I think I need some sort of if/else - if prompt is null, then territory = filters(from frameworks), else , territory = prompt... I can't figure out how.

[wyconian]

Ah OK I understand.

I'm not sure how you could do that without making your users slect something at the prompt.  You could try adding a static value like 'Model Prompts' which you could set as your default.  In the filter you could then say
(?prompt? = 'Model Prompt' and territory = filtersfrommodel) or territory = ?prompt?  But the users would have to select the static value for that to work.

Is that any help?

[JuliaM]

Thanks! I ended up adding both filters (framework filter and ?rep? filter) to all queries including prompt query, somehow it worked!  8)