How to create report from Pivot Table View of Union Query?

[hongluen via AccessMonster.com]

Hi all,

I have create a Union ALL Query. I want to generate a report from it.
The Pivot Table View of this Union Query shows exactly what I want (having
Row Heading, Column Heading and Detailed Data), so how can I make it as a
Report?

I have tried to create new report, but there is no options of making a pivot
table
(something like Crosstab Query and Pivot Table View of the Union Query).

Also tried to export to Excel, but it shows only count of records.
I want all detailed records.

Thank you.

 

[Guest]

Have you tried creating a crosstab query and then a report based on the
crosstab? There are a couple solutions available for created reports from
crosstabs.

 

[hongluen via AccessMonster.com]

Hi Duane,

I tried to create a crosstab query, but it allows to show only the First OR
the Last records.
That is NOT what I want. I want to show all records (detailed data).
Therefore, I did not generate report from the crosstab query.

In other words, if the crosstab query can show ALL records instead of count,
sum, and average, etc,
I can be able to make the crosstab query from the Union ALL (source datatable)
and then create report from this crosstab query. Is that correct?

If the crosstab query cannot show all records,
can I create report based on the Pivot Table View of the Union ALL query?
I want to have Row Heading, Column Heading and then detailed data in the
print layout.

Thank you very much for your advice.

Hong

Have you tried creating a crosstab query and then a report based on the
crosstab? There are a couple solutions available for created reports from
crosstabs.

Hi all,

[quoted text clipped - 11 lines]

Thank you.

 

[Guest]

There is a generic concatenate function that can be used as the Value in a
crosstab at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. On the
same page is a sample download for several crosstab reports.
--
Duane Hookom
Microsoft Access MVP

Hi Duane,

I tried to create a crosstab query, but it allows to show only the First OR
the Last records.
That is NOT what I want. I want to show all records (detailed data).
Therefore, I did not generate report from the crosstab query.

In other words, if the crosstab query can show ALL records instead of count,
sum, and average, etc,
I can be able to make the crosstab query from the Union ALL (source datatable)
and then create report from this crosstab query. Is that correct?

If the crosstab query cannot show all records,
can I create report based on the Pivot Table View of the Union ALL query?
I want to have Row Heading, Column Heading and then detailed data in the
print layout.

Thank you very much for your advice.

Hong

Have you tried creating a crosstab query and then a report based on the
crosstab? There are a couple solutions available for created reports from
crosstabs.

Hi all,

[quoted text clipped - 11 lines]

Thank you.