Generate sql: font

Showing posts with label font. Show all posts

Friday, March 23, 2012

Formatting text in crystal reports

hi,
is it possible to format the size, font, color of the text displayed in the report?just right click on that text and click format text :sql

Formatting Sub Totals in a Matrix

Would some one know how to control the formatting of Matrix Sub totals, such as Border around it, background color and font etc...I can't select the grey textbox that is rendered if sub totals are chosen from the context menu for a group.

Any help will be appreciated.

If you right-click on the green triangle in the corner of the subtotal label and click properties you should be able to access the properties of the subtotal text box (I believe it is actual labeled Subtotal by default).

Hope this helps,

Simone

|||I love this forum....Thanks!!!!!!

Monday, March 12, 2012

Formatted Text Data in DB

Can anyone tell me if SQL Server can store formatted text like words in
bold, italic, different font size, etc. ?
Researching and trying to find the answer to anything on microsoft sites is
impossible!
TIA
JeffThis is a multi-part message in MIME format.
--=_NextPart_000_004A_01C368C3.7A69EEA0
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
You could create a Word document and then save it as an image datatype =in a table.
-- Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com.sql
.
"Jeff Reed" <thebigvalbosky@.hotmail.com> wrote in message =news:OJwvLROaDHA.2572@.TK2MSFTNGP12.phx.gbl...
Can anyone tell me if SQL Server can store formatted text like words =in
bold, italic, different font size, etc. ?
Researching and trying to find the answer to anything on microsoft =sites is
impossible!
TIA
Jeff
--=_NextPart_000_004A_01C368C3.7A69EEA0
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =charset=3Dwindows-1252">
<META content=3D"MSHTML 6.00.2800.1226" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#c0c0c0>
<DIV><FONT size=3D2>You could create a Word document and then save it as =an image datatype in a table.</FONT></DIV>
<DIV><BR>-- <BR> Tom<BR>---<BR>Thomas A. Moreau, =BSc, PhD, MCSE, MCDBA<BR>SQL Server MVP<BR>Columnist, SQL Server Professional<BR>Toronto, ON Canada<BR><A href=3D"www.pinnaclepublishing.com=/">http://www.pinnaclepublishing.com.sql">www.pinnaclepublishing.com=
.sql</A><BR>.<BR></DIV>
<BLOCKQUOTE style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Jeff Reed" <<A =href=3D"mailto:thebigvalbosky@.hotmail.com">thebigvalbosky@.hotmail.com</A>=> wrote in message <A =href=3D"news:OJwvLROaDHA.2572@.TK2MSFTNGP12.phx.gbl">news:OJwvLROaDHA.2572=@.TK2MSFTNGP12.phx.gbl</A>...</DIV>Can anyone tell me if SQL Server can store formatted text like words =in<BR>bold, italic, different font size, etc. ?<BR><BR>Researching and trying to =find the answer to anything on microsoft sites =is<BR>impossible!<BR><BR>TIA<BR><BR>Jeff<BR><BR></BLOCKQUOTE></BODY></HTM=L>
--=_NextPart_000_004A_01C368C3.7A69EEA0--

Friday, March 9, 2012

Format the Report Manager Parameter headings

Hello,

I was wondering if it would be possible to change the font type and color of the parameter titles in Report Manager? Like can I change it in XML some sort of way...

<Value>=Parameters!ProductLang.Value</Value>

</QueryParameter>

Ex: @.StartDate is a parmeter, I'd like to change the text's font color and style to BLUE and Italics.

It is not possible to configure this in Report Manager.

You could write a custom ASP.NET page with your desired stylizations that will pass the parameters to the ReportServer.

-Chris

Sunday, February 19, 2012

format codes - font colours, background etc

can anyone point me in the direction of help and assistance in formatting
using expressions?
an example would be change font to red if negative
also to change the background colour matix when using the visibility options
many thanksDid you read this section in BOL? Among many other examples it contains an
example for formatting values red when the value is negative.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_expressions_v1_571v.asp
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"jez_uk" <nospam@.nospam.com> wrote in message
news:uwfdvy3ZEHA.3016@.tk2msftngp13.phx.gbl...
> can anyone point me in the direction of help and assistance in formatting
> using expressions?
> an example would be change font to red if negative
> also to change the background colour matix when using the visibility
options
> many thanks
>