Building a report on a Crosstab Query

[BishoyMaher]

Hi all ... need ur help on this.


Is it possible to build a report on a Crosstab Query?
The issue is the values on the "Column Heading" are dynamic and not fixed and if it works for a single run it will not work for other runs.
Appreciate ur involvements.

[isladogs]

Yes
If the column names are consistent e.g. Jan, Feb etc, write these in the column headers property

For a truly dynamic crosstab report, use a different approach.
Here are links to two of my example databases which include these
https://www.access-programmers.co.uk...d.php?t=294548
https://www.access-programmers.co.uk...d.php?t=297121
Suggest you study these to see how its done

[June7]

Possible but not easy. Fairly common topic. Search web and forum.

Here are some:

http://www.fmsinc.com/MicrosoftAcces...ort/index.html

https://www.accessforums.net/showthread.php?t=66751

http://blueclaw-db.com/report_dynami...stab_field.htm

http://www.access.hookom.net/Dynamic...rosstabRpt.htm