By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,829 Members | 670 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,829 IT Pros & Developers. It's quick & easy.

How to Limit dynamic column heading in cross tab query

Jerry Maiapu
100+
P: 259
I know that you can limit a row by using the Top 5 clause etc..in a select query but is it possible to limit the heading in a cross tab query? The column haeding is dynamic ie..column will change so if I limit my heading to first 5 columns then the 5 column names will change every time a data change takes place in the source table....I do not want to specify names of columns..in the properties as this will not serve my purpose..

I have been cracking my head around thses for 3 days and nothing forth coming..I know that someone out there smarter and can work around these problem.

Thank you!
May 3 '12 #1

✓ answered by Rabbit

Use a subquery to select top 5 distinct and then join that to the original query.

Share this Question
Share on Google+
2 Replies


Rabbit
Expert Mod 10K+
P: 12,357
Use a subquery to select top 5 distinct and then join that to the original query.
May 3 '12 #2

Jerry Maiapu
100+
P: 259
Thanks! Thought of that too..but something happened that I cannot recall now. I'll try that out and get back.
May 4 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.