September 28, 2010 at 10:41 am
Hello,
In SQL Server 2005 SSRS, there are 3 tabs Data, Layout, and Preview. But, in SQL Server 2008 R2 Express, I, ONLY, see Design and Preview tabs. Where did the Data tab go? How do I get that in Express edition? Yur help is appreciated. Thanks in advance.
September 28, 2010 at 11:00 am
I am not sure about Express, but the data has been moved to a tab that typically lives on the left side of the screen right next to the toolbox. The tab is named "Report Data."
If you don't see it, go to View >> Report Data.
September 28, 2010 at 11:07 am
Thank you Daniel for your prompt reply. Yes, I do see the Report Data menu on the left panel of the page which to me is same as what we called 'Datasets' in 2005. But, what I am looking for is how to see the T-SQL codes that runs based on the Datasets defined for the reports. And, I am using Express ed. and I am NOT seeing that Data (at least that is what we called in 2005) in 2008 R2 Express. Any idea? I appreciate you getting back to me. Thanks!
September 28, 2010 at 11:24 am
Check this screenshot.
I'm using full VS 2008 pro, but you should still get that menu in express.
September 28, 2010 at 11:25 am
If you want to RUN the query, then hit the query... menu from the same popup screen.
September 28, 2010 at 11:42 am
Thank you!!!!
This makes a perfect sense. thanks for all your effort. I appreciate. Case closed.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply