Making the year field 2007 to a 07 instead?

Hi

In my matrix cell I have a cell with the following Expression:

=Fields!monthname.Value & " " & Fields!Year.Value

In one of my datasets I have a SELECT CAST(FCYB.cyb_yearname AS int) AS 'Year' ... amongst other things.

Now, how do I make 'Year' to say 07 instead of 2007? What is the proper way to do it? In the expression or in the SQL code?

Thanks in advanced as always

KR

Use Right(fields!Year.Value,2)|||

Thanks a lot!! Worked perfectly!!

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
>

Making only certain data show in a cell

I am building a report and would like only certain data to show in a cell.
For instance I have 8 pay codes in my select statement, but would like to
show just 4 of them in the detail section. I don't want to limit my select
statement to just the 4 because I need the other 4 in another cell of this
report. Any ideas?
Its almost like I need a where clause within my particular cell.
Thanks,
RyanAlso, I thought about using multiple data sources and create a new table, but
is there a way to link two different data sources in a report? For instance
my report is on employee id and I would need to make sure that the data from
both data sources in the row detail are for the same employee id.
"Ryan Mcbee" wrote:
> I am building a report and would like only certain data to show in a cell.
> For instance I have 8 pay codes in my select statement, but would like to
> show just 4 of them in the detail section. I don't want to limit my select
> statement to just the 4 because I need the other 4 in another cell of this
> report. Any ideas?
> Its almost like I need a where clause within my particular cell.
> Thanks,
> Ryan|||Maybe you can use Filters.
In your data properties, select tab "Filters" and configure there the values
you want to show.
Does it help?
"Ryan Mcbee" <RyanMcbee@.discussions.microsoft.com> escribió en el mensaje
news:0F3503DD-A100-47C5-B4F3-B36EE6AF8BBE@.microsoft.com...
> Also, I thought about using multiple data sources and create a new table,
> but
> is there a way to link two different data sources in a report? For
> instance
> my report is on employee id and I would need to make sure that the data
> from
> both data sources in the row detail are for the same employee id.
> "Ryan Mcbee" wrote:
>> I am building a report and would like only certain data to show in a
>> cell.
>> For instance I have 8 pay codes in my select statement, but would like to
>> show just 4 of them in the detail section. I don't want to limit my
>> select
>> statement to just the 4 because I need the other 4 in another cell of
>> this
>> report. Any ideas?
>> Its almost like I need a where clause within my particular cell.
>> Thanks,
>> Ryan|||I will give that a shot. I built some case statements in my syntax to
seperate the data better.
"Mónica" wrote:
> Maybe you can use Filters.
> In your data properties, select tab "Filters" and configure there the values
> you want to show.
> Does it help?
>
> "Ryan Mcbee" <RyanMcbee@.discussions.microsoft.com> escribió en el mensaje
> news:0F3503DD-A100-47C5-B4F3-B36EE6AF8BBE@.microsoft.com...
> > Also, I thought about using multiple data sources and create a new table,
> > but
> > is there a way to link two different data sources in a report? For
> > instance
> > my report is on employee id and I would need to make sure that the data
> > from
> > both data sources in the row detail are for the same employee id.
> >
> > "Ryan Mcbee" wrote:
> >
> >> I am building a report and would like only certain data to show in a
> >> cell.
> >> For instance I have 8 pay codes in my select statement, but would like to
> >> show just 4 of them in the detail section. I don't want to limit my
> >> select
> >> statement to just the 4 because I need the other 4 in another cell of
> >> this
> >> report. Any ideas?
> >>
> >> Its almost like I need a where clause within my particular cell.
> >>
> >> Thanks,
> >> Ryan
>
>

Making a matrix display zeroes and not blank cells

My matrix cell will only display blanks when the variable evaluates to a
zero. I need to zero to display.
I confirmed the problem is a display issue by forcing all the output to zero
as follows:
iif(1 = 1,0,Fields!MyField.Value)
In case it might be applicable, I am also using a formating string on the
cell as follows:
=iif(Fields!Category.Value <> "NoShow%","###","P")
Thanks in advance for any pointers.
--
John ShahanI solved it by modifying the formatting as follows:
=iif(Fields!Category.Value <> "NoShow%","##0","P")
John Shahan
"jp" wrote:
> My matrix cell will only display blanks when the variable evaluates to a
> zero. I need to zero to display.
> I confirmed the problem is a display issue by forcing all the output to zero
> as follows:
> iif(1 = 1,0,Fields!MyField.Value)
> In case it might be applicable, I am also using a formating string on the
> cell as follows:
> =iif(Fields!Category.Value <> "NoShow%","###","P")
> Thanks in advance for any pointers.
> --
> John Shahansql

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!
> >
> >