Restrict ing Sum(...) in Report Table Footer?

Hello,
My Report Table contains a Date Field and a numeric Value field. In the
Footer row of the table I use the Sum Aggregate function to sum up all the
values for all the rows that get displayed
=sum(Fields!CountFld.Value)
I also have an conditional Expression for the background color of each cell
in the detail row
=iif(Parameters!EndDate.Value > Fields!
CurExpireDate.Value, "Gainsboro", "White")
which changes the background color of each cell in the row (I add this IIF
expression to each field in the row).
So, if a value is in a row that is the gainsboro color, I do not want to sum
that value. Is there a way to restrict sum(Fields!CountFld.Value) ?
PseudoCode
=Sum(iif(Parameters!EndDate.Value > Fields!
CurExpireDate.Value, Fields!CountFld.Value, 0))
something like this?
Thanks,
RichWell, I tried my own pseudocode and it worked!
=Sum(iif(Parameters!EndDate.Value > Fields!
> CurExpireDate.Value, 0, Fields!CountFld.Value))
I just had to change the values around
"Rich" wrote:
> Hello,
> My Report Table contains a Date Field and a numeric Value field. In the
> Footer row of the table I use the Sum Aggregate function to sum up all the
> values for all the rows that get displayed
> =sum(Fields!CountFld.Value)
> I also have an conditional Expression for the background color of each cell
> in the detail row
> =iif(Parameters!EndDate.Value > Fields!
> CurExpireDate.Value, "Gainsboro", "White")
> which changes the background color of each cell in the row (I add this IIF
> expression to each field in the row).
> So, if a value is in a row that is the gainsboro color, I do not want to sum
> that value. Is there a way to restrict sum(Fields!CountFld.Value) ?
> PseudoCode
> =Sum(iif(Parameters!EndDate.Value > Fields!
> CurExpireDate.Value, Fields!CountFld.Value, 0))
> something like this?
> Thanks,
> Rich
>|||I used the same method, but have run into 1 problem. If the table or group
spans multiple pages, the sum fails (I get #Error). Not sure if you'll
encounter this, but I thought I would make you aware of my issue using that
method.
Michael
"Rich" wrote:
> Well, I tried my own pseudocode and it worked!
> =Sum(iif(Parameters!EndDate.Value > Fields!
> > CurExpireDate.Value, 0, Fields!CountFld.Value))
> I just had to change the values around
>
> "Rich" wrote:
> > Hello,
> >
> > My Report Table contains a Date Field and a numeric Value field. In the
> > Footer row of the table I use the Sum Aggregate function to sum up all the
> > values for all the rows that get displayed
> >
> > =sum(Fields!CountFld.Value)
> >
> > I also have an conditional Expression for the background color of each cell
> > in the detail row
> >
> > =iif(Parameters!EndDate.Value > Fields!
> > CurExpireDate.Value, "Gainsboro", "White")
> >
> > which changes the background color of each cell in the row (I add this IIF
> > expression to each field in the row).
> >
> > So, if a value is in a row that is the gainsboro color, I do not want to sum
> > that value. Is there a way to restrict sum(Fields!CountFld.Value) ?
> >
> > PseudoCode
> > =Sum(iif(Parameters!EndDate.Value > Fields!
> > CurExpireDate.Value, Fields!CountFld.Value, 0))
> >
> > something like this?
> >
> > Thanks,
> > Rich
> >|||Thanks. Not the kind of surprises I am looking forward to. Hopefully, I
won't run into that problem, but if I do, I will now know that I am not
alone. This is actually quite encouraging because I have had some seroius
heartaches with RS (2000).
"Michael C" wrote:
> I used the same method, but have run into 1 problem. If the table or group
> spans multiple pages, the sum fails (I get #Error). Not sure if you'll
> encounter this, but I thought I would make you aware of my issue using that
> method.
> Michael
> "Rich" wrote:
> > Well, I tried my own pseudocode and it worked!
> >
> > =Sum(iif(Parameters!EndDate.Value > Fields!
> > > CurExpireDate.Value, 0, Fields!CountFld.Value))
> >
> > I just had to change the values around
> >
> >
> >
> > "Rich" wrote:
> >
> > > Hello,
> > >
> > > My Report Table contains a Date Field and a numeric Value field. In the
> > > Footer row of the table I use the Sum Aggregate function to sum up all the
> > > values for all the rows that get displayed
> > >
> > > =sum(Fields!CountFld.Value)
> > >
> > > I also have an conditional Expression for the background color of each cell
> > > in the detail row
> > >
> > > =iif(Parameters!EndDate.Value > Fields!
> > > CurExpireDate.Value, "Gainsboro", "White")
> > >
> > > which changes the background color of each cell in the row (I add this IIF
> > > expression to each field in the row).
> > >
> > > So, if a value is in a row that is the gainsboro color, I do not want to sum
> > > that value. Is there a way to restrict sum(Fields!CountFld.Value) ?
> > >
> > > PseudoCode
> > > =Sum(iif(Parameters!EndDate.Value > Fields!
> > > CurExpireDate.Value, Fields!CountFld.Value, 0))
> > >
> > > something like this?
> > >
> > > Thanks,
> > > Rich
> > >sql

Restoring MSDE databases to SQL Server 2000

Hi,
We have a MSDE 2000 installed on a Blackberry server that contains
Blackberry configuration data. For testing the Net backups we need to restore
it to a SQL Server 2000 server. The SQL Server 2000 is already installed and
has couple of test databases that I will drop before doing the restore for
the system and the user databases from the Net backups of the MSDE 2000
databases.
I am planning on restoring master first, then msdb, then model and then the
user databases. For restoring master I'll just restore the master from the
Net backup so that it replaces the current master and then I will just repeat
the process with other system databases. Is this the right way to proceed or
am I missing something? Any advise will be greatly appreciated. Thanks.If you don't have the same path, then you will get into some problems. Also make sure you have the
same build number of the SQL Server engines. And, finally, read KB 224071
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:5DDC3553-2145-4212-9EBE-69EAF201633A@.microsoft.com...
> Hi,
> We have a MSDE 2000 installed on a Blackberry server that contains
> Blackberry configuration data. For testing the Net backups we need to restore
> it to a SQL Server 2000 server. The SQL Server 2000 is already installed and
> has couple of test databases that I will drop before doing the restore for
> the system and the user databases from the Net backups of the MSDE 2000
> databases.
> I am planning on restoring master first, then msdb, then model and then the
> user databases. For restoring master I'll just restore the master from the
> Net backup so that it replaces the current master and then I will just repeat
> the process with other system databases. Is this the right way to proceed or
> am I missing something? Any advise will be greatly appreciated. Thanks.|||Thanks a lot. I did check the paths and found that the paths were different.
So I created the same path on the target server. I found this on the SQL
Server properties 8.00.760 (SP3) on both the SQL Servers. Is this what you
are referring to as the build numbers?
The article that you have mentioned KB 224071 diccusses moving databases by
detaching and attaching, while I want to restore using the files from the
VERITAS Net Backup to test it. Any insight would be appreciated.
"Tibor Karaszi" wrote:
> If you don't have the same path, then you will get into some problems. Also make sure you have the
> same build number of the SQL Server engines. And, finally, read KB 224071
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "sharman" <sharman@.discussions.microsoft.com> wrote in message
> news:5DDC3553-2145-4212-9EBE-69EAF201633A@.microsoft.com...
> > Hi,
> >
> > We have a MSDE 2000 installed on a Blackberry server that contains
> > Blackberry configuration data. For testing the Net backups we need to restore
> > it to a SQL Server 2000 server. The SQL Server 2000 is already installed and
> > has couple of test databases that I will drop before doing the restore for
> > the system and the user databases from the Net backups of the MSDE 2000
> > databases.
> >
> > I am planning on restoring master first, then msdb, then model and then the
> > user databases. For restoring master I'll just restore the master from the
> > Net backup so that it replaces the current master and then I will just repeat
> > the process with other system databases. Is this the right way to proceed or
> > am I missing something? Any advise will be greatly appreciated. Thanks.
>
>|||> I found this on the SQL
> Server properties 8.00.760 (SP3) on both the SQL Servers. Is this what you
> are referring to as the build numbers?
Yes.
> while I want to restore using the files from the
> VERITAS Net Backup to test it. Any insight would be appreciated.
Which, I believe, lead you in to unsupported territory. Anyhow, check out
http://vyaskn.tripod.com/moving_sql_server.htm
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:20CAF583-3917-4396-89E3-ED54C7BD3087@.microsoft.com...
> Thanks a lot. I did check the paths and found that the paths were different.
> So I created the same path on the target server. I found this on the SQL
> Server properties 8.00.760 (SP3) on both the SQL Servers. Is this what you
> are referring to as the build numbers?
> The article that you have mentioned KB 224071 diccusses moving databases by
> detaching and attaching, while I want to restore using the files from the
> VERITAS Net Backup to test it. Any insight would be appreciated.
> "Tibor Karaszi" wrote:
>> If you don't have the same path, then you will get into some problems. Also make sure you have
>> the
>> same build number of the SQL Server engines. And, finally, read KB 224071
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "sharman" <sharman@.discussions.microsoft.com> wrote in message
>> news:5DDC3553-2145-4212-9EBE-69EAF201633A@.microsoft.com...
>> > Hi,
>> >
>> > We have a MSDE 2000 installed on a Blackberry server that contains
>> > Blackberry configuration data. For testing the Net backups we need to restore
>> > it to a SQL Server 2000 server. The SQL Server 2000 is already installed and
>> > has couple of test databases that I will drop before doing the restore for
>> > the system and the user databases from the Net backups of the MSDE 2000
>> > databases.
>> >
>> > I am planning on restoring master first, then msdb, then model and then the
>> > user databases. For restoring master I'll just restore the master from the
>> > Net backup so that it replaces the current master and then I will just repeat
>> > the process with other system databases. Is this the right way to proceed or
>> > am I missing something? Any advise will be greatly appreciated. Thanks.
>>