Formatting data tables in reports with graphs

  • Thread starter Thread starter RB
  • Start date Start date
R

RB

I am trying to format a data table to display the data in
the currency format. The TRANSFORM statement I am using in
the report record source is:

TRANSFORM Sum([Quotations Value].Value) AS SumOfValue
SELECT (Format([Date Issued],"mmm"" '""yy")) AS [Month]
FROM [Quotations Value]
GROUP BY (Year([Date Issued])*12+Month([Date Issued])-1),
(Format([Date Issued],"mmm"" '""yy"))
PIVOT [Quotations Value].Status;

How can I get the values to show up as currency? In every
place but the report they show up as currency, including
the underlying query and the table that underlies that, as
well as in the data table in design view. Please help!

Thanks,
RB
 
There is no report field since it is a graph on the
report. The whole graph and data table is an image. Does
that make sense?

RB
-----Original Message-----
Any reason why you can ot format the report field?
Fons
-----Original Message-----
I am trying to format a data table to display the data in
the currency format. The TRANSFORM statement I am using in
the report record source is:

TRANSFORM Sum([Quotations Value].Value) AS SumOfValue
SELECT (Format([Date Issued],"mmm"" '""yy")) AS [Month]
FROM [Quotations Value]
GROUP BY (Year([Date Issued])*12+Month([Date Issued])- 1),
(Format([Date Issued],"mmm"" '""yy"))
PIVOT [Quotations Value].Status;

How can I get the values to show up as currency? In every
place but the report they show up as currency, including
the underlying query and the table that underlies that, as
well as in the data table in design view. Please help!

Thanks,
RB
.
Click to expand...
.
Click to expand...
 
Back
Top