keywords context summary

I use fts to query a sql server 2005 db and the results are displayed
on a web page.
Out of a large text how can a summary be extracted "including" also my
keywords? Like more contextual summary.
google has a fancy way of formating the search results and display a
keyword contextual description for every link in their search
any idea?
thxke
This is difficult. For text and image data you really don't have a good way
other than incorporating indexing services and generating hyperlinks to
seeing the data.
Here is an example of how to do this:
http://www.indexserverfaq.com/SQLhitHighlighting.htm
For small char (typically under 200 bytes) use charindex or patindex. For
larger amounts of data it is more efficient to mark it up client side.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"xke" <xkeops@.gmail.com> wrote in message
news:1170996261.834692.202170@.h3g2000cwc.googlegro ups.com...
>I use fts to query a sql server 2005 db and the results are displayed
> on a web page.
> Out of a large text how can a summary be extracted "including" also my
> keywords? Like more contextual summary.
> google has a fancy way of formating the search results and display a
> keyword contextual description for every link in their search
> any idea?
> thxke
>

Keyset does not exist

I get this error when trying to deploy a report from VS2005, when trying to get to the report manager page, when trying to do anything in SSMS with the report server.

Keyset does not exist (Exception from HRESULT: 0x80090016) (rsRPCError) (Microsoft.ReportingServices.Diagnostics)

Can anyone give me a clue what to do?

Hi GraemeH.

Have you had any luck resolving this?

I am getting the same error while attempting to deploy a report from VS 2005. Report Manager is running. The Report project folders deployed from VS fine, just not the report.

I am running XP Pro SP2.

Thanks.

|||

Hi Folks - I'm hitting the same brick wall. Did you manage to find a resolution? I would be very interested in your solution.

Thanks!

|||I did but can't remember how - I think it was a security problem and RS was running under a wrong account, or I had a renegade version of SQL Express. Sorry can't do better than that!|||I had the same problem so changed my Windows Service Identity to Network Service. I know this is a security issue but at least now I can work back from here to create an account that has just the permissions it needs... later, when I have some time.|||but, I can't create encryption key backup ... how about that?

Keyset does not exist

I get this error when trying to deploy a report from VS2005, when trying to get to the report manager page, when trying to do anything in SSMS with the report server.

Keyset does not exist (Exception from HRESULT: 0x80090016) (rsRPCError) (Microsoft.ReportingServices.Diagnostics)

Can anyone give me a clue what to do?

Hi GraemeH.

Have you had any luck resolving this?

I am getting the same error while attempting to deploy a report from VS 2005. Report Manager is running. The Report project folders deployed from VS fine, just not the report.

I am running XP Pro SP2.

Thanks.

|||

Hi Folks - I'm hitting the same brick wall. Did you manage to find a resolution? I would be very interested in your solution.

Thanks!

|||I did but can't remember how - I think it was a security problem and RS was running under a wrong account, or I had a renegade version of SQL Express. Sorry can't do better than that!|||I had the same problem so changed my Windows Service Identity to Network Service. I know this is a security issue but at least now I can work back from here to create an account that has just the permissions it needs... later, when I have some time.|||but, I can't create encryption key backup ... how about that?

Keyset does not exist

I get this error when trying to deploy a report from VS2005, when trying to get to the report manager page, when trying to do anything in SSMS with the report server.

Keyset does not exist (Exception from HRESULT: 0x80090016) (rsRPCError) (Microsoft.ReportingServices.Diagnostics)

Can anyone give me a clue what to do?

Hi GraemeH.

Have you had any luck resolving this?

I am getting the same error while attempting to deploy a report from VS 2005. Report Manager is running. The Report project folders deployed from VS fine, just not the report.

I am running XP Pro SP2.

Thanks.

|||

Hi Folks - I'm hitting the same brick wall. Did you manage to find a resolution? I would be very interested in your solution.

Thanks!

|||I did but can't remember how - I think it was a security problem and RS was running under a wrong account, or I had a renegade version of SQL Express. Sorry can't do better than that!|||I had the same problem so changed my Windows Service Identity to Network Service. I know this is a security issue but at least now I can work back from here to create an account that has just the permissions it needs... later, when I have some time.|||but, I can't create encryption key backup ... how about that?

Keys out of order on page error

We have found we have corruption in our db.
After running DBCC CHECKDB the following error were displayed on
multiple pages.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1285579618, Index ID 3. Keys out of order on page
(1:384662), slots 75 and 76.
I read a post that suggested running DBCC CHECKDB with the repair_build
option.
Since we are a 24/7 shop I cannot restore from tape, because it would
take several hours.
What are the risks of running DBCC CHECKDB with the repair_build option,
and will this fix the problem properly?
We are still unsure what has caused this corruption, any body else have
this problem?
TIA,
-BenThere are a couple of things.
Firstly it is very intensive so turn off as many services
you can get away with, i.e SQL Agent
Secondly depending upon the severity of the error it may
result in data loss. Personally I would try firstly with
REPAIR_FAST, then REPAIR_REBUILD and if all else fails
REPAIR_ALLOW_DATA_LOSS, its that option where you may lose
data.
If the REPAIR_ALLOW_DATA_LOSS doesn't work then you will
have to restore from backup.
As for the reason why to difficult to say.
Good luck
Peter
>--Original Message--
>We have found we have corruption in our db.
>After running DBCC CHECKDB the following error were
displayed on
>multiple pages.
>Server: Msg 2511, Level 16, State 1, Line 1
>Table error: Object ID 1285579618, Index ID 3. Keys out
of order on page
>(1:384662), slots 75 and 76.
>I read a post that suggested running DBCC CHECKDB with
the repair_build
>option.
>Since we are a 24/7 shop I cannot restore from tape,
because it would
>take several hours.
>What are the risks of running DBCC CHECKDB with the
repair_build option,
>and will this fix the problem properly?
>We are still unsure what has caused this corruption, any
body else have
>this problem?
>TIA,
>-Ben
>.
>|||Hi Ben,
As the error is in a non-clustered index, you can just rebuild the index
with DBCC DBREINDEX (<table_name>, <index_name>). Or if you want to be on
the safe side, just drop and recreate the index.
After that, investigate why the corruption occurred in the first place. You
might have hardware problems.
--
Jacco Schalkwijk
SQL Server MVP
"Ben" <bmilliron@.gmail.com> wrote in message
news:OJgEzgufEHA.636@.TK2MSFTNGP12.phx.gbl...
> We have found we have corruption in our db.
> After running DBCC CHECKDB the following error were displayed on multiple
> pages.
> Server: Msg 2511, Level 16, State 1, Line 1
> Table error: Object ID 1285579618, Index ID 3. Keys out of order on page
> (1:384662), slots 75 and 76.
> I read a post that suggested running DBCC CHECKDB with the repair_build
> option.
> Since we are a 24/7 shop I cannot restore from tape, because it would take
> several hours.
> What are the risks of running DBCC CHECKDB with the repair_build option,
> and will this fix the problem properly?
> We are still unsure what has caused this corruption, any body else have
> this problem?
> TIA,
> -Ben|||In addition:
The latest update of Books Online has some very detailed recommendations for most error numbers.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Peter The Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:374a01c47eee$f6a6a890$a501280a@.phx.gbl...
> There are a couple of things.
> Firstly it is very intensive so turn off as many services
> you can get away with, i.e SQL Agent
> Secondly depending upon the severity of the error it may
> result in data loss. Personally I would try firstly with
> REPAIR_FAST, then REPAIR_REBUILD and if all else fails
> REPAIR_ALLOW_DATA_LOSS, its that option where you may lose
> data.
> If the REPAIR_ALLOW_DATA_LOSS doesn't work then you will
> have to restore from backup.
> As for the reason why to difficult to say.
> Good luck
> Peter
>
> >--Original Message--
> >We have found we have corruption in our db.
> >
> >After running DBCC CHECKDB the following error were
> displayed on
> >multiple pages.
> >
> >Server: Msg 2511, Level 16, State 1, Line 1
> >Table error: Object ID 1285579618, Index ID 3. Keys out
> of order on page
> >(1:384662), slots 75 and 76.
> >
> >I read a post that suggested running DBCC CHECKDB with
> the repair_build
> >option.
> >
> >Since we are a 24/7 shop I cannot restore from tape,
> because it would
> >take several hours.
> >
> >What are the risks of running DBCC CHECKDB with the
> repair_build option,
> >and will this fix the problem properly?
> >
> >We are still unsure what has caused this corruption, any
> body else have
> >this problem?
> >
> >TIA,
> >
> >-Ben
> >.
> >|||I have dropped and recreated the index, thanks. I have also opened up
an issue with our vendor to see if this may be a possible cause.
Jacco Schalkwijk wrote:
> Hi Ben,
> As the error is in a non-clustered index, you can just rebuild the index
> with DBCC DBREINDEX (<table_name>, <index_name>). Or if you want to be on
> the safe side, just drop and recreate the index.
> After that, investigate why the corruption occurred in the first place. You
> might have hardware problems.
>

Keys out of order on page error

There are a couple of things.
Firstly it is very intensive so turn off as many services
you can get away with, i.e SQL Agent
Secondly depending upon the severity of the error it may
result in data loss. Personally I would try firstly with
REPAIR_FAST, then REPAIR_REBUILD and if all else fails
REPAIR_ALLOW_DATA_LOSS, its that option where you may lose
data.
If the REPAIR_ALLOW_DATA_LOSS doesn't work then you will
have to restore from backup.
As for the reason why to difficult to say.
Good luck
Peter

>--Original Message--
>We have found we have corruption in our db.
>After running DBCC CHECKDB the following error were
displayed on
>multiple pages.
>Server: Msg 2511, Level 16, State 1, Line 1
>Table error: Object ID 1285579618, Index ID 3. Keys out
of order on page
>(1:384662), slots 75 and 76.
>I read a post that suggested running DBCC CHECKDB with
the repair_build
>option.
>Since we are a 24/7 shop I cannot restore from tape,
because it would
>take several hours.
>What are the risks of running DBCC CHECKDB with the
repair_build option,
>and will this fix the problem properly?
>We are still unsure what has caused this corruption, any
body else have
>this problem?
>TIA,
>-Ben
>.
>
In addition:
The latest update of Books Online has some very detailed recommendations for most error numbers.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Peter The Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:374a01c47eee$f6a6a890$a501280a@.phx.gbl...[vbcol=seagreen]
> There are a couple of things.
> Firstly it is very intensive so turn off as many services
> you can get away with, i.e SQL Agent
> Secondly depending upon the severity of the error it may
> result in data loss. Personally I would try firstly with
> REPAIR_FAST, then REPAIR_REBUILD and if all else fails
> REPAIR_ALLOW_DATA_LOSS, its that option where you may lose
> data.
> If the REPAIR_ALLOW_DATA_LOSS doesn't work then you will
> have to restore from backup.
> As for the reason why to difficult to say.
> Good luck
> Peter
>
> displayed on
> of order on page
> the repair_build
> because it would
> repair_build option,
> body else have

Keys out of order on page error

We have found we have corruption in our db.
After running DBCC CHECKDB the following error were displayed on
multiple pages.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1285579618, Index ID 3. Keys out of order on page
(1:384662), slots 75 and 76.
I read a post that suggested running DBCC CHECKDB with the repair_build
option.
Since we are a 24/7 shop I cannot restore from tape, because it would
take several hours.
What are the risks of running DBCC CHECKDB with the repair_build option,
and will this fix the problem properly?
We are still unsure what has caused this corruption, any body else have
this problem?
TIA,
-Ben
Hi Ben,
As the error is in a non-clustered index, you can just rebuild the index
with DBCC DBREINDEX (<table_name>, <index_name>). Or if you want to be on
the safe side, just drop and recreate the index.
After that, investigate why the corruption occurred in the first place. You
might have hardware problems.
Jacco Schalkwijk
SQL Server MVP
"Ben" <bmilliron@.gmail.com> wrote in message
news:OJgEzgufEHA.636@.TK2MSFTNGP12.phx.gbl...
> We have found we have corruption in our db.
> After running DBCC CHECKDB the following error were displayed on multiple
> pages.
> Server: Msg 2511, Level 16, State 1, Line 1
> Table error: Object ID 1285579618, Index ID 3. Keys out of order on page
> (1:384662), slots 75 and 76.
> I read a post that suggested running DBCC CHECKDB with the repair_build
> option.
> Since we are a 24/7 shop I cannot restore from tape, because it would take
> several hours.
> What are the risks of running DBCC CHECKDB with the repair_build option,
> and will this fix the problem properly?
> We are still unsure what has caused this corruption, any body else have
> this problem?
> TIA,
> -Ben
|||I have dropped and recreated the index, thanks. I have also opened up
an issue with our vendor to see if this may be a possible cause.
Jacco Schalkwijk wrote:
> Hi Ben,
> As the error is in a non-clustered index, you can just rebuild the index
> with DBCC DBREINDEX (<table_name>, <index_name>). Or if you want to be on
> the safe side, just drop and recreate the index.
> After that, investigate why the corruption occurred in the first place. You
> might have hardware problems.
>

Keys out of order on page error

There are a couple of things.
Firstly it is very intensive so turn off as many services
you can get away with, i.e SQL Agent
Secondly depending upon the severity of the error it may
result in data loss. Personally I would try firstly with
REPAIR_FAST, then REPAIR_REBUILD and if all else fails
REPAIR_ALLOW_DATA_LOSS, its that option where you may lose
data.
If the REPAIR_ALLOW_DATA_LOSS doesn't work then you will
have to restore from backup.
As for the reason why to difficult to say.
Good luck
Peter

>--Original Message--
>We have found we have corruption in our db.
>After running DBCC CHECKDB the following error were
displayed on
>multiple pages.
>Server: Msg 2511, Level 16, State 1, Line 1
>Table error: Object ID 1285579618, Index ID 3. Keys out
of order on page
>(1:384662), slots 75 and 76.
>I read a post that suggested running DBCC CHECKDB with
the repair_build
>option.
>Since we are a 24/7 shop I cannot restore from tape,
because it would
>take several hours.
>What are the risks of running DBCC CHECKDB with the
repair_build option,
>and will this fix the problem properly?
>We are still unsure what has caused this corruption, any
body else have
>this problem?
>TIA,
>-Ben
>.
>In addition:
The latest update of Books Online has some very detailed recommendations for
most error numbers.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Peter The Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:374a01c47eee$f6a6a890$a501280a@.phx.gbl...[vbcol=seagreen]
> There are a couple of things.
> Firstly it is very intensive so turn off as many services
> you can get away with, i.e SQL Agent
> Secondly depending upon the severity of the error it may
> result in data loss. Personally I would try firstly with
> REPAIR_FAST, then REPAIR_REBUILD and if all else fails
> REPAIR_ALLOW_DATA_LOSS, its that option where you may lose
> data.
> If the REPAIR_ALLOW_DATA_LOSS doesn't work then you will
> have to restore from backup.
> As for the reason why to difficult to say.
> Good luck
> Peter
>
> displayed on
> of order on page
> the repair_build
> because it would
> repair_build option,
> body else have

Keys out of order on page error

We have found we have corruption in our db.
After running DBCC CHECKDB the following error were displayed on
multiple pages.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1285579618, Index ID 3. Keys out of order on page
(1:384662), slots 75 and 76.
I read a post that suggested running DBCC CHECKDB with the repair_build
option.
Since we are a 24/7 shop I cannot restore from tape, because it would
take several hours.
What are the risks of running DBCC CHECKDB with the repair_build option,
and will this fix the problem properly?
We are still unsure what has caused this corruption, any body else have
this problem?
TIA,
-BenHi Ben,
As the error is in a non-clustered index, you can just rebuild the index
with DBCC DBREINDEX (<table_name>, <index_name> ). Or if you want to be on
the safe side, just drop and recreate the index.
After that, investigate why the corruption occurred in the first place. You
might have hardware problems.
Jacco Schalkwijk
SQL Server MVP
"Ben" <bmilliron@.gmail.com> wrote in message
news:OJgEzgufEHA.636@.TK2MSFTNGP12.phx.gbl...
> We have found we have corruption in our db.
> After running DBCC CHECKDB the following error were displayed on multiple
> pages.
> Server: Msg 2511, Level 16, State 1, Line 1
> Table error: Object ID 1285579618, Index ID 3. Keys out of order on page
> (1:384662), slots 75 and 76.
> I read a post that suggested running DBCC CHECKDB with the repair_build
> option.
> Since we are a 24/7 shop I cannot restore from tape, because it would take
> several hours.
> What are the risks of running DBCC CHECKDB with the repair_build option,
> and will this fix the problem properly?
> We are still unsure what has caused this corruption, any body else have
> this problem?
> TIA,
> -Ben|||I have dropped and recreated the index, thanks. I have also opened up
an issue with our vendor to see if this may be a possible cause.
Jacco Schalkwijk wrote:
> Hi Ben,
> As the error is in a non-clustered index, you can just rebuild the index
> with DBCC DBREINDEX (<table_name>, <index_name> ). Or if you want to be on
> the safe side, just drop and recreate the index.
> After that, investigate why the corruption occurred in the first place. Yo
u
> might have hardware problems.
>

Kerberos

Hi
Want to know how to get kerberos to work
3 workstations involved
User computer with Windows 2000 runs I.E 6.0 and accesses a web page on
Reporting services server (Web Portion-IIS) running windows 2003.
USer is running a report that runs an mdx statement on a data server which
is also windows 2003
We included in the connection string sspi=kerberos
We also when to the domain controller which is windows 2003 and enabled
kerberos delegation on the web and data server.
We still get the below error
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
a.. Cannot create a connection to data source 'OLAP'.
(rsErrorOpeningConnection) Get Online Help
a.. The operation requested failed due to security problems - the user
could not be authenticated
b.. Thanks in advanceYou may want to try posting this to the
microsoft.public.windows.server.security newsgroup as well.
Jay Nathan
http://www.jaynathan.com/blog
"Will Byron" <will.byron@.maxqtech.com> wrote in message
news:u45ZipE5EHA.2124@.TK2MSFTNGP15.phx.gbl...
> Hi
> Want to know how to get kerberos to work
> 3 workstations involved
> User computer with Windows 2000 runs I.E 6.0 and accesses a web page on
> Reporting services server (Web Portion-IIS) running windows 2003.
> USer is running a report that runs an mdx statement on a data server which
> is also windows 2003
> We included in the connection string sspi=kerberos
> We also when to the domain controller which is windows 2003 and enabled
> kerberos delegation on the web and data server.
> We still get the below error
> An error has occurred during report processing. (rsProcessingAborted) Get
> Online Help
> a.. Cannot create a connection to data source 'OLAP'.
> (rsErrorOpeningConnection) Get Online Help
> a.. The operation requested failed due to security problems - the user
> could not be authenticated
> b.. Thanks in advance
>
>|||I got Kerberos to work by using the artricle at
http://support.microsoft.com/default.aspx?kbid=828280
however what I ultimately got tied up with is the olap service on the
analysis service machine was using a domain account which I assumed it could
since the above article talks about setting up an SPN if the analysis
service service runs using a domain account.
I ran into another article
http://www.mosha.com/msolap/articles/enablingdelegation.htm
which stated
The MSSQLServerOLAPService must be running under the LocalSystem account in
order for delegation to be enabled.
Once I changed to run under local system the kerberos feature worked.
"Jay Nathan" <jay@.jaynathan.com> wrote in message
news:%23WurCfU5EHA.2124@.TK2MSFTNGP15.phx.gbl...
> You may want to try posting this to the
> microsoft.public.windows.server.security newsgroup as well.
> Jay Nathan
> http://www.jaynathan.com/blog
>
> "Will Byron" <will.byron@.maxqtech.com> wrote in message
> news:u45ZipE5EHA.2124@.TK2MSFTNGP15.phx.gbl...
> > Hi
> > Want to know how to get kerberos to work
> > 3 workstations involved
> > User computer with Windows 2000 runs I.E 6.0 and accesses a web page on
> > Reporting services server (Web Portion-IIS) running windows 2003.
> > USer is running a report that runs an mdx statement on a data server
which
> > is also windows 2003
> > We included in the connection string sspi=kerberos
> > We also when to the domain controller which is windows 2003 and enabled
> > kerberos delegation on the web and data server.
> >
> > We still get the below error
> >
> > An error has occurred during report processing. (rsProcessingAborted)
Get
> > Online Help
> > a.. Cannot create a connection to data source 'OLAP'.
> > (rsErrorOpeningConnection) Get Online Help
> > a.. The operation requested failed due to security problems - the
user
> > could not be authenticated
> > b.. Thanks in advance
> >
> >
> >
>

kerberos

Hi
Want to know how to get kerberos to work
3 workstations involved
User computer with Windows 2000 runs I.E 6.0 and accesses a web page on
Reporting services server (Web Portion-IIS) running windows 2003.
USer is running a report that runs an mdx statement on a data server which
is also windows 2003
We included in the connection string sspi=kerberos
We also when to the domain controller which is windows 2003 and enabled
kerberos delegation on the web and data server.
We still get the below error
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
a.. Cannot create a connection to data source 'OLAP'.
(rsErrorOpeningConnection) Get Online Help
a.. The operation requested failed due to security problems - the user
could not be authenticated
b.. Thanks in advanceHi Will:
There are some Kerberos troubleshooting tips in the following doc:
HOW TO: Troubleshoot Kerberos-Related Issues in IIS
http://support.microsoft.com/default.aspx?kbid=326985
HTH,
--
Scott
http://www.OdeToCode.com/blogs/scott/
On Fri, 29 Oct 2004 15:52:43 -0400, "Will Byron"
<will.byron@.maxqtech.com> wrote:
>Hi
>Want to know how to get kerberos to work
>3 workstations involved
>User computer with Windows 2000 runs I.E 6.0 and accesses a web page on
>Reporting services server (Web Portion-IIS) running windows 2003.
>USer is running a report that runs an mdx statement on a data server which
>is also windows 2003
>We included in the connection string sspi=kerberos
>We also when to the domain controller which is windows 2003 and enabled
>kerberos delegation on the web and data server.
>We still get the below error
>An error has occurred during report processing. (rsProcessingAborted) Get
>Online Help
> a.. Cannot create a connection to data source 'OLAP'.
>(rsErrorOpeningConnection) Get Online Help
> a.. The operation requested failed due to security problems - the user
>could not be authenticated
> b.. Thanks in advance
>

KeepTogether not working.

Hi all,

I am using RS2005.
KeepTogether=true is not working both in the Preview tab nor when I export to PDF.
My tables still get split by a page break.
RepeatHeaderOnNewPage works as expected.
For a while I was simply putting each table on its own page, but this is such a tacky solution.
Any ideas?

As of now, repeating header on every new page is the only solution.

Shyam

|||

OK.

Thanks Shyam.

|||

So, can you please mark the post as answer?

Shyam

KeepTogether not working.

Hi all,

I am using RS2005.
KeepTogether=true is not working both in the Preview tab nor when I export to PDF.
My tables still get split by a page break.
RepeatHeaderOnNewPage works as expected.
For a while I was simply putting each table on its own page, but this is such a tacky solution.
Any ideas?

As of now, repeating header on every new page is the only solution.

Shyam

|||

OK.

Thanks Shyam.

|||

So, can you please mark the post as answer?

Shyam

KeepTogether

I'm in a search for a solution. I need to keep a group together. If it doesn't fit on the same page as the previous group it should start on a new page. I cannot believe reporting services unable to provide this.
Ok, table's grouping doesn't have keeptogether option (but the table itself has...).
Let's see List. It doesn't work. I hoped SP1 will solve it, but doesn't. Shall we wait till SP2 or the Yukon version of RS?KeepTogether on Grouping is on our future features wishlist.
(Note: KeepTogether on List wouldn't help since it tries to keep the entire
list together, not the individual groups)
--
My employer's lawyers require me to say:
"This posting is provided 'AS IS' with no warranties, and confers no
rights."
"sabe" <sabe@.discussions.microsoft.com> wrote in message
news:D2FE2D32-51B3-4732-A0C6-0ACF1F1C579C@.microsoft.com...
> I'm in a search for a solution. I need to keep a group together. If it
doesn't fit on the same page as the previous group it should start on a new
page. I cannot believe reporting services unable to provide this.
> Ok, table's grouping doesn't have keeptogether option (but the table
itself has...).
> Let's see List. It doesn't work. I hoped SP1 will solve it, but doesn't.
Shall we wait till SP2 or the Yukon version of RS?|||OK, then what's the functionality of the _current_ KeepTogether property? Nothing, I suppose...
"Chris Hays [MSFT]" wrote:
> KeepTogether on Grouping is on our future features wishlist.
> (Note: KeepTogether on List wouldn't help since it tries to keep the entire
> list together, not the individual groups)
> --
> My employer's lawyers require me to say:
> "This posting is provided 'AS IS' with no warranties, and confers no
> rights."
> "sabe" <sabe@.discussions.microsoft.com> wrote in message
> news:D2FE2D32-51B3-4732-A0C6-0ACF1F1C579C@.microsoft.com...
> > I'm in a search for a solution. I need to keep a group together. If it
> doesn't fit on the same page as the previous group it should start on a new
> page. I cannot believe reporting services unable to provide this.
> >
> > Ok, table's grouping doesn't have keeptogether option (but the table
> itself has...).
> >
> > Let's see List. It doesn't work. I hoped SP1 will solve it, but doesn't.
> Shall we wait till SP2 or the Yukon version of RS?
>
>|||OK, then what's the functionality of the _current_ KeepTogether property? Nothing, I suppose...
"Chris Hays [MSFT]" wrote:
> KeepTogether on Grouping is on our future features wishlist.
> (Note: KeepTogether on List wouldn't help since it tries to keep the entire
> list together, not the individual groups)
> --
> My employer's lawyers require me to say:
> "This posting is provided 'AS IS' with no warranties, and confers no
> rights."
> "sabe" <sabe@.discussions.microsoft.com> wrote in message
> news:D2FE2D32-51B3-4732-A0C6-0ACF1F1C579C@.microsoft.com...
> > I'm in a search for a solution. I need to keep a group together. If it
> doesn't fit on the same page as the previous group it should start on a new
> page. I cannot believe reporting services unable to provide this.
> >
> > Ok, table's grouping doesn't have keeptogether option (but the table
> itself has...).
> >
> > Let's see List. It doesn't work. I hoped SP1 will solve it, but doesn't.
> Shall we wait till SP2 or the Yukon version of RS?
>
>|||It attempts to keep the entire list together (not the individual groups
within the list).
--
My employer's lawyers require me to say:
"This posting is provided 'AS IS' with no warranties, and confers no
rights."
"sabe" <sabe@.discussions.microsoft.com> wrote in message
news:A38B97C5-3F5D-4EEC-BDB1-637131421CD0@.microsoft.com...
> OK, then what's the functionality of the _current_ KeepTogether property?
Nothing, I suppose...
>
> "Chris Hays [MSFT]" wrote:
> > KeepTogether on Grouping is on our future features wishlist.
> >
> > (Note: KeepTogether on List wouldn't help since it tries to keep the
entire
> > list together, not the individual groups)
> >
> > --
> > My employer's lawyers require me to say:
> > "This posting is provided 'AS IS' with no warranties, and confers no
> > rights."
> >
> > "sabe" <sabe@.discussions.microsoft.com> wrote in message
> > news:D2FE2D32-51B3-4732-A0C6-0ACF1F1C579C@.microsoft.com...
> > > I'm in a search for a solution. I need to keep a group together. If it
> > doesn't fit on the same page as the previous group it should start on a
new
> > page. I cannot believe reporting services unable to provide this.
> > >
> > > Ok, table's grouping doesn't have keeptogether option (but the table
> > itself has...).
> > >
> > > Let's see List. It doesn't work. I hoped SP1 will solve it, but
doesn't.
> > Shall we wait till SP2 or the Yukon version of RS?
> >
> >
> >|||I'm replying MUCH after-the-fact... this string is currently on p.18
but if anybody is still reading 18 pages deep, I'll share my workaround
in order to achieve Keep together on groups, I've been nesting tables within tables -- nested in a "merged cell" group header of the parent table
I create the parent table, group it on group1, then I merge all cells in the group header. Into the merged cell group header, I drop another table, and group that table on group2, and so on...
to make an example, say I have a U.S.A. report, that I want to show State/County/City details.
My parent table is Grouped on States. I merge cells in the State Group header, and drop another table inside the merged cells. This new table I group on Counties. I merge cells in the Group header here as well, and drop another table inside grouped on Cities... I can then say "keep together" on any of these tables
it's a pain initially, but once you get the hang of it, it seems to work... at least it has for me...
hope this makes sense...
---
"Chris Hays [MSFT]" wrote:
> It attempts to keep the entire list together (not the individual groups
> within the list).
> --
> My employer's lawyers require me to say:
> "This posting is provided 'AS IS' with no warranties, and confers no
> rights."
> "sabe" <sabe@.discussions.microsoft.com> wrote in message
> news:A38B97C5-3F5D-4EEC-BDB1-637131421CD0@.microsoft.com...
> > OK, then what's the functionality of the _current_ KeepTogether property?
> Nothing, I suppose...
> >
> >
> >
> > "Chris Hays [MSFT]" wrote:
> >
> > > KeepTogether on Grouping is on our future features wishlist.
> > >
> > > (Note: KeepTogether on List wouldn't help since it tries to keep the
> entire
> > > list together, not the individual groups)
> > >
> > > --
> > > My employer's lawyers require me to say:
> > > "This posting is provided 'AS IS' with no warranties, and confers no
> > > rights."
> > >
> > > "sabe" <sabe@.discussions.microsoft.com> wrote in message
> > > news:D2FE2D32-51B3-4732-A0C6-0ACF1F1C579C@.microsoft.com...
> > > > I'm in a search for a solution. I need to keep a group together. If it
> > > doesn't fit on the same page as the previous group it should start on a
> new
> > > page. I cannot believe reporting services unable to provide this.
> > > >
> > > > Ok, table's grouping doesn't have keeptogether option (but the table
> > > itself has...).
> > > >
> > > > Let's see List. It doesn't work. I hoped SP1 will solve it, but
> doesn't.
> > > Shall we wait till SP2 or the Yukon version of RS?
> > >
> > >
> > >
>
>|||Hi,
How you link the parent table and the child tables?
- Samuel
"Derek in Richmond" <DerekinRichmond@.discussions.microsoft.com> wrote in
message news:D821CEDE-3280-42EB-B7ED-2DBCD073DEB7@.microsoft.com...
> I'm replying MUCH after-the-fact... this string is currently on p.18
> but if anybody is still reading 18 pages deep, I'll share my workaround
> in order to achieve Keep together on groups, I've been nesting tables
within tables -- nested in a "merged cell" group header of the parent table
> I create the parent table, group it on group1, then I merge all cells in
the group header. Into the merged cell group header, I drop another table,
and group that table on group2, and so on...
> to make an example, say I have a U.S.A. report, that I want to show
State/County/City details.
> My parent table is Grouped on States. I merge cells in the State Group
header, and drop another table inside the merged cells. This new table I
group on Counties. I merge cells in the Group header here as well, and drop
another table inside grouped on Cities... I can then say "keep together" on
any of these tables
> it's a pain initially, but once you get the hang of it, it seems to
work... at least it has for me...
> hope this makes sense...
>
>
> ---
> "Chris Hays [MSFT]" wrote:
> > It attempts to keep the entire list together (not the individual groups
> > within the list).
> >
> > --
> > My employer's lawyers require me to say:
> > "This posting is provided 'AS IS' with no warranties, and confers no
> > rights."
> >
> > "sabe" <sabe@.discussions.microsoft.com> wrote in message
> > news:A38B97C5-3F5D-4EEC-BDB1-637131421CD0@.microsoft.com...
> > > OK, then what's the functionality of the _current_ KeepTogether
property?
> > Nothing, I suppose...
> > >
> > >
> > >
> > > "Chris Hays [MSFT]" wrote:
> > >
> > > > KeepTogether on Grouping is on our future features wishlist.
> > > >
> > > > (Note: KeepTogether on List wouldn't help since it tries to keep the
> > entire
> > > > list together, not the individual groups)
> > > >
> > > > --
> > > > My employer's lawyers require me to say:
> > > > "This posting is provided 'AS IS' with no warranties, and confers no
> > > > rights."
> > > >
> > > > "sabe" <sabe@.discussions.microsoft.com> wrote in message
> > > > news:D2FE2D32-51B3-4732-A0C6-0ACF1F1C579C@.microsoft.com...
> > > > > I'm in a search for a solution. I need to keep a group together.
If it
> > > > doesn't fit on the same page as the previous group it should start
on a
> > new
> > > > page. I cannot believe reporting services unable to provide this.
> > > > >
> > > > > Ok, table's grouping doesn't have keeptogether option (but the
table
> > > > itself has...).
> > > > >
> > > > > Let's see List. It doesn't work. I hoped SP1 will solve it, but
> > doesn't.
> > > > Shall we wait till SP2 or the Yukon version of RS?
> > > >
> > > >
> > > >
> >
> >
> >

Keeping Sections together

I have a problem with the details of the report for a record going to the second page. I have set the format option in the report "Keep sections together". But still the data for the report goes to the second page.

What else has to be done for the report to be proper? Please let me know on this.
I have tried out the option of setting it through the code as well by the code

"CR1.sectionformat(0) = "DETAIL;X;X;X;T;X;X;X"Hi
what is the size of the record? If it is of large size having many characters you may face this problem

Madhivanan|||It is a Group by report and i want the records for the particular group to be on the same page and it should not go to the next page. what are the other possibilities which i can try out. I am using CR 4.6

Help|||in the grey area of your group right click - select "change group" and check the "keep group together" option

Keeping a group together over page break

I'm creating a report now, that will span over several pages.
I want to keep a group togheter. The report shows clients and projects, and
I don't want to have any "hanging" projects starting on a new page.
Is it possible to have the report do page break if it calculates that the
grouping is too big for the remaining page?
Kaisa M. LindahlThere is a group property called Keeptogether ( I think thats the name) ...
Set its value to 1 ( or true) and if the entire group can not fit in the
remaining space on the space, it will auto page break ...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Kaisa M. Lindahl" <kaisaml@.hotmail.com> wrote in message
news:ew9B4nr3EHA.2180@.TK2MSFTNGP12.phx.gbl...
> I'm creating a report now, that will span over several pages.
> I want to keep a group togheter. The report shows clients and projects,
and
> I don't want to have any "hanging" projects starting on a new page.
> Is it possible to have the report do page break if it calculates that the
> grouping is too big for the remaining page?
> Kaisa M. Lindahl
>|||Thanks for the reply, but it didn't quite work out.
The KeepTogheter property works on a table level. I couldn't find it for a
group level. And according to this page
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_dc_v1_2bvp.asp
- it says when adding KeepTogether to a table, " A table group is not kept
together. "
I've tried it out, and it seems to be true, even with KeepTogether set to
true, groups will not break to be on one page.
However, I did some testing on the Edit Group bit, and turned on "Repeat
Group Header". So now it will display the group header on the new page.
Is there a way to check if a group has been split like this? Because if
there was, I'd like to do this check, and add ".. continued" on the next
page.
Kaisa M. Lindahl
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:ubciJefCFHA.1188@.tk2msftngp13.phx.gbl...
> There is a group property called Keeptogether ( I think thats the name)
...
> Set its value to 1 ( or true) and if the entire group can not fit in the
> remaining space on the space, it will auto page break ...
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> wrote in message
> news:ew9B4nr3EHA.2180@.TK2MSFTNGP12.phx.gbl...
> > I'm creating a report now, that will span over several pages.
> > I want to keep a group togheter. The report shows clients and projects,
> and
> > I don't want to have any "hanging" projects starting on a new page.
> > Is it possible to have the report do page break if it calculates that
the
> > grouping is too big for the remaining page?
> >
> > Kaisa M. Lindahl
> >
> >
>

Keep track changes made in data

I want to create a page(using GridView) where it will detect changes made in the database and display it for Administrator observation. I've created a table name history for this purpose.

History

guid (uniqueidentifier)

dateCreated(datetime)

lastDateUpdated(datetime)

changesMade(varchar(50)) -- eg; dropdownlist

oldValue(varchar(50)) -- compaq

newValue(varchar(50)) --dell

updateBy(varchar(10)) <-- username of registered user

comNo(int) = foreign key for Computer table

History data will insert data whenever a changes made. Could anyone advise and direct me how to do this function. I was thinking of using stored procedure to insert the data. Thanks in advance.

You can use a trigger in MSSQL to take action anytime a change to a row (insert, update, delete) takes place.

|||

I try to use trigger and get this error. Incorrect syntax near @.TEMP

This is the code

CREATE TRIGGERChangesTrigger

ONdbo.Computer

FOR UPDATE

AS

DECLARE@.TEMPAs varchar(50)

IF UPDATE(active)

BEGIN

SET@.TEMP ='active'

END

IF UPDATE(make)

BEGIN

SET@.TEMP ='make'

END

IF UPDATE(model)

BEGIN

SET@.TEMP ='model'

END

IF UPDATE(processor)

BEGIN

SET@.TEMP ='processor'

END

IF UPDATE(speed)

BEGIN

SET@.TEMP ='speed'

END

IF UPDATE(memory)

BEGIN

SET@.TEMP ='memory'

END

IF UPDATE(harddisk)

BEGIN

SET@.TEMP ='harddisk'

END

IF UPDATE(serialNo)

BEGIN

SET@.TEMP ='serialNo'

END

IF UPDATE(assetNo)

BEGIN

SET@.TEMP ='assetNo'

END

IF UPDATE(opsystem)

BEGIN

SET@.TEMP ='opSystem'

END

IF UPDATE(msOfficeVersion)

BEGIN

SET@.TEMP ='msOfficeVersion'

END

IF UPDATE(invoiceNo)

BEGIN

SET@.TEMP ='invoiceNo'

END

IF UPDATE(poNo)

BEGIN

SET@.TEMP ='poNo'

END

IF UPDATE(networkCard)

BEGIN

SET@.TEMP ='networkCard'

END

IF UPDATE(ipAddress)

BEGIN

SET@.TEMP ='ipAddress'

END

IF UPDATE(ras)

BEGIN

SET@.TEMP ='ras'

END

IF UPDATE(rasvpn)

BEGIN

SET@.TEMP ='rasvpn'

END

IF UPDATE(device)

BEGIN

SET@.TEMP ='device'

END

IF UPDATE(floppyDisk)

BEGIN

SET@.TEMP ='ROUTER_NAME'

END

IF UPDATE(userId)

BEGIN

SET@.TEMP ='ROUTER_NAME'

END

INSERT INTOHistory(lastDateUpdated, changesMade, oldValue, newValue, wscNo, updateBy)

VALUES(GETDATE(), @.TEMP, deleted.@.TEMP, inserted.@.TEMP, updated.wscNo,SUSER_SNAME())

Then I found out that SUSER_NAME doesn't insert the name of people who logged in and update the data.

|||Why do you usedeleted.@.TEMP/inserted.@.TEMP ? @.TEMP is a variable, not a column in the table. If you want to insert into History table with values from different columns in deleted/inserted table, you need different INSERT command for each case (for different updated columns).|||

Or we can make a trick by using COLUMNS_UPDATED() function and EXECUTE dynamic SQL statement in the trigger. Suppose the dbo.Computer table looks like:

dbo.Computer (ComID,active,make,model,processor,speed,memory,harddisk,serialNo,assetNo,
opSystem,msOfficeVersion,invoiceNo,poNo,networkCard,ipAddress,ras,rasvpn)

Then we can use such a trigger:

ALTER TRIGGER ChangesTrigger ON dbo.Computer FOR UPDATE
AS
DECLARE @.TEMP As varchar(50)
SELECT @.TEMP=CASE WHEN COLUMNS_UPDATED()&2=2
THEN 'active'
WHEN COLUMNS_UPDATED()&4=4
THEN 'make'
WHEN COLUMNS_UPDATED()&8=8
THEN 'model'
WHEN COLUMNS_UPDATED()&16=16
THEN 'processor'
--<add other conditions here...>
WHEN COLUMNS_UPDATED()&power(2,20-1)=power(2,20-1)
THEN 'ROUTER_NAME'
WHEN COLUMNS_UPDATED()&power(2,21-1)=power(2,21-1)
THEN 'ROUTER_NAME'
END

EXEC('INSERT INTO History(lastDateUpdated, changesMade, oldValue, newValue, wscNo, updateBy)
VALUES(GETDATE(),'''+@.TEMP+''',deleted.['+@.TEMP+'],inserted.['+@.TEMP+'], updated.wscNo, SUSER_SNAME())')

go

For more information about COLUMNS_UPDATED function, you can refer to:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_create2_7eeq.asp

|||

I got a new idea: if update to the dbo.Computer table will always effect only 1 column, we can get the value of @.Temp (that's the effected column name, right?) directly from system table:

ALTER trigger trg_test on tblTrg for update
as
declare @.temp sysname
SELECT @.temp=name FROM syscolumns
WHERE id=OBJECT_ID('tblTrg') and POWER(2,colid-1)=COLUMNS_UPDATED()
EXEC('INSERT INTO History(lastDateUpdated, changesMade, oldValue, newValue, wscNo, updateBy)
VALUES(GETDATE(),'''+@.TEMP+''',deleted.['+@.TEMP+'],inserted.['+@.TEMP+'], updated.wscNo, SUSER_SNAME())')
go

|||What is the numbers anyway and how to use it. Anyway, I never use trigger and stored procedure before so I don't know the command that can be used in trigger. After all, the code that i use for trigger was taken from other sources and i modify according to my database. thanks for direction. i will try the codes.|||

This is the error I get.

The name "deleted.serialNo" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted.

This is the trigger I wrote since I'm confuse with the use of power(2,20-1). What is wrong with the code. I change updated.wscNo to inserted.wscNo since wscNo couldn,t be updated and I actually don't know what should i put in inserted.wscNo because I want to catch the no of computer that changes are made.

ALTER TRIGGER

ChangesTriggerONdbo.ComputerFOR UPDATE

AS

DECLARE

@.TEMPAs varchar(50)

SELECT

@.TEMP=CASE WHEN COLUMNS_UPDATED()&2=2THEN'active'WHEN COLUMNS_UPDATED()&4=4THEN'make'WHEN COLUMNS_UPDATED()&8=8THEN'model'WHEN COLUMNS_UPDATED()&16=16THEN'processor'WHEN COLUMNS_UPDATED()&32=32THEN'speed'WHEN COLUMNS_UPDATED()&64=64THEN'memory'WHEN COLUMNS_UPDATED()&128=128THEN'harddisk'WHEN COLUMNS_UPDATED()&256=256THEN'serialNo'WHEN COLUMNS_UPDATED()&512=512THEN'assetNo'WHEN COLUMNS_UPDATED()&1024=1024THEN'opSystem'WHEN COLUMNS_UPDATED()&2048=2048THEN'version'WHEN COLUMNS_UPDATED()&4096=4096THEN'opSerial'WHEN COLUMNS_UPDATED()&8192=8192THEN'msOfficeVersion'WHEN COLUMNS_UPDATED()&16384=16384THEN'invoiceNo'WHEN COLUMNS_UPDATED()&32768=32768THEN'poNo'WHEN COLUMNS_UPDATED()&65536=65536THEN'networkCard'WHEN COLUMNS_UPDATED()&131072=131072THEN'ipAddress'WHEN COLUMNS_UPDATED()&262144=262144THEN'ras'WHEN COLUMNS_UPDATED()&524288=524288THEN'rasvpn'WHEN COLUMNS_UPDATED()&1048576=1048576THEN'device'WHEN COLUMNS_UPDATED()&2097152=2097152THEN'floppyDisk'WHEN COLUMNS_UPDATED()&4194304=4194304THEN'userId'ENDEXEC('INSERT INTO History(lastDateUpdated, changesMade, oldValue, newValue, wscNo, updateBy)VALUES(GETDATE(), '''+@.TEMP+''', deleted.['+@.TEMP+'], inserted.['+@.TEMP+'], inserted.wscNo, SUSER_SNAME())')

I delete go because I got an error regarding go.

|||

deleted and inserted aren't available in that context (EXEC) because it's technically not executing within the context of the trigger any longer. Also INSERT INTO ... VALUES would be the wrong syntax for accessing deleted and inserted pseudo tables. You would need an INSERT ... SELECT. The trigger would also fail if you modified multiple columns (Only recording a single change), or multiple rows (possibly, depends on how you fix the problems), and logging changes that don't really happen (UPDATE table SET col=col) would show records being changed that don't get changed.

You would need to do something like:

DECLARE@.TEMP varchar(50)

DECLARE @.oldval varchar(50)

DECLARE @.newval varchar(50)

IF COLUMNS_UPDATED()&2=2 SELECT @.TEMP='active',@.oldval=deleted.active,@.newval=deleted.active FROM inserted JOIN deleted ON inserted.wsc=deleted.wsc

...

and at then reference @.oldval and @.newval instead of inserted/deleted pseudo tables, but that still has the multiple columns and multiple row update problems.

However, I would suggest a change in approach, which works much better. Design a standard audit table like:

AuditID identity int

ChangeType char(1) ' I/U/D

ChangeDate datetime default getdate()

(a column here for each column in your table with same column definiation - with the exception that all columns are nullable)

The create your triggers like:

ON INSERT:

INSERT INTO History(ChangeType,...) SELECT 'I',I.* FROM inserted

ON UPDATE:

INSERT INTO History(ChangeType,...) SELECT 'U',I.* FROM inserted i ' Optionally add JOIN deleted d WHERE (i.col1<>d.col1 OR (i.col1 IS NULL AND d.col1 IS NOT NULL) OR (i.col1 IS NOT NULL AND d.col1 IS NULL)) and repeat for each column to remove false change entries

ON DELETE:

INSERT INTO History(ChangeType,wscNo) SELECT 'D',deleted.wscNo FROM deleted

Then you can track every change to every column, including the cases where multiple columns (or records) are updated at a time. Although, it does make the logic for displaying what was changed a bit more difficult, it's not that complicated, and history tracking usually isn't done that often in most cases. This is also a pretty common audit table, so it can carry over from table to table and project to project. (Most people would call this table something like AuditComputers, where Computers is the original table).

You will have the problem where SUSER_SNAME won't give you the name of the person who did the change, unless you create a SQL user for each person that is allowed to make changes, and each connection by those users are done with their own credentials, but that's a different issue. If you need to propegate actual user information from asp.net where they don't log in to sql server with their own identity, then it gets a bit more tricky. You can still do it (Mostly) with triggers, if you define an UpdatedBy column in the original table. You can also enforce specific rules within the insert/update triggers to make sure it's being filled LIKE:

IF NOT UPDATED(UpdatedBy) BEGIN RAISEERROR('You must supply the UpdatedBy column when modifying records') ROLLBACK END ELSE BEGIN ... END

Deleted entries are a bit more tricky because you don't have the user information in any of the information available to the trigger when it happens. In that case, you may want to make a stored procedure to deleted records from the table, and insert the data into the audit table within that. Then remove access to delete from the table directly through permissions.

|||

This is the code I made. I got an error between END and ON. I think it require me to put some code but i don't know what it is.

CREATE TRIGGERChangedTrigger

ONdbo.Computer

FOR UPDATE

AS

DECLARE

@.changeTypechar(1),

@.guiduniqueidentifier,

@.dateCreateddatetime,

@.lastDateUpdateddatetime,

@.changesMadevarchar(50),

@.oldValuevarchar(50),

@.newValuevarchar(50),

@.wscNobigint,

@.updateByvarchar(10)

ON INSERT:

BEGIN

INSERT INTOHistory(guid,changeType,dateCreated,lastDateUpdated,changesMade,oldValue,newValue,wscNo,updateBy)

VALUES(@.guid,'I',GETDATE(),GETDATE(),@.changesMade,@.oldValue,@.newValue,@.wscNo,SUSER_NAME())

SELECT'I', I.*FROMinserted

END

ON UPDATE:

BEGIN

INSERT INTOHistory(guid,changeType,lastDateUpdated,changesMade,oldValue,newValue,wscNo,updateBy)

VALUES(@.guid,'U',GETDATE(),@.changesMade,@.oldValue,@.newValue,@.wscNo,SUSER_NAME())

SELECT'U', I.*FROMinserted iJOINdeleted d

END

ON DELETE:

BEGIN

INSERT INTOHistory(guid,changeType,wscNo)VALUES(@.guid,'D',@.wscNo)

SELECT'D', deleted.wscNoFROMdeleted

END

|||Sorry, the ON INSERT: wasn't a T-SQL command. The On insert would look like:

CREATE TRIGGERComputer_Inserted

ONdbo.Computer

FOR INSERT

AS

BEGIN

INSERT INTOHistory(changeType,{List each column in the Computer Table here})

SELECT'I', i.*FROMinserted i

END

THe update portion would be:

CREATE TRIGGERComputer_Updated

ONdbo.Computer

FOR UPDATE

AS

BEGIN

INSERT INTOHistory(changeType,{List each column in the Computer Table here})

SELECT'U', i.*FROMinserted i

END

And the deleted trigger would be:

CREATE TRIGGERComputer_Updated

ONdbo.Computer

FOR DELETE

AS

BEGIN

INSERT INTOHistory(ChangeType,wscNo)

SELECT'D', deleted.wscNoFROMdeleted

END

|||

Owh! It should be separated. Okay I'll try and let u know if any problem occur.

|||

I got this error for insert and update trigger. 'Incorrect syntax near {'

Update:

ALTER TRIGGERInsertTrigger

ONdbo.Computer

FOR INSERT

AS

BEGIN

INSERT INTOHistory(changeType,{wscNo,active,make,model,processor,speed,memory,harddisk,serialNo,assetNo,opSystem,version,opSerial,msOfficeVersion,invoiceNo,poNo,networkCard,ipAddress,ras,rasvpn,device,floppyDisk,userId})

SELECT'I', i.*FROMinserted i

END

Insert:

ALTER TRIGGERUpdateTrigger

ONdbo.Computer

FOR UPDATE

AS

BEGIN

INSERT INTOHistory(changeType,{wscNo,active,make,model,processor,speed,memory,harddisk,serialNo,assetNo,opSystem,version,opSerial,msOfficeVersion,invoiceNo,poNo,networkCard,ipAddress,ras,rasvpn,device,floppyDisk,userId})

SELECT'U', i.*FROMinserted i

END

If I remove {} the error says that all the computer table column is not exist

|||remove the {}'s and make sure your History table also has those columns (wscNo,active,make,model, etc)|||Oh, I have to include the computer table attribute in it. Is there any other way, let's say like History table i've created, i make wscNo(primary key for tabel Computer) as a foreign key.

Keep TableRow Together

I have a table with 3 tablerows. This 3 tablerows needs to stay together on the same page for each record. Sometime, a function set the Hidden property of one of this tablerow to true, so I cannot just fit the table to get a multiple number of 3.

I use visual studio 2003 to create this rdl.

Thanks,

Marco

Can you restructure your report to have a single table row with a rectangle containing the current three rows of data? By default, SSRS has an implicit keeptogether that attempts to keep containers together when rendering them to a paged format. You can also see books on line for additional pointers:

"Rendering Considerations for Automatic Sizing and Positioning" http://technet.microsoft.com/en-us/library/aa337175.aspx

Larry

|||

I will try and i'll let you know!

Thanks,

Marco

|||

Hey Marco,

Did you fix your problem? I have an identical one and I would like to know if you could solved. Please share your solution with me, it will be very much appreciated.

Ioan Cozma

|||

I'll test that tonight or tomorow. Si I will notice you as soon as possible.

Best regards,

Marco

|||

Hi,

Sorry to be long...

So, it don't resolve completly my problem. For now, all lines are grouped, so this part is ok.

I have 5 lines, each have "Can decrease to accommodate contents" checked. So when Hidden property is set to True, there is no blank line.

But, the tablerow seem to have a static Height and no "Can decrease to accommodate contents". What could I do to get one or to simulate one?

Thanks,

Marco

|||

Have you thought about using a list rather than a table? The table and matrix controls are just specalized forms of lists. A list would give you the ability to do what you want. I have confirmed that by aligning text boxes to the top of the list and others below, the resulting report will not skip lines for hidden text boxes. Make sure to align the left and right edges as if the text boxes were within a table.

Larry

Keep TableRow Together

I have a table with 3 tablerows. This 3 tablerows needs to stay together on the same page for each record. Sometime, a function set the Hidden property of one of this tablerow to true, so I cannot just fit the table to get a multiple number of 3.

I use visual studio 2003 to create this rdl.

Thanks,

Marco

Can you restructure your report to have a single table row with a rectangle containing the current three rows of data? By default, SSRS has an implicit keeptogether that attempts to keep containers together when rendering them to a paged format. You can also see books on line for additional pointers:

"Rendering Considerations for Automatic Sizing and Positioning" http://technet.microsoft.com/en-us/library/aa337175.aspx

Larry

|||

I will try and i'll let you know!

Thanks,

Marco

|||

Hey Marco,

Did you fix your problem? I have an identical one and I would like to know if you could solved. Please share your solution with me, it will be very much appreciated.

Ioan Cozma

|||

I'll test that tonight or tomorow. Si I will notice you as soon as possible.

Best regards,

Marco

|||

Hi,

Sorry to be long...

So, it don't resolve completly my problem. For now, all lines are grouped, so this part is ok.

I have 5 lines, each have "Can decrease to accommodate contents" checked. So when Hidden property is set to True, there is no blank line.

But, the tablerow seem to have a static Height and no "Can decrease to accommodate contents". What could I do to get one or to simulate one?

Thanks,

Marco

|||

Have you thought about using a list rather than a table? The table and matrix controls are just specalized forms of lists. A list would give you the ability to do what you want. I have confirmed that by aligning text boxes to the top of the list and others below, the resulting report will not skip lines for hidden text boxes. Make sure to align the left and right edges as if the text boxes were within a table.

Larry

Keep table headers on the page

I am using SSRS 2005. I want to keep the table headers on the page when I
scroll down the page. I am looking for something like freeze frames in
Excel. Any ideas?There are properties for this.
FixedHeader and RepeatHeaderOnNewPage might do the trick for you.
Craig
"NeedToKnow" <NeedToKnow@.newsgroups.nospam> wrote in message
news:E486155B-1D1D-46E6-8727-5DFF16055916@.microsoft.com...
>I am using SSRS 2005. I want to keep the table headers on the page when I
> scroll down the page. I am looking for something like freeze frames in
> Excel. Any ideas?|||Right click the row handle for the table header and go to the properties...
There is an option called
Header should remain visible while scrolling
When you select it, the header will stay visible ( in html render) while
scrolling..
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"NeedToKnow" wrote:
> I am using SSRS 2005. I want to keep the table headers on the page when I
> scroll down the page. I am looking for something like freeze frames in
> Excel. Any ideas?