Access Report

Posted on 2013-09-26
Medium Priority
Last Modified: 2013-09-27
Hi guys,
I am trying to create a report from a parameter Cross tab query, when I use the wizard
and select the query there is no fields appearing.
Is there any example I can follow and design the query
Question by:surah79
  • 3
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 999 total points
ID: 39524852
There is no easy way to do this...

A Crosstab query creates it fields "dynamically".
But a report needs static fields...

One workaround is to try inserting the crosstab query into a subreport, then drop this sub report onto a main report, then print the main report.
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 999 total points
ID: 39524915
...In other words, create a Report, ...Then just drop the crosstab into it.

You will probably have to change the Main Reports orientation to landscape..., and adjust the size of the subreport (the crosstab query) to look presentable inside the main report, ...

But now the report only renders the current Crosstab.
In other words, the Main report itself does not have any fields to reference.  It only has a "contol" (the  subreport) to display.


LVL 120

Accepted Solution

Rey Obrero (Capricorn1) earned 501 total points
ID: 39524999

Author Closing Comment

ID: 39527034
Thanks a lot for your help
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 39527650
Yes it is always best to know more than one way to do something.


Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…

597 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question