• On a related subject (I'm digging around in the catalog table at the moment) does anybody know what "Dynamic Prompt" relates to in the parameter field?

    it is entrenched in the xml for the parameters and as far as I have been able to tell is always false.

    <I'm looking at the 2008R2 version here>

    <Prompt>Report Date</Prompt>

    <DynamicPrompt>False</DynamicPrompt>

    <PromptUser>True</PromptUser>

    <DynamicDefaultValue>True</DynamicDefaultValue>

    </Parameter>

    Assumption is the mother of all F***ups