Create matrix in report (1 Viewer)

JessicaVdb · Jul 4, 2017

Hi everyone

I'm trying to make a matrix in a report. The heats and rows have to change all the time. This is a problem in a report, because the rows can chage, but the heats don't.

I have tried making it with a crossquery. But I need to change thing in the heats, and this also doesn't work with this item.

Has anyone a solution for this problem?

Thanks
JessicaVdb

Ranman256 · Jul 4, 2017

1st , what is a 'heat'?
If you want a crosstab query, you found that not all data shows each time.
so make a 'report' table that has all possible outcomes,
then your crosstab query is appended to the tReport table.
This can be done with N queries,...1 for every column. Missing data is ignored.

isladogs · Jul 4, 2017

You can specify headers for crosstab reports.
This means the same headers are shown each time even if there is no data

e.g. column headers Jan; Feb; Mar etc

JessicaVdb · Jul 4, 2017

ridders said:
You can specify headers for crosstab reports.
This means the same headers are shown each time even if there is no data

e.g. column headers Jan; Feb; Mar etc

The problem is that the headers need to change to.

JessicaVdb · Jul 4, 2017

Ranman256 said:
1st , what is a 'heat'?
If you want a crosstab query, you found that not all data shows each time.
so make a 'report' table that has all possible outcomes,
then your crosstab query is appended to the tReport table.
This can be done with N queries,...1 for every column. Missing data is ignored.

I meant head.

The rest of your post I don't understand.

isladogs · Jul 4, 2017

Actually its 'header'

The rest of your post I don't understand.

I'm assuming you mean Ranman's post ...

The problem is that the headers need to change to.

What????

Have a look at this post:
https://www.access-programmers.co.uk/forums/showthread.php?t=263759&highlight=crosstab+report+headers

JessicaVdb · Jul 4, 2017

Thanks, but this has fixed headers, mine need to change.

isladogs · Jul 4, 2017

I've posted more than one example of a dynamic crosstab report.
For example one is included in this post uploaded yesterday

https://www.access-programmers.co.uk/forums/showthread.php?t=294548

HiTechCoach · Jul 5, 2017

JessicaVdb said:
Has anyone a solution for this problem?

Thanks
JessicaVdb

JessicaVdb,

I have a solution for you.

I have been using this as a template for creating dynamic reports for over 10 years now:

Dynamic Report based on a Crosstab query

Create a crosstab report with dynamic column headings. This example is based on this Microsoft KB article: How to create a dynamic crosstab report in Access 2002

Create matrix in report (1 Viewer)

JessicaVdb

Registered User.

Ranman256

Well-known member

isladogs

MVP / VIP

JessicaVdb

Registered User.

JessicaVdb

Registered User.

isladogs

MVP / VIP

JessicaVdb

Registered User.

isladogs

MVP / VIP

HiTechCoach

Well-known member

Similar threads

Users who are viewing this thread