Cannot view all the columns in Microsoft reporting (Business Intelligence studio)

Question

Dear All, I am facing weird issue I am linking ms sql reporting services with SPS, to get the data through CAML queries based on a specific view. But for some odd reason not all the columns are visible. Here is the link to steps: http://mimtiaz77.blogspot.com/2009/01/step-by-step-guide-to-create-reports.html

I am assuming that issue lies with sps (hence this forum) as other columns are visible and working correctly.

Also I noticed one thing that some of the column headings are in light grey color while others are in dark grey color – does that signify anything?. The column I am having trouble accessing is in light color.

I can send a screen shot if required, my email is [e-mail]

I will appreciate if someone can help!

Answer 1

Reporting services questions go to the Business Intelligence forum.

Moving this.


(and next time and every time in the future, please use the Question Type when posting)

---

WSS FAQ sites: http://wssv2faq.mindsharp.com and http://wssv3faq.mindsharp.com
Total list of WSS 3.0 / MOSS 2007 Books (including foreign language) http://wssv3faq.mindsharp.com/Lists/v3%20WSS%20FAQ/V%20Books.aspx

Answer 2

Check this thread to see if it is related:
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/332ce140-1e8b-4e69-b29c-60f516caf5cd

It is usually best to specify a view when querying a list versus just the list name.

---

BI and SQL Blog

Please click the Mark as Answer button if a post solves your problem!