Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 My Column Does Not Show Up In Report Designer

Author  Topic 

robin.tanner
Starting Member

1 Post

Posted - 2009-03-23 : 14:58:47
I wrote a 700 line query that uses a couple of left joins to get data, if it is available, and include it in a report. The query takes about 15 seconds to run. It runs beautifully in management studio, but when I put it into the data view in the query designer in visual studio, one of my columns that I am selecting, one that is being selected in a left outer join, is completely blank. Any ideas why this would be? Another guy I work with tried putting it in his query window and it seemed to cut the query off in the middle whenever he would paste it in. Any ideas or has anyone ever had this problem? Thanks

R_tAnNeR
   

- Advertisement -