Reports based on CrossTab Queries

  • Thread starter Thread starter PSIAccess
  • Start date Start date
P

PSIAccess

Hi,

I have left a reply post to a previously answered
question but am not sure that my additional question will
be seen so I would like to ask the question here again...

I have the same problem with adding specific Column
Headings to my crosstab. I can't seem to figure out
how to make the changes to the design of the Cross Tab
query. I am in design mode for the crosstab query and the
second item in the grid is the "Column Heading" data.
Currently it says "BRegion" as the field name and in the
Tables name it says "Advisor" and in the Total row it
says "Group By" and lastly the CrossTab row says "Column
Heading". With that said I tried putting in the Field
name row "West", "East", "Central" but it would error. I
then tried Region: "West", "East", "Central" but it too
errored. Then I tried East, West, Central and that too
failed miserably. Can you help out by giving some more
detail on how to make this work. I'm probably missing
something very obvious but today it isn't so obvious to
me!

Thanks in advance for anyone's help!
 
I assume you want to enter the regions in the Column Headings "Property" of
the crosstab. Select View|Properties to find this query property.
 
I got it!! I got it!!!

Oh I have to stop taking the Nighttime Cold medication
during the day! Thanks for filling in the details for me!
 
Back
Top