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

How to Show Crosstab Field (<>) in Report

P: 1
I have a crosstab query like
Expand|Select|Wrap|Line Numbers
  1. TRANSFORM Count(Trans_tbl_dom.consumer_no) AS CountOfconsumer_no1
  2. SELECT Q_Img_Summary_code2_dom_1.Area, Q_Img_Summary_code2_dom_1.book, Q_Img_Summary_code2_dom_1.CountOfconsumer_no AS [Total Customers], Q_Img_summary_code2_dom_2.[Accurate / Only index], Q_Img_summary_code2_dom_2.[No image]
  3. FROM Trans_tbl_dom INNER JOIN (Q_Img_Summary_code2_dom_1 INNER JOIN Q_Img_summary_code2_dom_2 ON (Q_Img_Summary_code2_dom_1.book = Q_Img_summary_code2_dom_2.book) AND (Q_Img_Summary_code2_dom_1.Area = Q_Img_summary_code2_dom_2.Area)) ON (Trans_tbl_dom.book = Q_Img_summary_code2_dom_2.book) AND (Trans_tbl_dom.Area = Q_Img_summary_code2_dom_2.Area)
  4. WHERE (((Trans_tbl_dom.Pic_status)=8))
  5. GROUP BY Q_Img_Summary_code2_dom_1.Area, Q_Img_Summary_code2_dom_1.book, Q_Img_Summary_code2_dom_1.CountOfconsumer_no, Q_Img_summary_code2_dom_2.[Accurate / Only index], Q_Img_summary_code2_dom_2.[No image], Trans_tbl_dom.Pic_status
  6. PIVOT Trans_tbl_dom.[2nd_code];
It shows a field with heading <> which has null data.

but when I use "Column Heading" in property sheet what heading should I to use?
2 Days Ago #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,487
I'm sorry. I suspect I don't understand what you mean. It seems like you're asking what you want to see it as in your query when displayed. Obviously we couldn't have an opinion on that.

Perhaps it would be a good idea for you to explain your requirement more clearly. It would help to understand which object (Report, Section, Control, etc.) the property pane is showing at the point you're asking about.
1 Days ago #2

Post your reply

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