Author Topic: Crosstab report  (Read 521 times)

Offline 1#griff

  • Associate
  • **
  • Posts: 4
  • Forum Citizenship: +0/-0
Crosstab report
« on: 24 Jun 2009 08:02:52 pm »
 ???

I am trying to create a crosstab report that will just show the detail information. When I drag the item over to measure area I dont want any aggregate function. I just want to show the true value thats in the database. Is this possible with a crosstab?

Offline Gollapudi

  • Gollapudi
  • Community Leader
  • *****
  • Posts: 147
  • Forum Citizenship: +11/-1
Re: Crosstab report
« Reply #1 on: 26 Jun 2009 06:22:40 pm »
Intially you should change your Query Property... "Auto Group & Summarize" to "NO", then it wont summarize any values.. will just present as how they were in ur Database.

And the other thing a crosstab will always shows Data in a 2 dimensional grid.. means when you add Year in Column and Product in Row Level.. then your measure.. will shows data for every Product in that Perticular Year...

Thanks,
Gollapudi.