Monday, March 26, 2012

Remove "CONSTRAINED" flag on Paramaters using Graphical Interface

I'm using MS Report Designer 2005.

When I create a parameter using the checkbox in the graphical design mode's filter pane, Report Designer automatically sets the constrained flag, eg:

STRTOMEMBER(@.ToWorkItemSystemId, CONSTRAINED)

How do I remove this? I can't do it in the generated text query because the program only let you edit mdx queries graphically or textually EXCLUSIVELY?

Once you switch to MDX mode, you cannot go back to Designer mode. Or, rather, if you do, your manual changes will be nuked because the designer doesn't support reverse-engineering manual changes.

I am curious though, why would you want to remove the CONSTRAINED flag?

|||

Please disregard. I was getting an error that my Parameters were invalid due to the contrained flag. I've since figured out that they were in the wrong format.

In any case, if a flag set\removed textually, it would be nice if there a way to do the same graphically.

No comments:

Post a Comment