MS Acces to SQL issues

Hello all - We have several small Access dBs that we want to move up to MS
SQL. We've had some success with the upsizing wizard but have issues. The
most pressing issue is that we can't add new records the the newly upsized
SQL dB. Its like the table or form becomes read-only. I understand that
manual data conversion is best but in the spirit of time, the upsizing wizard
sure is nice and our Access apps are very simple. Any thoughts or
suggestions? Thanks in advance.
Rob C, MCSE, CCA
Statesville, NC
Ensure you have primary keys defined on all tables you want to update.
"Rob C" <RobC@.discussions.microsoft.com> wrote in message
news:F4D0AF9E-5926-48FB-BFB4-C83345AA059F@.microsoft.com...
> Hello all - We have several small Access dBs that we want to move up to MS
> SQL. We've had some success with the upsizing wizard but have issues.
The
> most pressing issue is that we can't add new records the the newly upsized
> SQL dB. Its like the table or form becomes read-only. I understand that
> manual data conversion is best but in the spirit of time, the upsizing
wizard
> sure is nice and our Access apps are very simple. Any thoughts or
> suggestions? Thanks in advance.
> --
> Rob C, MCSE, CCA
> Statesville, NC
|||Define "can't". Do you get an error message?
Jeff
"Rob C" <RobC@.discussions.microsoft.com> wrote in message
news:F4D0AF9E-5926-48FB-BFB4-C83345AA059F@.microsoft.com...
> Hello all - We have several small Access dBs that we want to move up to MS
> SQL. We've had some success with the upsizing wizard but have issues.
The
> most pressing issue is that we can't add new records the the newly upsized
> SQL dB. Its like the table or form becomes read-only. I understand that
> manual data conversion is best but in the spirit of time, the upsizing
wizard
> sure is nice and our Access apps are very simple. Any thoughts or
> suggestions? Thanks in advance.
> --
> Rob C, MCSE, CCA
> Statesville, NC
|||I'm with Jeff. What do you mean "can't?" The upsizing wizard would not do
this sort of thing. Sounds more like a resource issue.
The main problem I have with the wizard is that it chooses nasty data types
that I wouldn't have if I'd done it manually. This and the transfer of
indexes, pks, and fk relationships is handled poorly by the Wizard.
Sincerely,
Anthony Thomas
"Rob C" wrote:

> Hello all - We have several small Access dBs that we want to move up to MS
> SQL. We've had some success with the upsizing wizard but have issues. The
> most pressing issue is that we can't add new records the the newly upsized
> SQL dB. Its like the table or form becomes read-only. I understand that
> manual data conversion is best but in the spirit of time, the upsizing wizard
> sure is nice and our Access apps are very simple. Any thoughts or
> suggestions? Thanks in advance.
> --
> Rob C, MCSE, CCA
> Statesville, NC

MS Acces to SQL issues

Hello all - We have several small Access dBs that we want to move up to MS
SQL. We've had some success with the upsizing wizard but have issues. The
most pressing issue is that we can't add new records the the newly upsized
SQL dB. Its like the table or form becomes read-only. I understand that
manual data conversion is best but in the spirit of time, the upsizing wizard
sure is nice and our Access apps are very simple. Any thoughts or
suggestions? Thanks in advance.
--
Rob C, MCSE, CCA
Statesville, NCEnsure you have primary keys defined on all tables you want to update.
"Rob C" <RobC@.discussions.microsoft.com> wrote in message
news:F4D0AF9E-5926-48FB-BFB4-C83345AA059F@.microsoft.com...
> Hello all - We have several small Access dBs that we want to move up to MS
> SQL. We've had some success with the upsizing wizard but have issues.
The
> most pressing issue is that we can't add new records the the newly upsized
> SQL dB. Its like the table or form becomes read-only. I understand that
> manual data conversion is best but in the spirit of time, the upsizing
wizard
> sure is nice and our Access apps are very simple. Any thoughts or
> suggestions? Thanks in advance.
> --
> Rob C, MCSE, CCA
> Statesville, NC|||Define "can't". Do you get an error message?
Jeff
"Rob C" <RobC@.discussions.microsoft.com> wrote in message
news:F4D0AF9E-5926-48FB-BFB4-C83345AA059F@.microsoft.com...
> Hello all - We have several small Access dBs that we want to move up to MS
> SQL. We've had some success with the upsizing wizard but have issues.
The
> most pressing issue is that we can't add new records the the newly upsized
> SQL dB. Its like the table or form becomes read-only. I understand that
> manual data conversion is best but in the spirit of time, the upsizing
wizard
> sure is nice and our Access apps are very simple. Any thoughts or
> suggestions? Thanks in advance.
> --
> Rob C, MCSE, CCA
> Statesville, NC|||I'm with Jeff. What do you mean "can't?" The upsizing wizard would not do
this sort of thing. Sounds more like a resource issue.
The main problem I have with the wizard is that it chooses nasty data types
that I wouldn't have if I'd done it manually. This and the transfer of
indexes, pks, and fk relationships is handled poorly by the Wizard.
Sincerely,
Anthony Thomas
"Rob C" wrote:
> Hello all - We have several small Access dBs that we want to move up to MS
> SQL. We've had some success with the upsizing wizard but have issues. The
> most pressing issue is that we can't add new records the the newly upsized
> SQL dB. Its like the table or form becomes read-only. I understand that
> manual data conversion is best but in the spirit of time, the upsizing wizard
> sure is nice and our Access apps are very simple. Any thoughts or
> suggestions? Thanks in advance.
> --
> Rob C, MCSE, CCA
> Statesville, NC

MS Acces to SQL issues

Hello all - We have several small Access dBs that we want to move up to MS
SQL. We've had some success with the upsizing wizard but have issues. The
most pressing issue is that we can't add new records the the newly upsized
SQL dB. Its like the table or form becomes read-only. I understand that
manual data conversion is best but in the spirit of time, the upsizing wizar
d
sure is nice and our Access apps are very simple. Any thoughts or
suggestions? Thanks in advance.
--
Rob C, MCSE, CCA
Statesville, NCEnsure you have primary keys defined on all tables you want to update.
"Rob C" <RobC@.discussions.microsoft.com> wrote in message
news:F4D0AF9E-5926-48FB-BFB4-C83345AA059F@.microsoft.com...
> Hello all - We have several small Access dBs that we want to move up to MS
> SQL. We've had some success with the upsizing wizard but have issues.
The
> most pressing issue is that we can't add new records the the newly upsized
> SQL dB. Its like the table or form becomes read-only. I understand that
> manual data conversion is best but in the spirit of time, the upsizing
wizard
> sure is nice and our Access apps are very simple. Any thoughts or
> suggestions? Thanks in advance.
> --
> Rob C, MCSE, CCA
> Statesville, NC|||Define "can't". Do you get an error message?
Jeff
"Rob C" <RobC@.discussions.microsoft.com> wrote in message
news:F4D0AF9E-5926-48FB-BFB4-C83345AA059F@.microsoft.com...
> Hello all - We have several small Access dBs that we want to move up to MS
> SQL. We've had some success with the upsizing wizard but have issues.
The
> most pressing issue is that we can't add new records the the newly upsized
> SQL dB. Its like the table or form becomes read-only. I understand that
> manual data conversion is best but in the spirit of time, the upsizing
wizard
> sure is nice and our Access apps are very simple. Any thoughts or
> suggestions? Thanks in advance.
> --
> Rob C, MCSE, CCA
> Statesville, NC|||I'm with Jeff. What do you mean "can't?" The upsizing wizard would not do
this sort of thing. Sounds more like a resource issue.
The main problem I have with the wizard is that it chooses nasty data types
that I wouldn't have if I'd done it manually. This and the transfer of
indexes, pks, and fk relationships is handled poorly by the Wizard.
Sincerely,
Anthony Thomas
"Rob C" wrote:

> Hello all - We have several small Access dBs that we want to move up to MS
> SQL. We've had some success with the upsizing wizard but have issues. Th
e
> most pressing issue is that we can't add new records the the newly upsized
> SQL dB. Its like the table or form becomes read-only. I understand that
> manual data conversion is best but in the spirit of time, the upsizing wiz
ard
> sure is nice and our Access apps are very simple. Any thoughts or
> suggestions? Thanks in advance.
> --
> Rob C, MCSE, CCA
> Statesville, NC

Ms 2767withh DBCC show_statistics

Hello
One of my database is quite slow. The first action i did is check
statistics, using dbccshow_statistics.
But it seems statistics are not available (SQL server returns a 2767 msg,
saying it cannot find statistics)
Thus i used update statistics on one of the table. Query analysers says the
comand is complete. But reusing dbcc update statistics shows the same error
message (2767)
The server version is
Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation Enterprise Edition on Windows
NT 5.2 (Build 3790: )
Is there any explanation ? Any ways to solve the problem ?
Thank you
XavierCan you show us:
result from
EXEC sp_helpindex 'tablename'
Your UPDATE STATISTICS command
Your DBCC SHOWSTATISTICS command
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"PetitGosaimass" <PetitGosaimass@.discussions.microsoft.com> wrote in message
news:F82C47D3-42EF-421A-A5A3-979CA887FFCD@.microsoft.com...
> Hello
> One of my database is quite slow. The first action i did is check
> statistics, using dbccshow_statistics.
> But it seems statistics are not available (SQL server returns a 2767 msg,
> saying it cannot find statistics)
> Thus i used update statistics on one of the table. Query analysers says th
e
> comand is complete. But reusing dbcc update statistics shows the same erro
r
> message (2767)
> The server version is
> Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
> Copyright (c) 1988-2000 Microsoft Corporation Enterprise Edition on Windo
ws
> NT 5.2 (Build 3790: )
> Is there any explanation ? Any ways to solve the problem ?
> Thank you
> Xavier
>
>|||Thank you tibor for your quick answer.
I noticed yesterday, after sending my message, that the owner of the job
maintaining the databse was unkown in the security folder of EM. I switched
to 'sa' instead of this user (that was a Nt local account).
I let the job work last night, and now i have statistics on my table.
I suppose the owner of the job had insufficient rights in the first place,
but i cannot explain why using the sa account on a query analyser yesterday,
stats wouldn't be updated.
Here are the commande i used :
as you will see, the index on this table are, hm, usiong too much columns i
think (especially reagrding density of some columns). Any advice welcome by
the way :=) .
That is why i was using the dbcc show_statistics
exec sp_helpindex 'ValeursCAR'
IX_ValeursCAR nonclustered, unique located on PRIMARY Val_Montant, Val_Zon2,
Val_Zon3, Val_Zon4, Val_RefCheque
IX_ValeursCAR_1 nonclustered located on PRIMARY Val_FlagReconc, Val_Zon8,
Val_Dt_Reception, Val_Dt_Vente, Val_Rmt_Numero
IX_ValeursCAR_10 nonclustered located on PRIMARY Val_Lot_Nulot, Val_Dt_Trt,
Val_FlagReconc
IX_ValeursCar_11 nonclustered located on PRIMARY Val_Dt_Trt
IX_ValeursCAR_2 nonclustered located on PRIMARY Val_FlagReconc,
Val_Dt_Vente, Val_Rmt_Numero
IX_ValeursCAR_3 nonclustered located on PRIMARY Val_FlagReconc, Val_Zon8,
Val_Dt_Reception, Val_Hotesse, Val_Dt_VenteLot, Val_Rmt_Numero
IX_ValeursCAR_4 nonclustered located on PRIMARY Val_FlagReconc, Val_Hotesse,
Val_Dt_Vente, Val_Rmt_Numero
IX_ValeursCAR_5 nonclustered located on PRIMARY Val_FlagReconc,
Val_Dt_Reception, Val_Hotesse, Val_Dt_VenteLot, Val_Rmt_Numero
IX_ValeursCAR_6 nonclustered located on PRIMARY Val_FlagReconc, Val_Zon8,
Val_Dt_Reception, Val_Dt_VenteLot, Val_Rmt_Numero
IX_ValeursCAR_7 nonclustered located on PRIMARY Val_Dt_Reception,
Val_Dt_Vente, Val_Rmt_Numero, Val_Hotesse, Val_Zon8, Val_FlagReconc
IX_ValeursCAR_8 nonclustered located on PRIMARY Val_Dt_Reception,
Val_FlagReconc
IX_ValeursCAR_9 nonclustered located on PRIMARY Val_Lot_Nulot, Val_Dt_Trt
PK_ValeursCAR clustered, unique, primary key located on PRIMARY Val_Identite
DBCC SHOW_statistics (ValeursCAR,IX_ValeursCAR_2)
Does return now correct values. so i cannot send the error message ...sorry
its number was 2767
"Tibor Karaszi" wrote:

> Can you show us:
> result from
> EXEC sp_helpindex 'tablename'
> Your UPDATE STATISTICS command
> Your DBCC SHOWSTATISTICS command
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "PetitGosaimass" <PetitGosaimass@.discussions.microsoft.com> wrote in messa
ge
> news:F82C47D3-42EF-421A-A5A3-979CA887FFCD@.microsoft.com...
>sql

Ms 2767withh DBCC show_statistics

Hello
One of my database is quite slow. The first action i did is check
statistics, using dbccshow_statistics.
But it seems statistics are not available (SQL server returns a 2767 msg,
saying it cannot find statistics)
Thus i used update statistics on one of the table. Query analysers says the
comand is complete. But reusing dbcc update statistics shows the same error
message (2767)
The server version is
Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation Enterprise Edition on Windows
NT 5.2 (Build 3790: )
Is there any explanation ? Any ways to solve the problem ?
Thank you
Xavier
Can you show us:
result from
EXEC sp_helpindex 'tablename'
Your UPDATE STATISTICS command
Your DBCC SHOWSTATISTICS command
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"PetitGosaimass" <PetitGosaimass@.discussions.microsoft.com> wrote in message
news:F82C47D3-42EF-421A-A5A3-979CA887FFCD@.microsoft.com...
> Hello
> One of my database is quite slow. The first action i did is check
> statistics, using dbccshow_statistics.
> But it seems statistics are not available (SQL server returns a 2767 msg,
> saying it cannot find statistics)
> Thus i used update statistics on one of the table. Query analysers says the
> comand is complete. But reusing dbcc update statistics shows the same error
> message (2767)
> The server version is
> Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
> Copyright (c) 1988-2000 Microsoft Corporation Enterprise Edition on Windows
> NT 5.2 (Build 3790: )
> Is there any explanation ? Any ways to solve the problem ?
> Thank you
> Xavier
>
>
|||Thank you tibor for your quick answer.
I noticed yesterday, after sending my message, that the owner of the job
maintaining the databse was unkown in the security folder of EM. I switched
to 'sa' instead of this user (that was a Nt local account).
I let the job work last night, and now i have statistics on my table.
I suppose the owner of the job had insufficient rights in the first place,
but i cannot explain why using the sa account on a query analyser yesterday,
stats wouldn't be updated.
Here are the commande i used :
as you will see, the index on this table are, hm, usiong too much columns i
think (especially reagrding density of some columns). Any advice welcome by
the way :=) .
That is why i was using the dbcc show_statistics
exec sp_helpindex 'ValeursCAR'
IX_ValeursCARnonclustered, unique located on PRIMARYVal_Montant, Val_Zon2,
Val_Zon3, Val_Zon4, Val_RefCheque
IX_ValeursCAR_1nonclustered located on PRIMARYVal_FlagReconc, Val_Zon8,
Val_Dt_Reception, Val_Dt_Vente, Val_Rmt_Numero
IX_ValeursCAR_10nonclustered located on PRIMARYVal_Lot_Nulot, Val_Dt_Trt,
Val_FlagReconc
IX_ValeursCar_11nonclustered located on PRIMARYVal_Dt_Trt
IX_ValeursCAR_2nonclustered located on PRIMARYVal_FlagReconc,
Val_Dt_Vente, Val_Rmt_Numero
IX_ValeursCAR_3nonclustered located on PRIMARYVal_FlagReconc, Val_Zon8,
Val_Dt_Reception, Val_Hotesse, Val_Dt_VenteLot, Val_Rmt_Numero
IX_ValeursCAR_4nonclustered located on PRIMARYVal_FlagReconc, Val_Hotesse,
Val_Dt_Vente, Val_Rmt_Numero
IX_ValeursCAR_5nonclustered located on PRIMARYVal_FlagReconc,
Val_Dt_Reception, Val_Hotesse, Val_Dt_VenteLot, Val_Rmt_Numero
IX_ValeursCAR_6nonclustered located on PRIMARYVal_FlagReconc, Val_Zon8,
Val_Dt_Reception, Val_Dt_VenteLot, Val_Rmt_Numero
IX_ValeursCAR_7nonclustered located on PRIMARYVal_Dt_Reception,
Val_Dt_Vente, Val_Rmt_Numero, Val_Hotesse, Val_Zon8, Val_FlagReconc
IX_ValeursCAR_8nonclustered located on PRIMARYVal_Dt_Reception,
Val_FlagReconc
IX_ValeursCAR_9nonclustered located on PRIMARYVal_Lot_Nulot, Val_Dt_Trt
PK_ValeursCARclustered, unique, primary key located on PRIMARYVal_Identite
DBCC SHOW_statistics (ValeursCAR,IX_ValeursCAR_2)
Does return now correct values. so i cannot send the error message ...sorry
its number was 2767
"Tibor Karaszi" wrote:

> Can you show us:
> result from
> EXEC sp_helpindex 'tablename'
> Your UPDATE STATISTICS command
> Your DBCC SHOWSTATISTICS command
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "PetitGosaimass" <PetitGosaimass@.discussions.microsoft.com> wrote in message
> news:F82C47D3-42EF-421A-A5A3-979CA887FFCD@.microsoft.com...
>

Ms 2767withh DBCC show_statistics

Hello
One of my database is quite slow. The first action i did is check
statistics, using dbccshow_statistics.
But it seems statistics are not available (SQL server returns a 2767 msg,
saying it cannot find statistics)
Thus i used update statistics on one of the table. Query analysers says the
comand is complete. But reusing dbcc update statistics shows the same error
message (2767)
The server version is
Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation Enterprise Edition on Windows
NT 5.2 (Build 3790: )
Is there any explanation ? Any ways to solve the problem ?
Thank you
XavierCan you show us:
result from
EXEC sp_helpindex 'tablename'
Your UPDATE STATISTICS command
Your DBCC SHOWSTATISTICS command
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"PetitGosaimass" <PetitGosaimass@.discussions.microsoft.com> wrote in message
news:F82C47D3-42EF-421A-A5A3-979CA887FFCD@.microsoft.com...
> Hello
> One of my database is quite slow. The first action i did is check
> statistics, using dbccshow_statistics.
> But it seems statistics are not available (SQL server returns a 2767 msg,
> saying it cannot find statistics)
> Thus i used update statistics on one of the table. Query analysers says the
> comand is complete. But reusing dbcc update statistics shows the same error
> message (2767)
> The server version is
> Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
> Copyright (c) 1988-2000 Microsoft Corporation Enterprise Edition on Windows
> NT 5.2 (Build 3790: )
> Is there any explanation ? Any ways to solve the problem ?
> Thank you
> Xavier
>
>|||Thank you tibor for your quick answer.
I noticed yesterday, after sending my message, that the owner of the job
maintaining the databse was unkown in the security folder of EM. I switched
to 'sa' instead of this user (that was a Nt local account).
I let the job work last night, and now i have statistics on my table.
I suppose the owner of the job had insufficient rights in the first place,
but i cannot explain why using the sa account on a query analyser yesterday,
stats wouldn't be updated.
Here are the commande i used :
as you will see, the index on this table are, hm, usiong too much columns i
think (especially reagrding density of some columns). Any advice welcome by
the way :=) .
That is why i was using the dbcc show_statistics
exec sp_helpindex 'ValeursCAR'
IX_ValeursCAR nonclustered, unique located on PRIMARY Val_Montant, Val_Zon2,
Val_Zon3, Val_Zon4, Val_RefCheque
IX_ValeursCAR_1 nonclustered located on PRIMARY Val_FlagReconc, Val_Zon8,
Val_Dt_Reception, Val_Dt_Vente, Val_Rmt_Numero
IX_ValeursCAR_10 nonclustered located on PRIMARY Val_Lot_Nulot, Val_Dt_Trt,
Val_FlagReconc
IX_ValeursCar_11 nonclustered located on PRIMARY Val_Dt_Trt
IX_ValeursCAR_2 nonclustered located on PRIMARY Val_FlagReconc,
Val_Dt_Vente, Val_Rmt_Numero
IX_ValeursCAR_3 nonclustered located on PRIMARY Val_FlagReconc, Val_Zon8,
Val_Dt_Reception, Val_Hotesse, Val_Dt_VenteLot, Val_Rmt_Numero
IX_ValeursCAR_4 nonclustered located on PRIMARY Val_FlagReconc, Val_Hotesse,
Val_Dt_Vente, Val_Rmt_Numero
IX_ValeursCAR_5 nonclustered located on PRIMARY Val_FlagReconc,
Val_Dt_Reception, Val_Hotesse, Val_Dt_VenteLot, Val_Rmt_Numero
IX_ValeursCAR_6 nonclustered located on PRIMARY Val_FlagReconc, Val_Zon8,
Val_Dt_Reception, Val_Dt_VenteLot, Val_Rmt_Numero
IX_ValeursCAR_7 nonclustered located on PRIMARY Val_Dt_Reception,
Val_Dt_Vente, Val_Rmt_Numero, Val_Hotesse, Val_Zon8, Val_FlagReconc
IX_ValeursCAR_8 nonclustered located on PRIMARY Val_Dt_Reception,
Val_FlagReconc
IX_ValeursCAR_9 nonclustered located on PRIMARY Val_Lot_Nulot, Val_Dt_Trt
PK_ValeursCAR clustered, unique, primary key located on PRIMARY Val_Identite
DBCC SHOW_statistics (ValeursCAR,IX_ValeursCAR_2)
Does return now correct values. so i cannot send the error message ...sorry
its number was 2767
"Tibor Karaszi" wrote:
> Can you show us:
> result from
> EXEC sp_helpindex 'tablename'
> Your UPDATE STATISTICS command
> Your DBCC SHOWSTATISTICS command
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "PetitGosaimass" <PetitGosaimass@.discussions.microsoft.com> wrote in message
> news:F82C47D3-42EF-421A-A5A3-979CA887FFCD@.microsoft.com...
> > Hello
> >
> > One of my database is quite slow. The first action i did is check
> > statistics, using dbccshow_statistics.
> >
> > But it seems statistics are not available (SQL server returns a 2767 msg,
> > saying it cannot find statistics)
> > Thus i used update statistics on one of the table. Query analysers says the
> > comand is complete. But reusing dbcc update statistics shows the same error
> > message (2767)
> >
> > The server version is
> > Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
> > Copyright (c) 1988-2000 Microsoft Corporation Enterprise Edition on Windows
> > NT 5.2 (Build 3790: )
> >
> > Is there any explanation ? Any ways to solve the problem ?
> >
> > Thank you
> >
> > Xavier
> >
> >
> >
> >
>

MS 2005 Reporting Services Matrix - % Change Issue ....Help!

Hello Everyone,

I have been tasked with creating a report using Reporting Services from an excel report that was wasting a lot of manual effort and time. I have searched boards and I am having the hardest time trying to find a way to do the following in Reporting Services within a Matrix:

Spring Summer Fall

2005 2006 2007 %Change 2005 2006 2007 % Change 2005 2006 2007 %Change

Reponses 219 310 410 100 100 200 300 100 2000 3000 200 -2800

FRC% 102% 103% 200% 97% 23% 25% 10% -15% 20% 32% 10% -22%

===========================================================================================

I can not find out how to do a percent change (the column in red) subtracting just the final or most right two columns of the resulting matrix columns, not an average or some other function over the entire row....

Please help, I know others have had the same issue...

Thank You,

I would think you would just need to incorporate this into your select statement. Select the difference between the two most recent years as percentChange. Then in your report, add a column with the percentChange field as the data value.|||Thank You for your reply...I will try that and post back...|||

Yep that was the answer...

Thanks...