This is a multi-part message in MIME format.
--=_NextPart_000_0020_01C5E53E.B83BB160
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
What do I need to do to give someone access to Manage Triggers in EM?
Is there a way to give them access to view triggers via EM, but disable = their ability to create/drop?
--=_NextPart_000_0020_01C5E53E.B83BB160
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
What do I need to do = to give someone access to Manage Triggers in EM?
Is there a way to give = them access to view triggers via EM, but disable their ability to = create/drop?
--=_NextPart_000_0020_01C5E53E.B83BB160--You need to be table owner or higher for this. And you cannot grant table owner in 2000. In other
words, either be the owner of the table or db_owner (you could try db_ddladmin, not sure). Whether
EM then will enable the option or not, I don't know...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"JLS" <jlshoop@.hotmail.com> wrote in message news:eoNMiiW5FHA.620@.TK2MSFTNGP12.phx.gbl...
What do I need to do to give someone access to Manage Triggers in EM?
Is there a way to give them access to view triggers via EM, but disable their ability to
create/drop?
Showing posts with label text. Show all posts
Showing posts with label text. Show all posts
Friday, March 30, 2012
Wednesday, March 28, 2012
Making text bold in a table cell
I want to build a string to be displayed in a table cell using an
expression, I want to make some parts of the string bold. Can I do this..?
here's an example, in my table cell I have the following expression:
= "Cause:" + Fields!Cause.Value
I want to make the text string "Cause:" bold
TIA,
DanIt's all or nothing in the current release - this attribute can be set at a
cell level, not to a part of string in the cell.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"alien2_51" <dan.billow"at"n.o.s.p.a.m.monacocoach.commercialversion> wrote
in message news:%23H8vxFBfEHA.248@.TK2MSFTNGP12.phx.gbl...
> I want to build a string to be displayed in a table cell using an
> expression, I want to make some parts of the string bold. Can I do this..?
> here's an example, in my table cell I have the following expression:
> = "Cause:" + Fields!Cause.Value
> I want to make the text string "Cause:" bold
>
> TIA,
> Dan
>|||Formatting only part of the string (i.e. rich text) isn't in the current
version. On the wishlist for a future version.
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"alien2_51" <dan.billow"at"n.o.s.p.a.m.monacocoach.commercialversion> wrote
in message news:%23H8vxFBfEHA.248@.TK2MSFTNGP12.phx.gbl...
> I want to build a string to be displayed in a table cell using an
> expression, I want to make some parts of the string bold. Can I do this..?
> here's an example, in my table cell I have the following expression:
> = "Cause:" + Fields!Cause.Value
> I want to make the text string "Cause:" bold
>
> TIA,
> Dan
>
expression, I want to make some parts of the string bold. Can I do this..?
here's an example, in my table cell I have the following expression:
= "Cause:" + Fields!Cause.Value
I want to make the text string "Cause:" bold
TIA,
DanIt's all or nothing in the current release - this attribute can be set at a
cell level, not to a part of string in the cell.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"alien2_51" <dan.billow"at"n.o.s.p.a.m.monacocoach.commercialversion> wrote
in message news:%23H8vxFBfEHA.248@.TK2MSFTNGP12.phx.gbl...
> I want to build a string to be displayed in a table cell using an
> expression, I want to make some parts of the string bold. Can I do this..?
> here's an example, in my table cell I have the following expression:
> = "Cause:" + Fields!Cause.Value
> I want to make the text string "Cause:" bold
>
> TIA,
> Dan
>|||Formatting only part of the string (i.e. rich text) isn't in the current
version. On the wishlist for a future version.
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"alien2_51" <dan.billow"at"n.o.s.p.a.m.monacocoach.commercialversion> wrote
in message news:%23H8vxFBfEHA.248@.TK2MSFTNGP12.phx.gbl...
> I want to build a string to be displayed in a table cell using an
> expression, I want to make some parts of the string bold. Can I do this..?
> here's an example, in my table cell I have the following expression:
> = "Cause:" + Fields!Cause.Value
> I want to make the text string "Cause:" bold
>
> TIA,
> Dan
>
Wednesday, March 21, 2012
make XML column not case sensitive
Is there any way that an xml column in sql can be made to not be case sensitive?
So you can search for the text() of a node matching say 'open' (properties.exist('property[. = "open"]') and get all results back where the property text = "OPEN" or any other not case sensitive combination of "open".
Collations are not supported in SQL Server 2005 for XQuery. In order to perform your collation-sensitive comparison, you should promote the value out of the XML instance using the .value() method and perform the comparison in T-SQL.|||
If you find that you like to see such functionality added in a future release, please file a request in the SQL Server Feedback Center @. http://lab.msdn.microsoft.com/productfeedback/
Best regards
Michael
Make XACT_ABORT persist?
This is a multi-part message in MIME format.
--=_NextPart_000_000C_01C55544.13F07530
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi,
I want my transactions to abort when a runtime error (i.e. foreign = key constraint violation) occurs. I currently accomplish this by = prefixing all of my queries with:
SET XACT_ABORT ON
Is there a way to set this option globally so that I don't have to = continually set this option on each query? My first attempt to do this = was:
EXEC sp_dboption 'MyDatabaseName', 'xact_abort', 'true'
...which returned the following error message:
Database option 'xact_abort' does not exist.
Any help would be appreciated. Thanks.
Sincerely,
Vincent Vega
--=_NextPart_000_000C_01C55544.13F07530
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Hi,
I want my = transactions to abort when a runtime error (i.e. foreign key constraint violation) = occurs. I currently accomplish this by prefixing all of my queries = with:
SET XACT_ABORT ON
Is there a way to = set this option globally so that I don't have to continually set this = option on each query? My first attempt to do this was:
EXEC sp_dboption = 'MyDatabaseName', 'xact_abort', 'true'
...which returned = the following error message:
Database option = 'xact_abort' does not exist.
Any help would be = appreciated. Thanks.
Sincerely,
Vincent Vega
--=_NextPart_000_000C_01C55544.13F07530--This is a multi-part message in MIME format.
--=_NextPart_000_0048_01C5559A.040E7CB0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Just turning that on will eventually help you with your present =problems, but will make a lot of trouble when leaving this as a global =setting:
"Specifies whether Microsoft=AE SQL ServerT automatically rolls back the =current transaction if a Transact-SQL statement raises a run-time =error."
I would rather do some error handling than just pushing in all data with =ignoring the error about that.
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Vincent Vega" <Pulp@.Fiction.com> schrieb im Newsbeitrag =news:aJadna7pIuwCfh3fRVn-3w@.giganews.com...
Hi,
I want my transactions to abort when a runtime error (i.e. foreign =key constraint violation) occurs. I currently accomplish this by =prefixing all of my queries with:
SET XACT_ABORT ON
Is there a way to set this option globally so that I don't have to =continually set this option on each query? My first attempt to do this =was:
EXEC sp_dboption 'MyDatabaseName', 'xact_abort', 'true'
...which returned the following error message:
Database option 'xact_abort' does not exist.
Any help would be appreciated. Thanks.
Sincerely,
Vincent Vega
--=_NextPart_000_0048_01C5559A.040E7CB0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Just turning that on will eventually =help you with your present problems, but will make a lot of trouble when leaving this =as a global setting:
"Specifies whether Microsoft=AE SQL Server=99 automatically rolls =back the current transaction if a Transact-SQL statement raises a run-time =error."
I would rather do some error handling =than just pushing in all data with ignoring the error about that.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Vincent Vega" schrieb im =Newsbeitrag news:aJadna7pIuwCfh3fRV=n-3w@.giganews.com...
Hi,
I want my =transactions to abort when a runtime error (i.e. foreign key constraint violation) =occurs. I currently accomplish this by prefixing all of my queries =with:
SET XACT_ABORT ON
Is there a way =to set this option globally so that I don't have to continually set this =option on each query? My first attempt to do this was:
EXEC sp_dboption 'MyDatabaseName', 'xact_abort', 'true'
...which =returned the following error message:
Database option ='xact_abort' does not exist.
Any help would =be appreciated. Thanks.
Sincerely,
Vincent Vega
--=_NextPart_000_0048_01C5559A.040E7CB0--|||I fully agree with Jens. If you still want to turn this on, you can at the instance level using
sp_configure. Note that many tools etc are not designed to use this setting, so be aware.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in message
news:eDuF9kYVFHA.3312@.TK2MSFTNGP10.phx.gbl...
Just turning that on will eventually help you with your present problems, but will make a lot of
trouble when leaving this as a global setting:
"Specifies whether Microsoft® SQL ServerT automatically rolls back the current transaction if a
Transact-SQL statement raises a run-time error."
I would rather do some error handling than just pushing in all data with ignoring the error about
that.
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Vincent Vega" <Pulp@.Fiction.com> schrieb im Newsbeitrag
news:aJadna7pIuwCfh3fRVn-3w@.giganews.com...
Hi,
I want my transactions to abort when a runtime error (i.e. foreign key constraint violation)
occurs. I currently accomplish this by prefixing all of my queries with:
SET XACT_ABORT ON
Is there a way to set this option globally so that I don't have to continually set this option
on each query? My first attempt to do this was:
EXEC sp_dboption 'MyDatabaseName', 'xact_abort', 'true'
...which returned the following error message:
Database option 'xact_abort' does not exist.
Any help would be appreciated. Thanks.
Sincerely,
Vincent Vega
--=_NextPart_000_000C_01C55544.13F07530
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi,
I want my transactions to abort when a runtime error (i.e. foreign = key constraint violation) occurs. I currently accomplish this by = prefixing all of my queries with:
SET XACT_ABORT ON
Is there a way to set this option globally so that I don't have to = continually set this option on each query? My first attempt to do this = was:
EXEC sp_dboption 'MyDatabaseName', 'xact_abort', 'true'
...which returned the following error message:
Database option 'xact_abort' does not exist.
Any help would be appreciated. Thanks.
Sincerely,
Vincent Vega
--=_NextPart_000_000C_01C55544.13F07530
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Hi,
I want my = transactions to abort when a runtime error (i.e. foreign key constraint violation) = occurs. I currently accomplish this by prefixing all of my queries = with:
SET XACT_ABORT ON
Is there a way to = set this option globally so that I don't have to continually set this = option on each query? My first attempt to do this was:
EXEC sp_dboption = 'MyDatabaseName', 'xact_abort', 'true'
...which returned = the following error message:
Database option = 'xact_abort' does not exist.
Any help would be = appreciated. Thanks.
Sincerely,
Vincent Vega
--=_NextPart_000_000C_01C55544.13F07530--This is a multi-part message in MIME format.
--=_NextPart_000_0048_01C5559A.040E7CB0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Just turning that on will eventually help you with your present =problems, but will make a lot of trouble when leaving this as a global =setting:
"Specifies whether Microsoft=AE SQL ServerT automatically rolls back the =current transaction if a Transact-SQL statement raises a run-time =error."
I would rather do some error handling than just pushing in all data with =ignoring the error about that.
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Vincent Vega" <Pulp@.Fiction.com> schrieb im Newsbeitrag =news:aJadna7pIuwCfh3fRVn-3w@.giganews.com...
Hi,
I want my transactions to abort when a runtime error (i.e. foreign =key constraint violation) occurs. I currently accomplish this by =prefixing all of my queries with:
SET XACT_ABORT ON
Is there a way to set this option globally so that I don't have to =continually set this option on each query? My first attempt to do this =was:
EXEC sp_dboption 'MyDatabaseName', 'xact_abort', 'true'
...which returned the following error message:
Database option 'xact_abort' does not exist.
Any help would be appreciated. Thanks.
Sincerely,
Vincent Vega
--=_NextPart_000_0048_01C5559A.040E7CB0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Just turning that on will eventually =help you with your present problems, but will make a lot of trouble when leaving this =as a global setting:
"Specifies whether Microsoft=AE SQL Server=99 automatically rolls =back the current transaction if a Transact-SQL statement raises a run-time =error."
I would rather do some error handling =than just pushing in all data with ignoring the error about that.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Vincent Vega"
Hi,
I want my =transactions to abort when a runtime error (i.e. foreign key constraint violation) =occurs. I currently accomplish this by prefixing all of my queries =with:
SET XACT_ABORT ON
Is there a way =to set this option globally so that I don't have to continually set this =option on each query? My first attempt to do this was:
EXEC sp_dboption 'MyDatabaseName', 'xact_abort', 'true'
...which =returned the following error message:
Database option ='xact_abort' does not exist.
Any help would =be appreciated. Thanks.
Sincerely,
Vincent Vega
--=_NextPart_000_0048_01C5559A.040E7CB0--|||I fully agree with Jens. If you still want to turn this on, you can at the instance level using
sp_configure. Note that many tools etc are not designed to use this setting, so be aware.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in message
news:eDuF9kYVFHA.3312@.TK2MSFTNGP10.phx.gbl...
Just turning that on will eventually help you with your present problems, but will make a lot of
trouble when leaving this as a global setting:
"Specifies whether Microsoft® SQL ServerT automatically rolls back the current transaction if a
Transact-SQL statement raises a run-time error."
I would rather do some error handling than just pushing in all data with ignoring the error about
that.
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Vincent Vega" <Pulp@.Fiction.com> schrieb im Newsbeitrag
news:aJadna7pIuwCfh3fRVn-3w@.giganews.com...
Hi,
I want my transactions to abort when a runtime error (i.e. foreign key constraint violation)
occurs. I currently accomplish this by prefixing all of my queries with:
SET XACT_ABORT ON
Is there a way to set this option globally so that I don't have to continually set this option
on each query? My first attempt to do this was:
EXEC sp_dboption 'MyDatabaseName', 'xact_abort', 'true'
...which returned the following error message:
Database option 'xact_abort' does not exist.
Any help would be appreciated. Thanks.
Sincerely,
Vincent Vega
Make Text File as DataSource in Crystal Report 10
Dear all,
We have Crystal Report 10.
And we want to make a text file (with column separator : | ) as a data source for the crystal report 10.
We check available datasource but we can not find suitable way.
And we do not see any option for text file in ODBC.
Once we were successful but it reads the whole row without splitting it into columns based on "|" sign.
And we do not want to use VB programming.
Pls help.
Thanks
hendysearch here
http://support.businessobjects.com|||You can try creating an ODBC connection to the text file with the text driver. I don't know how successful it will be, but you could try.
We have Crystal Report 10.
And we want to make a text file (with column separator : | ) as a data source for the crystal report 10.
We check available datasource but we can not find suitable way.
And we do not see any option for text file in ODBC.
Once we were successful but it reads the whole row without splitting it into columns based on "|" sign.
And we do not want to use VB programming.
Pls help.
Thanks
hendysearch here
http://support.businessobjects.com|||You can try creating an ODBC connection to the text file with the text driver. I don't know how successful it will be, but you could try.
make table cell text - BOLD
hi there, i have question..i have a table which i fill with data form
a database...
Col1 Col2 Col3
---
=Fields!.. =Fields!... =Fields!
Col1 is filled with some text and has like 15 rows, and Col2 and Col3
are its values...So my question is - is it possible to have certain
values from Col1 to be BOLD, for example i want to have the fourth and
sixth row value for Col1 to be BOLD text...
THNX!Maybe you can place each of your 15 rows in Col1 in one detail row in your
table, so you can apply specific format in every separated row.
Does it help?
"ApeX" <jkdmaster_5@.hotmail.com> escribió en el mensaje
news:1187248049.501166.88240@.19g2000hsx.googlegroups.com...
> hi there, i have question..i have a table which i fill with data form
> a database...
> Col1 Col2 Col3
> ---
> =Fields!.. =Fields!... =Fields!
>
> Col1 is filled with some text and has like 15 rows, and Col2 and Col3
> are its values...So my question is - is it possible to have certain
> values from Col1 to be BOLD, for example i want to have the fourth and
> sixth row value for Col1 to be BOLD text...
> THNX!
>|||On Aug 16, 3:07 am, ApeX <jkdmaste...@.hotmail.com> wrote:
> hi there, i have question..i have a table which i fill with data form
> a database...
> Col1 Col2 Col3
> ---
> =Fields!.. =Fields!... =Fields!
> Col1 is filled with some text and has like 15 rows, and Col2 and Col3
> are its values...So my question is - is it possible to have certain
> values from Col1 to be BOLD, for example i want to have the fourth and
> sixth row value for Col1 to be BOLD text...
> THNX!
Try inserting this expression into the FontWeight property for the
cell you want:
=IIF(RowNumber(nothing) = 4 or RowNumber(nothing) = 6, "Bold",
"Normal")
That should work
toolman|||Your not going to be able to do it particularly gracefully if there's no
logic behind the decision.
What you can do is us a custom code block and put an expression on the
FontWeight property of yuor column.
Public Function GetFontWeight( _
ByVal columnValue As String) As String
If columnValue = "Col1" Or columnValue = "Col2 Then Return "Bold"
Return "Normal"
End Function
Expression on FontWeight property:
=Code.GetFontWeight(Fields!YourColumn.Value)
Joe
"ApeX" wrote:
> hi there, i have question..i have a table which i fill with data form
> a database...
> Col1 Col2 Col3
> ---
> =Fields!.. =Fields!... =Fields!
>
> Col1 is filled with some text and has like 15 rows, and Col2 and Col3
> are its values...So my question is - is it possible to have certain
> values from Col1 to be BOLD, for example i want to have the fourth and
> sixth row value for Col1 to be BOLD text...
> THNX!
>|||To follow up with what Joe said, if you have logic that determines which rows
you want bold it is possible. Simply put that logic in the FontWeight
property of the cell (either using the custom code joe suggested or a simple
IIF statement). You will, however, have to bold the entire contents of that
cell. You won't be able to just bold certain words (wasn't sure if this was
your question).
Hope this helps...
"Joe" wrote:
> Your not going to be able to do it particularly gracefully if there's no
> logic behind the decision.
> What you can do is us a custom code block and put an expression on the
> FontWeight property of yuor column.
> Public Function GetFontWeight( _
> ByVal columnValue As String) As String
> If columnValue = "Col1" Or columnValue = "Col2 Then Return "Bold"
> Return "Normal"
> End Function
> Expression on FontWeight property:
> =Code.GetFontWeight(Fields!YourColumn.Value)
> Joe
> "ApeX" wrote:
> > hi there, i have question..i have a table which i fill with data form
> > a database...
> >
> > Col1 Col2 Col3
> > ---
> > =Fields!.. =Fields!... =Fields!
> >
> >
> > Col1 is filled with some text and has like 15 rows, and Col2 and Col3
> > are its values...So my question is - is it possible to have certain
> > values from Col1 to be BOLD, for example i want to have the fourth and
> > sixth row value for Col1 to be BOLD text...
> >
> > THNX!
> >
> >
a database...
Col1 Col2 Col3
---
=Fields!.. =Fields!... =Fields!
Col1 is filled with some text and has like 15 rows, and Col2 and Col3
are its values...So my question is - is it possible to have certain
values from Col1 to be BOLD, for example i want to have the fourth and
sixth row value for Col1 to be BOLD text...
THNX!Maybe you can place each of your 15 rows in Col1 in one detail row in your
table, so you can apply specific format in every separated row.
Does it help?
"ApeX" <jkdmaster_5@.hotmail.com> escribió en el mensaje
news:1187248049.501166.88240@.19g2000hsx.googlegroups.com...
> hi there, i have question..i have a table which i fill with data form
> a database...
> Col1 Col2 Col3
> ---
> =Fields!.. =Fields!... =Fields!
>
> Col1 is filled with some text and has like 15 rows, and Col2 and Col3
> are its values...So my question is - is it possible to have certain
> values from Col1 to be BOLD, for example i want to have the fourth and
> sixth row value for Col1 to be BOLD text...
> THNX!
>|||On Aug 16, 3:07 am, ApeX <jkdmaste...@.hotmail.com> wrote:
> hi there, i have question..i have a table which i fill with data form
> a database...
> Col1 Col2 Col3
> ---
> =Fields!.. =Fields!... =Fields!
> Col1 is filled with some text and has like 15 rows, and Col2 and Col3
> are its values...So my question is - is it possible to have certain
> values from Col1 to be BOLD, for example i want to have the fourth and
> sixth row value for Col1 to be BOLD text...
> THNX!
Try inserting this expression into the FontWeight property for the
cell you want:
=IIF(RowNumber(nothing) = 4 or RowNumber(nothing) = 6, "Bold",
"Normal")
That should work
toolman|||Your not going to be able to do it particularly gracefully if there's no
logic behind the decision.
What you can do is us a custom code block and put an expression on the
FontWeight property of yuor column.
Public Function GetFontWeight( _
ByVal columnValue As String) As String
If columnValue = "Col1" Or columnValue = "Col2 Then Return "Bold"
Return "Normal"
End Function
Expression on FontWeight property:
=Code.GetFontWeight(Fields!YourColumn.Value)
Joe
"ApeX" wrote:
> hi there, i have question..i have a table which i fill with data form
> a database...
> Col1 Col2 Col3
> ---
> =Fields!.. =Fields!... =Fields!
>
> Col1 is filled with some text and has like 15 rows, and Col2 and Col3
> are its values...So my question is - is it possible to have certain
> values from Col1 to be BOLD, for example i want to have the fourth and
> sixth row value for Col1 to be BOLD text...
> THNX!
>|||To follow up with what Joe said, if you have logic that determines which rows
you want bold it is possible. Simply put that logic in the FontWeight
property of the cell (either using the custom code joe suggested or a simple
IIF statement). You will, however, have to bold the entire contents of that
cell. You won't be able to just bold certain words (wasn't sure if this was
your question).
Hope this helps...
"Joe" wrote:
> Your not going to be able to do it particularly gracefully if there's no
> logic behind the decision.
> What you can do is us a custom code block and put an expression on the
> FontWeight property of yuor column.
> Public Function GetFontWeight( _
> ByVal columnValue As String) As String
> If columnValue = "Col1" Or columnValue = "Col2 Then Return "Bold"
> Return "Normal"
> End Function
> Expression on FontWeight property:
> =Code.GetFontWeight(Fields!YourColumn.Value)
> Joe
> "ApeX" wrote:
> > hi there, i have question..i have a table which i fill with data form
> > a database...
> >
> > Col1 Col2 Col3
> > ---
> > =Fields!.. =Fields!... =Fields!
> >
> >
> > Col1 is filled with some text and has like 15 rows, and Col2 and Col3
> > are its values...So my question is - is it possible to have certain
> > values from Col1 to be BOLD, for example i want to have the fourth and
> > sixth row value for Col1 to be BOLD text...
> >
> > THNX!
> >
> >
Monday, March 12, 2012
Make a horizontal table into a vertical table
Hi All,
Any assistance would be greatly appreciated.
I have a current table which I create on a regular basis from a text file with a layout similar to this:
Type Policy # Amount Rider 1 Amt Rider 2 Amt
B 1112H 24.34 12 12.34
This text file is brought into a staging table with each field (even the amount field) as a varchar (12). I then assign types in a later step in my DTS package.
What I need to do is stack the riders under each policy so for each policy where there is a rider, there is a new row for every rider.
So in the example I've given, there would be 2 additional rows for the original first row since there are two riders.
Type Policy # Amount
B 1112H 24.34
R1 1112H 12
R2 1112H 12.34
I plan on doing this by first creating a table with just the Type, Policy #, and Amt fields, and then using a series of insert queries where I take the rider (if there is one) and append it onto the table.
However, I'm getting the following error message when I try:
Server: Msg 213, Level 16, State 4, Line 1
Insert Error: Column name or number of supplied values does not match table definition.
Basically, it wouldn't let me put an 'R1' in the Type column.
How can I get this to work!?!?
Thanks in advance for your helpIf the number of rider columns is constant, you can use a Union query like this:
Insert into DESTINATIONTABLE (Type, [Policy #], Amount)
Select [Type], [Policy #], [Amount Rider 1] as Amount from SOURCETABLE where [Amount Rider 1] is not null
UNION
Select [Type], [Policy #], [Amount Rider 2] as Amount from SOURCETABLE where [Amount Rider 2] is not null
UNION
.
.
.
etc|||I can't get past the first INSERT statement for the first rider.
I'm still getting this error message:
Server: Msg 213, Level 16, State 5, Line 1
Insert Error: Column name or number of supplied values does not match table definition.
I have the same number of columns, the data types shouldn't be an issue. I'm at a stand still!|||It's probably something simple, like a missing comma that is causing the compiler to miscount the columns.
And the datatypes may be an issue. Double check them.
If you want more help, post the layout of your tables (DDL code is best), and the SQL you are trying to run.|||Wow blindman, you are a genius, and I'm a big retarded idiot. Yup, stoopid mistake. Importing literally a hundred columns, and one of them was missing a comma. Had to search through the bowels of my dts package, but finally found it. Thanks very much for your help.
Oh, and I didn't need to use the UNION in mine. Just INSERT INTO worked. Once I located that rogue comma, of course.|||Genius? How do you think I knew what your problem was?
"An expert is a man who has made all the mistakes which can be made in a very narrow field."
-Niels Bohr|||Whatever you say... I still think you have at least above average intelligence. ;)
Any assistance would be greatly appreciated.
I have a current table which I create on a regular basis from a text file with a layout similar to this:
Type Policy # Amount Rider 1 Amt Rider 2 Amt
B 1112H 24.34 12 12.34
This text file is brought into a staging table with each field (even the amount field) as a varchar (12). I then assign types in a later step in my DTS package.
What I need to do is stack the riders under each policy so for each policy where there is a rider, there is a new row for every rider.
So in the example I've given, there would be 2 additional rows for the original first row since there are two riders.
Type Policy # Amount
B 1112H 24.34
R1 1112H 12
R2 1112H 12.34
I plan on doing this by first creating a table with just the Type, Policy #, and Amt fields, and then using a series of insert queries where I take the rider (if there is one) and append it onto the table.
However, I'm getting the following error message when I try:
Server: Msg 213, Level 16, State 4, Line 1
Insert Error: Column name or number of supplied values does not match table definition.
Basically, it wouldn't let me put an 'R1' in the Type column.
How can I get this to work!?!?
Thanks in advance for your helpIf the number of rider columns is constant, you can use a Union query like this:
Insert into DESTINATIONTABLE (Type, [Policy #], Amount)
Select [Type], [Policy #], [Amount Rider 1] as Amount from SOURCETABLE where [Amount Rider 1] is not null
UNION
Select [Type], [Policy #], [Amount Rider 2] as Amount from SOURCETABLE where [Amount Rider 2] is not null
UNION
.
.
.
etc|||I can't get past the first INSERT statement for the first rider.
I'm still getting this error message:
Server: Msg 213, Level 16, State 5, Line 1
Insert Error: Column name or number of supplied values does not match table definition.
I have the same number of columns, the data types shouldn't be an issue. I'm at a stand still!|||It's probably something simple, like a missing comma that is causing the compiler to miscount the columns.
And the datatypes may be an issue. Double check them.
If you want more help, post the layout of your tables (DDL code is best), and the SQL you are trying to run.|||Wow blindman, you are a genius, and I'm a big retarded idiot. Yup, stoopid mistake. Importing literally a hundred columns, and one of them was missing a comma. Had to search through the bowels of my dts package, but finally found it. Thanks very much for your help.
Oh, and I didn't need to use the UNION in mine. Just INSERT INTO worked. Once I located that rogue comma, of course.|||Genius? How do you think I knew what your problem was?
"An expert is a man who has made all the mistakes which can be made in a very narrow field."
-Niels Bohr|||Whatever you say... I still think you have at least above average intelligence. ;)
Subscribe to:
Posts (Atom)