Right Justify Calc field on BAQ

Yahoo Archive
1
Hi Sal,



I'm on 8.03.407 - maybe you are on a different version. I have used it
in a lot of BAQs and it works fine.



Linda



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of dciepicor
Sent: Tuesday, August 03, 2010 3:48 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Right Justify Calc field on BAQ





Hi Linda,

My Data Type is Decimal as well and i don't have double quotes in the
Format. After I made the change in the Calc field I hit the Analyze and
Test buttons the the column data didn't change. I tried a couple of
other formats but nothing worked either.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Linda Lowney" <llowney@...> wrote:
>
> Hi Sal,
>
>
>
> My Data Type is Decimal, is yours? You show double quotes around the
format in your email, did you put the quotes in the Format? Mine has no
quotes.
>
>
>
> Regards,
>
> Linda
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of dciepicor
> Sent: Tuesday, August 03, 2010 3:33 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Right Justify Calc field on BAQ
>
>
>
>
>
> Hi Linda,
>
> Thank you for your reply. So in the Format field i enter
">>>,>>>,>>9.99". I too need two decimal point as well. I tried this but
it didn't seem to work. Am I doing something wrong? Thanks again for the
Reply!!
>
> -Sal
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> , "Linda Lowney" <llowney@> wrote:
> >
> > Hi Sal,
> >
> >
> >
> > Open the calculation and set the format. Here is one that I use that
> > has two decimals. >>>,>>>,>>9.99
> >
> >
> >
> > Hth,
> >
> > Linda
> >
> >
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ]
On Behalf
> > Of dciepicor
> > Sent: Tuesday, August 03, 2010 1:17 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Right Justify Calc field on BAQ
> >
> >
> >
> >
> >
> > Hello,
> >
> > I have a BAQ that includes a Calc field. The data is returning the
> > correct figures however it is displaying Left Justified vs Right
> > Justified. Does anyone know how I can correct this? Thanks in
advance!!
> >
> > -Sal
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
2
Hello,

I have a BAQ that includes a Calc field. The data is returning the correct figures however it is displaying Left Justified vs Right Justified. Does anyone know how I can correct this? Thanks in advance!!

-Sal
3
You can take care of this in the field format of your Crystal Report.

--- In vantage@yahoogroups.com, "dciepicor" <dciepicor@...> wrote:
>
> Hello,
>
> I have a BAQ that includes a Calc field. The data is returning the correct figures however it is displaying Left Justified vs Right Justified. Does anyone know how I can correct this? Thanks in advance!!
>
> -Sal
>
4
Hi Sal,



Open the calculation and set the format. Here is one that I use that
has two decimals. >>>,>>>,>>9.99



Hth,

Linda



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of dciepicor
Sent: Tuesday, August 03, 2010 1:17 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Right Justify Calc field on BAQ





Hello,

I have a BAQ that includes a Calc field. The data is returning the
correct figures however it is displaying Left Justified vs Right
Justified. Does anyone know how I can correct this? Thanks in advance!!

-Sal





[Non-text portions of this message have been removed]
5
Hi Linda,

Thank you for your reply. So in the Format field i enter ">>>,>>>,>>9.99". I too need two decimal point as well. I tried this but it didn't seem to work. Am I doing something wrong? Thanks again for the Reply!!

-Sal



--- In vantage@yahoogroups.com, "Linda Lowney" <llowney@...> wrote:
>
> Hi Sal,
>
>
>
> Open the calculation and set the format. Here is one that I use that
> has two decimals. >>>,>>>,>>9.99
>
>
>
> Hth,
>
> Linda
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of dciepicor
> Sent: Tuesday, August 03, 2010 1:17 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Right Justify Calc field on BAQ
>
>
>
>
>
> Hello,
>
> I have a BAQ that includes a Calc field. The data is returning the
> correct figures however it is displaying Left Justified vs Right
> Justified. Does anyone know how I can correct this? Thanks in advance!!
>
> -Sal
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
6
Hi Sal,



My Data Type is Decimal, is yours? You show double quotes around the format in your email, did you put the quotes in the Format? Mine has no quotes.



Regards,

Linda



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of dciepicor
Sent: Tuesday, August 03, 2010 3:33 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Right Justify Calc field on BAQ





Hi Linda,

Thank you for your reply. So in the Format field i enter ">>>,>>>,>>9.99". I too need two decimal point as well. I tried this but it didn't seem to work. Am I doing something wrong? Thanks again for the Reply!!

-Sal

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Linda Lowney" <llowney@...> wrote:
>
> Hi Sal,
>
>
>
> Open the calculation and set the format. Here is one that I use that
> has two decimals. >>>,>>>,>>9.99
>
>
>
> Hth,
>
> Linda
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On Behalf
> Of dciepicor
> Sent: Tuesday, August 03, 2010 1:17 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Right Justify Calc field on BAQ
>
>
>
>
>
> Hello,
>
> I have a BAQ that includes a Calc field. The data is returning the
> correct figures however it is displaying Left Justified vs Right
> Justified. Does anyone know how I can correct this? Thanks in advance!!
>
> -Sal
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
7
Hi Linda,

My Data Type is Decimal as well and i don't have double quotes in the Format. After I made the change in the Calc field I hit the Analyze and Test buttons the the column data didn't change. I tried a couple of other formats but nothing worked either.

--- In vantage@yahoogroups.com, "Linda Lowney" <llowney@...> wrote:
>
> Hi Sal,
>
>
>
> My Data Type is Decimal, is yours? You show double quotes around the format in your email, did you put the quotes in the Format? Mine has no quotes.
>
>
>
> Regards,
>
> Linda
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of dciepicor
> Sent: Tuesday, August 03, 2010 3:33 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Right Justify Calc field on BAQ
>
>
>
>
>
> Hi Linda,
>
> Thank you for your reply. So in the Format field i enter ">>>,>>>,>>9.99". I too need two decimal point as well. I tried this but it didn't seem to work. Am I doing something wrong? Thanks again for the Reply!!
>
> -Sal
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Linda Lowney" <llowney@> wrote:
> >
> > Hi Sal,
> >
> >
> >
> > Open the calculation and set the format. Here is one that I use that
> > has two decimals. >>>,>>>,>>9.99
> >
> >
> >
> > Hth,
> >
> > Linda
> >
> >
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On Behalf
> > Of dciepicor
> > Sent: Tuesday, August 03, 2010 1:17 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Right Justify Calc field on BAQ
> >
> >
> >
> >
> >
> > Hello,
> >
> > I have a BAQ that includes a Calc field. The data is returning the
> > correct figures however it is displaying Left Justified vs Right
> > Justified. Does anyone know how I can correct this? Thanks in advance!!
> >
> > -Sal
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>