Dynamic columns of matrix

I have a matrix, I would like to have a subtotal and total that only
performs the action if the dynamic collumn has a particular value.
I have dynamic column A and B. I only want the subtotal for A not B.
BruceOn Mar 6, 12:31 pm, "Bruce L-C [MVP]" <bruc...@.newsgroup.nospam>
wrote:
> I have a matrix, I would like to have a subtotal and total that only
> performs the action if the dynamic collumn has a particular value.
> I have dynamic column A and B. I only want the subtotal for A not B.
> Bruce
I would suggest using a loop or cursor in the stored procedure or
report query sourcing the report to determine the subtotals and total.
Then in the report use a conditional expression to check for a
particular column value and if it is not the one that needs the
subtotal and total, substitute an empty value for the subtotal and
total. Hope this is helpful.
Regards,
Enrique Martinez
Sr. SQL Server Developer

dynamic action in sql server

Hi
I was wondering if someone could help me here. With the use of some action
whether it be SQL DMO or a command propt i need to be able to disable TCP/IP
in SQL Server Network Utility
I know you can call up SQL Server Network Utility with the use of
svrnetcn,is there anyway you can disable the TCP/IP
Thanks
Aido123
Hi
Network settings for SQL Server are stored in the registry. You can modify
it there. For any changes to take effect, SQL Server needs to be restarted.
Regards
Mike
"aido123" wrote:

> Hi
> I was wondering if someone could help me here. With the use of some action
> whether it be SQL DMO or a command propt i need to be able to disable TCP/IP
> in SQL Server Network Utility
> I know you can call up SQL Server Network Utility with the use of
> svrnetcn,is there anyway you can disable the TCP/IP
> Thanks
> Aido123

dynamic action in sql server

Hi
I was wondering if someone could help me here. With the use of some action
whether it be SQL DMO or a command propt i need to be able to disable TCP/IP
in SQL Server Network Utility
I know you can call up SQL Server Network Utility with the use of
svrnetcn,is there anyway you can disable the TCP/IP
Thanks
Aido123Hi
Network settings for SQL Server are stored in the registry. You can modify
it there. For any changes to take effect, SQL Server needs to be restarted.
Regards
Mike
"aido123" wrote:
> Hi
> I was wondering if someone could help me here. With the use of some action
> whether it be SQL DMO or a command propt i need to be able to disable TCP/IP
> in SQL Server Network Utility
> I know you can call up SQL Server Network Utility with the use of
> svrnetcn,is there anyway you can disable the TCP/IP
> Thanks
> Aido123

dynamic action in sql server

Hi
I was wondering if someone could help me here. With the use of some action
whether it be SQL DMO or a command propt i need to be able to disable TCP/IP
in SQL Server Network Utility
I know you can call up SQL Server Network Utility with the use of
svrnetcn,is there anyway you can disable the TCP/IP
Thanks
Aido123Hi
Network settings for SQL Server are stored in the registry. You can modify
it there. For any changes to take effect, SQL Server needs to be restarted.
Regards
Mike
"aido123" wrote:

> Hi
> I was wondering if someone could help me here. With the use of some action
> whether it be SQL DMO or a command propt i need to be able to disable TCP/
IP
> in SQL Server Network Utility
> I know you can call up SQL Server Network Utility with the use of
> svrnetcn,is there anyway you can disable the TCP/IP
> Thanks
> Aido123