data table display in a report

[RB]

I have created a report that shows a chart, and the chart
displays the data table. When I view the report in design
view, the data table shows up with currency data type
(which is what I want), but when I view the report in
print preview mode, the data table loses the currency data
type and just shows the data as numbers in general format.
I'm not sure why this is happening. I cannot format the
fields on the chart because the chart is considered an
OLEUnbound Object on the report. Every place this data is
found in the database it is formatted as currency. Any
help on getting it to display and print as currecy format
in my report?

Here's the SQL statement that creates the underlying
crosstab query:

PARAMETERS [Forms]![DateRangeForm]![StartDate] DateTime,
[Forms]![DateRangeForm]![EndDate] DateTime;
TRANSFORM Sum([ChartQuery-
ValueOfIssuedQuotations].SumOfExtPrice) AS
SumOfSumOfExtPrice
SELECT (Format([Issued],"mmm"" '""yy")) AS Expr1 FROM
[ChartQuery-ValueOfIssuedQuotations]
GROUP BY (Year([Issued])*12+Month([Issued])-1), (Format
([Issued],"mmm"" '""yy"))
PIVOT [ChartQuery-ValueOfIssuedQuotations].Status;

I think the problem is that SumOfSumOfExtPrice is not in
currency format. Any way to fix this?

Thanks,
RB

 

[Steve Schapel]

RB,

I have not tested this, but if your "diagnosis" is correct, my
top-of-the-head suggestion is to try...
TRANSFORM
FormatCurrency(Sum([ChartQuery-ValueOfIssuedQuotations].SumOfExtPrice))
AS SumOfSumOfExtPrice

- Steve Schapel, Microsoft Access MVP

 

[RB]

That worked great! Thanks for the help!

RB

-----Original Message-----
RB,

I have not tested this, but if your "diagnosis" is correct, my
top-of-the-head suggestion is to try...
TRANSFORM
FormatCurrency(Sum([ChartQuery- ValueOfIssuedQuotations].SumOfExtPrice))
AS SumOfSumOfExtPrice

- Steve Schapel, Microsoft Access MVP

I have created a report that shows a chart, and the chart
displays the data table. When I view the report in design
view, the data table shows up with currency data type
(which is what I want), but when I view the report in
print preview mode, the data table loses the currency data
type and just shows the data as numbers in general format.
I'm not sure why this is happening. I cannot format the
fields on the chart because the chart is considered an
OLEUnbound Object on the report. Every place this data is
found in the database it is formatted as currency. Any
help on getting it to display and print as currecy format
in my report?

Here's the SQL statement that creates the underlying
crosstab query:

PARAMETERS [Forms]![DateRangeForm]![StartDate] DateTime,
[Forms]![DateRangeForm]![EndDate] DateTime;
TRANSFORM Sum([ChartQuery-
ValueOfIssuedQuotations].SumOfExtPrice) AS
SumOfSumOfExtPrice
SELECT (Format([Issued],"mmm"" '""yy")) AS Expr1 FROM
[ChartQuery-ValueOfIssuedQuotations]
GROUP BY (Year([Issued])*12+Month([Issued])-1), (Format
([Issued],"mmm"" '""yy"))
PIVOT [ChartQuery-ValueOfIssuedQuotations].Status;

I think the problem is that SumOfSumOfExtPrice is not in
currency format. Any way to fix this?

Thanks,
RB

.