Remove Drill Down on Group

Hi,
When first creating my report, I used the wizard to set up drill down on my
first group. I know want to remove that so that all the groups are expanded
by default. How can I change the group to remove the drill down?
Second...
I have the following in my report
Group 1
Group 2-1
Group 2-2
Group 2-3
Footer Group 1
How can I use the sub-totals in Group 2-1, 2-2, 2-3 in a formula in the
footer of Group1? Hope that made sense...
Thanks in advance.#1: Go to the properties of report band that is being
shown or hidden (most likely the detail band of the
report). Expand the Visibility property and make sure
Hidden is false and clear ToggleItem.
#2: Try using the scope parameter of the formula. For
example, Sum(Fields!field.Value,"Group 2-1")
-Dave Foderick
Net Knowledge
>--Original Message--
>Hi,
>When first creating my report, I used the wizard to set
up drill down on my
>first group. I know want to remove that so that all the
groups are expanded
>by default. How can I change the group to remove the
drill down?
>Second...
>I have the following in my report
>Group 1
> Group 2-1
> Group 2-2
> Group 2-3
>Footer Group 1
>How can I use the sub-totals in Group 2-1, 2-2, 2-3 in a
formula in the
>footer of Group1? Hope that made sense...
>Thanks in advance.
>
>.
>

Remote SQl connection

I have a SQL server that was formatted and reconfigured. Prior to the
format, I was able to access this server from remote locations by creating a
n
ODBC connection in Administrative Tools in Windows XP. I haven't changed my
firewall or the server IP. As far as I can see, everything should be the
same. The problem now is that I can't create an ODBC connection unless I'm
on my network and a member of the domain. Even if I'm with my network, but
not a member of the domain, I can't create the ODBC connection.
The server is set up using mixed-mode authentication and as I mentioned, I
can create this connection if I'm on the domain. Any suggestions as to why
I
can't do this remotely? Thanks in advance for your help.Hi
Can you see the server (using ping?). Which protocols do you have enabled?
Is the SQL Server on the domain? Have you re-created the users, logins and
trusts to be exactly the same? What error message do you get?
John
"J.B.C" <JBC@.discussions.microsoft.com> wrote in message
news:F9887DA2-34B9-42F2-A903-CBF04CE9DDD7@.microsoft.com...
>I have a SQL server that was formatted and reconfigured. Prior to the
> format, I was able to access this server from remote locations by creating
> an
> ODBC connection in Administrative Tools in Windows XP. I haven't changed
> my
> firewall or the server IP. As far as I can see, everything should be
> the
> same. The problem now is that I can't create an ODBC connection unless
> I'm
> on my network and a member of the domain. Even if I'm with my network,
> but
> not a member of the domain, I can't create the ODBC connection.
> The server is set up using mixed-mode authentication and as I mentioned, I
> can create this connection if I'm on the domain. Any suggestions as to
> why I
> can't do this remotely? Thanks in advance for your help.

Remote SQl connection

I have a SQL server that was formatted and reconfigured. Prior to the
format, I was able to access this server from remote locations by creating an
ODBC connection in Administrative Tools in Windows XP. I haven't changed my
firewall or the server IP. As far as I can see, everything should be the
same. The problem now is that I can't create an ODBC connection unless I'm
on my network and a member of the domain. Even if I'm with my network, but
not a member of the domain, I can't create the ODBC connection.
The server is set up using mixed-mode authentication and as I mentioned, I
can create this connection if I'm on the domain. Any suggestions as to why I
can't do this remotely? Thanks in advance for your help.Hi
Can you see the server (using ping?). Which protocols do you have enabled?
Is the SQL Server on the domain? Have you re-created the users, logins and
trusts to be exactly the same? What error message do you get?
John
"J.B.C" <JBC@.discussions.microsoft.com> wrote in message
news:F9887DA2-34B9-42F2-A903-CBF04CE9DDD7@.microsoft.com...
>I have a SQL server that was formatted and reconfigured. Prior to the
> format, I was able to access this server from remote locations by creating
> an
> ODBC connection in Administrative Tools in Windows XP. I haven't changed
> my
> firewall or the server IP. As far as I can see, everything should be
> the
> same. The problem now is that I can't create an ODBC connection unless
> I'm
> on my network and a member of the domain. Even if I'm with my network,
> but
> not a member of the domain, I can't create the ODBC connection.
> The server is set up using mixed-mode authentication and as I mentioned, I
> can create this connection if I'm on the domain. Any suggestions as to
> why I
> can't do this remotely? Thanks in advance for your help.

Remote SQl connection

I have a SQL server that was formatted and reconfigured. Prior to the
format, I was able to access this server from remote locations by creating an
ODBC connection in Administrative Tools in Windows XP. I haven't changed my
firewall or the server IP. As far as I can see, everything should be the
same. The problem now is that I can't create an ODBC connection unless I'm
on my network and a member of the domain. Even if I'm with my network, but
not a member of the domain, I can't create the ODBC connection.
The server is set up using mixed-mode authentication and as I mentioned, I
can create this connection if I'm on the domain. Any suggestions as to why I
can't do this remotely? Thanks in advance for your help.
Hi
Can you see the server (using ping?). Which protocols do you have enabled?
Is the SQL Server on the domain? Have you re-created the users, logins and
trusts to be exactly the same? What error message do you get?
John
"J.B.C" <JBC@.discussions.microsoft.com> wrote in message
news:F9887DA2-34B9-42F2-A903-CBF04CE9DDD7@.microsoft.com...
>I have a SQL server that was formatted and reconfigured. Prior to the
> format, I was able to access this server from remote locations by creating
> an
> ODBC connection in Administrative Tools in Windows XP. I haven't changed
> my
> firewall or the server IP. As far as I can see, everything should be
> the
> same. The problem now is that I can't create an ODBC connection unless
> I'm
> on my network and a member of the domain. Even if I'm with my network,
> but
> not a member of the domain, I can't create the ODBC connection.
> The server is set up using mixed-mode authentication and as I mentioned, I
> can create this connection if I'm on the domain. Any suggestions as to
> why I
> can't do this remotely? Thanks in advance for your help.

Remote connection refused when creating ODBC connection to SQL Server 2005

When I create a new odbc connection to a SQL server 2005 Db I get a failure telling me dat de SQL server does not allow remote connections.

How can I allow the server to allow this.

Any help appreciated

regards

I would recommend looking at the following post, hopefully it already contains the answer to your issue:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=297514&SiteID=1

If the information here is not enough to fix your problem, let us know, we will be glad to help.

Thanks,

-Raul Garcia

SDE/T

SQL Server Engine