If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Corsstab Report Headings
I have seventeen regions that represent sales areas around the country. I
have all seventeen regions listed as column headings in the crosstab query so they show in the order I would like. If one of the regions is "null" the region does not display in the query, which is great. Because the query is further filtered by dates, I usually get only nine or ten regions with numbers in them. Here is the problem: how do I get only those nine or ten regions to display on a report? If I put a text box in the report for all seventeen regions, all of them will show up and only nine or ten will have numbers in them and I will need a piece of paper larger than fourteen inches. The crosstab seems to have a lot of flexability, but getting that dynamic information into a static report appears to be difficult. Any help on this would be greatly appreciated. -- Michael Conroy Stamford, CT |
#2
|
|||
|
|||
Corsstab Report Headings
I would use the solution found in the Crosstab download sample at
http://www.rogersaccesslibrary.com/O...p#Hookom,Duane. This solution accomodates any number of columns. -- Duane Hookom Microsoft Access MVP "Michael Conroy" wrote: I have seventeen regions that represent sales areas around the country. I have all seventeen regions listed as column headings in the crosstab query so they show in the order I would like. If one of the regions is "null" the region does not display in the query, which is great. Because the query is further filtered by dates, I usually get only nine or ten regions with numbers in them. Here is the problem: how do I get only those nine or ten regions to display on a report? If I put a text box in the report for all seventeen regions, all of them will show up and only nine or ten will have numbers in them and I will need a piece of paper larger than fourteen inches. The crosstab seems to have a lot of flexability, but getting that dynamic information into a static report appears to be difficult. Any help on this would be greatly appreciated. -- Michael Conroy Stamford, CT |
#3
|
|||
|
|||
Corsstab Report Headings
Thanks, Duane, I will look into alias headings. I was hoping for some way to
allow columns/headings to shrink, like detail area can, but I guess that feature is not there yet. -- Michael Conroy Stamford, CT "Duane Hookom" wrote: I would use the solution found in the Crosstab download sample at http://www.rogersaccesslibrary.com/O...p#Hookom,Duane. This solution accomodates any number of columns. -- Duane Hookom Microsoft Access MVP "Michael Conroy" wrote: I have seventeen regions that represent sales areas around the country. I have all seventeen regions listed as column headings in the crosstab query so they show in the order I would like. If one of the regions is "null" the region does not display in the query, which is great. Because the query is further filtered by dates, I usually get only nine or ten regions with numbers in them. Here is the problem: how do I get only those nine or ten regions to display on a report? If I put a text box in the report for all seventeen regions, all of them will show up and only nine or ten will have numbers in them and I will need a piece of paper larger than fourteen inches. The crosstab seems to have a lot of flexability, but getting that dynamic information into a static report appears to be difficult. Any help on this would be greatly appreciated. -- Michael Conroy Stamford, CT |
Thread Tools | |
Display Modes | |
|
|