Format data?

1. What format should i use to change data from '32560' to this '32,560' ?
2. How can i pull data for previous 13 months?"GGill" wrote:
> 1. What format should i use to change data from '32560' to this '32,560' ?
[ user FormatCurrency in the expression ]
> 2. How can i pull data for previous 13 months?
[You can do this like where yourdatecolumn > DATEADD(month, -13,
getdate())] you can do this in different ways also..|||1. If i use FormatCurrency then it will show data with '$32,560.00'. i need
to view like this '32,560'
I used Format - 'N' and it shows '32,560.00' . How to change decimal to 0 so
i will not see last two 0's?
2. In my report i need to change format to E_Month field;
from this data '200502' change format to this '02/2005' and then i need to
show previous 13 months?
"Sriman" wrote:
> "GGill" wrote:
> > 1. What format should i use to change data from '32560' to this '32,560' ?
> [ user FormatCurrency in the expression ]
> >
> > 2. How can i pull data for previous 13 months?
> [You can do this like where yourdatecolumn > DATEADD(month, -13,
> getdate())] you can do this in different ways also..|||Ignore question #1, I fixed that problem.
I used Format - N0.
I still have problem with month format question #2 '
"GGill" wrote:
> 1. If i use FormatCurrency then it will show data with '$32,560.00'. i need
> to view like this '32,560'
> I used Format - 'N' and it shows '32,560.00' . How to change decimal to 0 so
> i will not see last two 0's?
> 2. In my report i need to change format to E_Month field;
> from this data '200502' change format to this '02/2005' and then i need to
> show previous 13 months?
> "Sriman" wrote:
> > "GGill" wrote:
> >
> > > 1. What format should i use to change data from '32560' to this '32,560' ?
> > [ user FormatCurrency in the expression ]
> > >
> > > 2. How can i pull data for previous 13 months?
> > [You can do this like where yourdatecolumn > DATEADD(month, -13,
> > getdate())] you can do this in different ways also..|||I'm not sure what you mean when you say 'Show the 13 previous months', but if
your trying to figure out what 13 months prior would be, just use the DateAdd
function
DateAdd(m,-13,E_Date)
You may require changing "E_Month" into a date like:
E_Date=Right(EMonth,2) & "/01/" & Left(EMonth,4)
"GGill" wrote:
> Ignore question #1, I fixed that problem.
> I used Format - N0.
> I still have problem with month format question #2 '
> "GGill" wrote:
> > 1. If i use FormatCurrency then it will show data with '$32,560.00'. i need
> > to view like this '32,560'
> > I used Format - 'N' and it shows '32,560.00' . How to change decimal to 0 so
> > i will not see last two 0's?
> > 2. In my report i need to change format to E_Month field;
> > from this data '200502' change format to this '02/2005' and then i need to
> > show previous 13 months?
> >
> > "Sriman" wrote:
> >
> > > "GGill" wrote:
> > >
> > > > 1. What format should i use to change data from '32560' to this '32,560' ?
> > > [ user FormatCurrency in the expression ]
> > > >
> > > > 2. How can i pull data for previous 13 months?
> > > [You can do this like where yourdatecolumn > DATEADD(month, -13,
> > > getdate())] you can do this in different ways also..|||Where should i add this in my report
E_Date=Right(EMonth,2) & "/01/" & Left(EMonth,4)
"Michael C" wrote:
> I'm not sure what you mean when you say 'Show the 13 previous months', but if
> your trying to figure out what 13 months prior would be, just use the DateAdd
> function
> DateAdd(m,-13,E_Date)
> You may require changing "E_Month" into a date like:
> E_Date=Right(EMonth,2) & "/01/" & Left(EMonth,4)
> "GGill" wrote:
> > Ignore question #1, I fixed that problem.
> > I used Format - N0.
> >
> > I still have problem with month format question #2 '
> >
> > "GGill" wrote:
> >
> > > 1. If i use FormatCurrency then it will show data with '$32,560.00'. i need
> > > to view like this '32,560'
> > > I used Format - 'N' and it shows '32,560.00' . How to change decimal to 0 so
> > > i will not see last two 0's?
> > > 2. In my report i need to change format to E_Month field;
> > > from this data '200502' change format to this '02/2005' and then i need to
> > > show previous 13 months?
> > >
> > > "Sriman" wrote:
> > >
> > > > "GGill" wrote:
> > > >
> > > > > 1. What format should i use to change data from '32560' to this '32,560' ?
> > > > [ user FormatCurrency in the expression ]
> > > > >
> > > > > 2. How can i pull data for previous 13 months?
> > > > [You can do this like where yourdatecolumn > DATEADD(month, -13,
> > > > getdate())] you can do this in different ways also..|||Thank you.
It works.
"GGill" wrote:
> Where should i add this in my report
> E_Date=Right(EMonth,2) & "/01/" & Left(EMonth,4)
>
> "Michael C" wrote:
> > I'm not sure what you mean when you say 'Show the 13 previous months', but if
> > your trying to figure out what 13 months prior would be, just use the DateAdd
> > function
> >
> > DateAdd(m,-13,E_Date)
> >
> > You may require changing "E_Month" into a date like:
> >
> > E_Date=Right(EMonth,2) & "/01/" & Left(EMonth,4)
> >
> > "GGill" wrote:
> >
> > > Ignore question #1, I fixed that problem.
> > > I used Format - N0.
> > >
> > > I still have problem with month format question #2 '
> > >
> > > "GGill" wrote:
> > >
> > > > 1. If i use FormatCurrency then it will show data with '$32,560.00'. i need
> > > > to view like this '32,560'
> > > > I used Format - 'N' and it shows '32,560.00' . How to change decimal to 0 so
> > > > i will not see last two 0's?
> > > > 2. In my report i need to change format to E_Month field;
> > > > from this data '200502' change format to this '02/2005' and then i need to
> > > > show previous 13 months?
> > > >
> > > > "Sriman" wrote:
> > > >
> > > > > "GGill" wrote:
> > > > >
> > > > > > 1. What format should i use to change data from '32560' to this '32,560' ?
> > > > > [ user FormatCurrency in the expression ]
> > > > > >
> > > > > > 2. How can i pull data for previous 13 months?
> > > > > [You can do this like where yourdatecolumn > DATEADD(month, -13,
> > > > > getdate())] you can do this in different ways also..|||Well, that really depends on your report, but if your trying to pull all the
data from the E_Month and back 13 months then I would add it to your dataset
(SQL).
SELECT *
FROM MySource
WHERE
E_Month BETWEEN
CDate(Right(EMonth,2) & "/01/" & Left(EMonth,4))
AND
DateAdd(m,-13,Right(EMonth,2) & "/01/" &
Left(EMonth,4))
Micahel
"GGill" wrote:
> Where should i add this in my report
> E_Date=Right(EMonth,2) & "/01/" & Left(EMonth,4)
>
> "Michael C" wrote:
> > I'm not sure what you mean when you say 'Show the 13 previous months', but if
> > your trying to figure out what 13 months prior would be, just use the DateAdd
> > function
> >
> > DateAdd(m,-13,E_Date)
> >
> > You may require changing "E_Month" into a date like:
> >
> > E_Date=Right(EMonth,2) & "/01/" & Left(EMonth,4)
> >
> > "GGill" wrote:
> >
> > > Ignore question #1, I fixed that problem.
> > > I used Format - N0.
> > >
> > > I still have problem with month format question #2 '
> > >
> > > "GGill" wrote:
> > >
> > > > 1. If i use FormatCurrency then it will show data with '$32,560.00'. i need
> > > > to view like this '32,560'
> > > > I used Format - 'N' and it shows '32,560.00' . How to change decimal to 0 so
> > > > i will not see last two 0's?
> > > > 2. In my report i need to change format to E_Month field;
> > > > from this data '200502' change format to this '02/2005' and then i need to
> > > > show previous 13 months?
> > > >
> > > > "Sriman" wrote:
> > > >
> > > > > "GGill" wrote:
> > > > >
> > > > > > 1. What format should i use to change data from '32560' to this '32,560' ?
> > > > > [ user FormatCurrency in the expression ]
> > > > > >
> > > > > > 2. How can i pull data for previous 13 months?
> > > > > [You can do this like where yourdatecolumn > DATEADD(month, -13,
> > > > > getdate())] you can do this in different ways also..|||Thank you.
Works great.
"Michael C" wrote:
> Well, that really depends on your report, but if your trying to pull all the
> data from the E_Month and back 13 months then I would add it to your dataset
> (SQL).
> SELECT *
> FROM MySource
> WHERE
> E_Month BETWEEN
> CDate(Right(EMonth,2) & "/01/" & Left(EMonth,4))
> AND
> DateAdd(m,-13,Right(EMonth,2) & "/01/" &
> Left(EMonth,4))
> Micahel
>
> "GGill" wrote:
> > Where should i add this in my report
> >
> > E_Date=Right(EMonth,2) & "/01/" & Left(EMonth,4)
> >
> >
> > "Michael C" wrote:
> >
> > > I'm not sure what you mean when you say 'Show the 13 previous months', but if
> > > your trying to figure out what 13 months prior would be, just use the DateAdd
> > > function
> > >
> > > DateAdd(m,-13,E_Date)
> > >
> > > You may require changing "E_Month" into a date like:
> > >
> > > E_Date=Right(EMonth,2) & "/01/" & Left(EMonth,4)
> > >
> > > "GGill" wrote:
> > >
> > > > Ignore question #1, I fixed that problem.
> > > > I used Format - N0.
> > > >
> > > > I still have problem with month format question #2 '
> > > >
> > > > "GGill" wrote:
> > > >
> > > > > 1. If i use FormatCurrency then it will show data with '$32,560.00'. i need
> > > > > to view like this '32,560'
> > > > > I used Format - 'N' and it shows '32,560.00' . How to change decimal to 0 so
> > > > > i will not see last two 0's?
> > > > > 2. In my report i need to change format to E_Month field;
> > > > > from this data '200502' change format to this '02/2005' and then i need to
> > > > > show previous 13 months?
> > > > >
> > > > > "Sriman" wrote:
> > > > >
> > > > > > "GGill" wrote:
> > > > > >
> > > > > > > 1. What format should i use to change data from '32560' to this '32,560' ?
> > > > > > [ user FormatCurrency in the expression ]
> > > > > > >
> > > > > > > 2. How can i pull data for previous 13 months?
> > > > > > [You can do this like where yourdatecolumn > DATEADD(month, -13,
> > > > > > getdate())] you can do this in different ways also..|||My pleasure, glad I could help.
Michael
"GGill" wrote:
> Thank you.
> Works great.
> "Michael C" wrote:
> > Well, that really depends on your report, but if your trying to pull all the
> > data from the E_Month and back 13 months then I would add it to your dataset
> > (SQL).
> >
> > SELECT *
> > FROM MySource
> > WHERE
> > E_Month BETWEEN
> > CDate(Right(EMonth,2) & "/01/" & Left(EMonth,4))
> > AND
> > DateAdd(m,-13,Right(EMonth,2) & "/01/" &
> > Left(EMonth,4))
> >
> > Micahel
> >
> >
> > "GGill" wrote:
> >
> > > Where should i add this in my report
> > >
> > > E_Date=Right(EMonth,2) & "/01/" & Left(EMonth,4)
> > >
> > >
> > > "Michael C" wrote:
> > >
> > > > I'm not sure what you mean when you say 'Show the 13 previous months', but if
> > > > your trying to figure out what 13 months prior would be, just use the DateAdd
> > > > function
> > > >
> > > > DateAdd(m,-13,E_Date)
> > > >
> > > > You may require changing "E_Month" into a date like:
> > > >
> > > > E_Date=Right(EMonth,2) & "/01/" & Left(EMonth,4)
> > > >
> > > > "GGill" wrote:
> > > >
> > > > > Ignore question #1, I fixed that problem.
> > > > > I used Format - N0.
> > > > >
> > > > > I still have problem with month format question #2 '
> > > > >
> > > > > "GGill" wrote:
> > > > >
> > > > > > 1. If i use FormatCurrency then it will show data with '$32,560.00'. i need
> > > > > > to view like this '32,560'
> > > > > > I used Format - 'N' and it shows '32,560.00' . How to change decimal to 0 so
> > > > > > i will not see last two 0's?
> > > > > > 2. In my report i need to change format to E_Month field;
> > > > > > from this data '200502' change format to this '02/2005' and then i need to
> > > > > > show previous 13 months?
> > > > > >
> > > > > > "Sriman" wrote:
> > > > > >
> > > > > > > "GGill" wrote:
> > > > > > >
> > > > > > > > 1. What format should i use to change data from '32560' to this '32,560' ?
> > > > > > > [ user FormatCurrency in the expression ]
> > > > > > > >
> > > > > > > > 2. How can i pull data for previous 13 months?
> > > > > > > [You can do this like where yourdatecolumn > DATEADD(month, -13,
> > > > > > > getdate())] you can do this in different ways also..|||On Jul 17, 12:56 pm, GGill <GG...@.discussions.microsoft.com> wrote:
> 1. What format should i use to change data from '32560' to this '32,560' ?
> 2. How can i pull data for previous 13 months?
1. In the Format section of the Properties window (F4), enter in:
#,0
2. If you do not want to do this in the stored procedure/query that
sources the report, you can filter the table/matrix control's data
(via: right-click the top-left of a table/matrix control -> select
Properties -> select the Filters tab) w/an expression similar to the
following:
set the Expression to something like: =Fields!SomeFieldName.Value; set
the Operator equal '>'; set the Value to: =DateAdd("m", -13, Now())
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant