Any of the modern reporting tools have much more sophisticated features than the report features in Access. Tableau and Qlikview are two popular options. While these can in principle work with an Access database it probably doesn't make sense to do that. To get the best support for reporting and ad-hoc queries use a SQL DBMS, such as SQL Server or Oracle.
I was preparing a crosstab report (sample attached), there is a limitation of 255 columns. The columns that I used here is employee number that can be exceeds.
Here is sample (attached) I prepared the desired report in Crystal Reports but now I do not know how to call/run it from MS Access ?
This is the reason why I am looking for any third party report that is compatible to use with MS Access and to prepare such kind of reports.
To make a cross tab report. First I try to create a cross tab query (report will be based on this query) that display me the message that "Too many crosstab column headers"
The report that I have designed (attached previously) in Crystal Reports is based on the same data and I create a crosstab report and it worked.
Minty : I keep the employee as a column because the rows are around 45 and that can not be fixed in A4 or A3 size.
Spikepl : Because I am unable to call/run crystal report .rpt report through VBA after plenty googling. This is the only reason that I am looking for other tool.
Row labels repeat on every page with next employee numbers as shown in attachment. The way you suggest to email a spreadsheet, I have did the same thing last time with employee numbers as a row, and then it is transposed using excel.
But Business need the way that the employee must be in column and row labels must be repeated. This is the reason why I am trying to do it.
spikepl: Crosstab query prevent me to keep employee number as column because the employee are more than 255 (If I understand your question)