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.

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.

sql

Remotely Connect to MSDE

Hi
I just installed MSDE over my Windows 2003 box and facing an small problem.
I installed it with SQL security mode and also set a password for user "sa".
Everything looks just fine using "osql" as it uses local address.
But I can't connect to my server from another computer using VS.NET Server Explorer.
It seems as MSDE is set to reject connections from outside by default.
My question is how to enable it so I can connect using my "sa" account.
Appreciate your help in advance.OK. are you trying to connect by IP address or server name? do you have a firewall installed?|||Since I am connecting from outside of the server, I am using IP address.
And also I don't have any firewall installed.|||at a guess I'd say you have only windows authentication enabled. not 100% sure how to change that in MSDE, but I'll scout around and see.

Remote synchronise from PDA to SQL Server 2005

What is the best way to synch with a very large database (e.g. 40,000 products in Inventory Master) in connection oriented way and also offline mode for remote synchronizing the Data from PDA to SQL Server 2005. Kindly provide us some of the best practices on this concept.

Thanks

I answered the same question from you in other forum "SQL Server Replication"

Thanks,
Laxmi

sql

Remote Installation Create Response File

Hi,

Actaully i want to install SQL SERVER 2005 Enterprise edition in the silent mode and I was tyring to create a response file (setup.iss), but from the document provided i saw that SQL SERVER 2005 Enterprise edition doesnt create response file, and doesnt support setup.iss. So please provide me some solution where i can generate response file or some thing which is similar to that.

SQL 2005 now supports a ton of switches which will allow you to select all the GUI options from the command line. Check the docs on the DVD for all the options. Stick the finished command line in a batch file and use your favorite remote install tool to launch the batch file.|||

Here's the link in BOL for silent installs with a ton of examples:

http://msdn2.microsoft.com/en-us/library/ms144259.aspx

Thanks,
Sam Lester (MSFT)