Message "The selected data source does not have any content available" when trying to create new report in Report Builder

Robert Phillip

Hello,

I am having trouble creating a new Report Builder report in Sharepoint. I am running Sharepoint Server 2007 and SQL Server 2005 Enterprise Edition on Windows Server 2003. I created a database with one table and imported data into the table. I added a report library to a Sharepoint site and added a data source that refers to my SQL database. I then added a Report Builder Model that refers to the data source I created. When I go to create a new Report Builder report I get this message when I select my data source:

"The selected data source does not have any content available"

I did the same thing with the AdventureWorks sample database and it worked fine. Any help would be appreciated.

Thanks,
Rob

Jconsult

sun07

rote

Rob it could be a permission issue.Try making sure access to the DB is right.
You can try using sql profiler and try and see what its doing

Hope that helps

Patrick

a1pro

I am having the same problem.

I guess it is something to do with the way the DB is set up. I'm guessing that simply having a DB with a single table will not do.

Try creating a DB with a few tables and some sort of relationship between them.

I used an old sql script to create a northwing example DB and it works again, just like for Adventure Works

Just my two cents.

RajuKatta

Set Logical Primary key for each view under Data Source view folder in your project. You can acheive this by opening data source view in design mode and right click on column/columns that you can make as keys for your view.

Hope this helps

Regards

Raju