Post New Web Links

The report cannot be opened because the data source associated with it is not a report model.

Posted By: Posted Date: August 26, 2010 Points: 0 Category :SharePoint

hi,

i tried to open a report i created in sql business intelligence development studio in the report builder in wss3 and it gave me this error:

Microsoft.ReportingServices.ReportBuilder.ReportModel.Report: The report 'http://servername:port#/Reports/report.rdl' cannot be opened because the data source 'http://servername:port#/DataSource Library/datasource.rsds' associated with it is not a report model.

This report was not created in Report Builder. Try opening this report in Report Designer instead.

can i fix this so i can open my reports in report builder?

thnx

View Complete Post

More Related Resource Links

MDW Disk Usage for Database Report Error - A data source has not been supplied for the data source D

Hello, On the MDW Disk Usage Collection Set report, I get the following error when I click on a database hyperlink. A data source has not been supplied for the data source DS_TraceEvents SQL profiler shows the following SQL statements are executed (I've replaced the database name with databaseX) 1. exec sp_executesql N'SELECT dtb.name AS [Name] FROM master.sys.databases AS dtb WHERE (dtb.name=@_msparam_0)',N'@_msparam_0 nvarchar(4000)',@_msparam_0=N'databaseX' this returns zero rows as databaseX does not exist on my MDW central server, but is a database on a target server (i.e. one that is being monitored and uploaded into the MDW central server). 2. USE [datatbaseX] this produces the following error: Msg 911, Level 16, State 1, Line 1 Database 'databaseX' does not exist. Make sure that the name is entered correctly. why is the report looking for the database on my server? thanks Jag Environment: MDW (Management Data Warehouse) on SQL 2008 R2

model report from two different data sources SQL server and access DB

Can we merge two model reports into one . One model report is from SQL server and another one from Access DB. How is that possible. Can you please give a idea how to do that. I need to display data from sql server as well as access DB using model report. I need to get data from two different sources like sql and oracle or SQL and access db. So can combine tables from these data sources into the DSV or model. I need to use it in a report Thanks Madhavi

Sharepoint list as Report Data Source

My current environment is Sharepoint 2007 with SSRS 2008 in Sharepoint Integrated Mode. SSRS 2008 uses trusted authentication to communicate to Sharepoint 2007. Sharepoint 2007 is configured to use NTLM authentication (configured with a domain account). My settings within Central Admin are Authentication Type: Windows IIS authentication settings: Integrated windows authentication with NTLM. My question is: Do I need to configure Sharepoint to use kerberos to use Sharepoint Lists as a Report Data Source?

Setting Local Report Data Source

I am a college professor and am updating my undergraduate database course to use Reporting Services as the reporting tool.ÃÂ The student labs cannot run IIS so I assume that using server-based reports is out and am looking at using local reports and the VB ReportViewer control. For several reasons (waaayyy too long to list here) I do not wish to use the drag-and-drop datasets that seem to be the core of the ADO.Net 2005 architecture.ÃÂ Instead I prefer to create connections, commands, and datasets in code and to set data binding and manage data updates in code.ÃÂ All command objects map to SQL Server stored procedures. I need to be able to do the same thing with reporting services local reports but have run into a brick wall in getting the report and/or report viewer to recognize a dataset table created in code. I would like to do the following (which worked very well in VB 2003 using Crystal Reports): 1. Design report--I am willing to accept the requirement to manually set the Value property of controls since I don't want to set data sources to .xsd files. 2. Instantiate a report object at run time and set it's data source to a dataset table.ÃÂ The underlying query that fills the table would have to contain all columns needed by the report's controls. 3. Set the report object to be the LocalReport for a ReportViewer control. Can anyone point me to a tutorial or walk-through tha

Status of Accessing Nested Objects in Data Source of Local Report Does Not Function

We recently upgraded out platform to .NET 4. We are also using Microsoft Reporting dlls. Unfortunately, we found that the upgrade broke all of our reports. Researching the cause, we found this article:

https://connect.microsoft.com/VisualStudio/feedback/details/553592/accessing-nested-objects-in-data-source-of-local-report-does-not-function

It seems that this issue has been open for some time now and I have not seen a good workaround (except for the shim class which is not really feasible for us). Can I please get a status update for this? Is there some other type of resolution?

Thank you,

Benjamin Strum

Ben Strum

How can you debug a report data source that is an XML web service?

I have a report that is using an XML web service as it's datasource. I would like to know what parameter

values the report is passing to the web service.

I tried the following debugging process but it did not work.

1. Set the Reporting Services Project as the Starting Project.

2. Set the report as the startitem in the project's startitem property.

3. Set a breakpoint in the web service.

4. I started the debugging which opened the report. I put in a parameter value and ran the report.

But the debugger did not stop at the breakpoint. What am I doing wrong?

How can I know what parameter values are being passed to the web service?

Thanks,

Lloyd

Report Builder:The type of the data source has not been specified.

HI,

I am getting the folloing error when I try to run the reeeport through report builder

The type of the data source has not been specified.

----------------------------
An error has occurred during report processing.

Please tell me what can i do to avoid this

Data source not found issue in subscribed report (subscribed in ssrs 2005) , with shared data source

Recently we have upgraded from SQL 2005 to SQL 2008. Following is the issue am facing in some reports in SSRS 2008. More details are below. Any solution/ cause for the issue would be of great help.

1) Reports having issue are the ones which were deployed in SSRS 2005 through SUBSCRIPTION (Listed under My Subscriptions) and now tried to view in SSRS 2008.

2) The reports use a shared data source with name ‘Test Center’

3) After upgrading to 2008 and when we try to open the report data source not found error is thrown. “An error occurred during client rendering. An error has occurred during report processing. The data source ‘Test_Center’ cannot be found". Why does it have ‘_’ added in the data source name !!

4) When we go to the report Properties – Data sources and check the path of the shared data source, the path is correct and the data source do exists in the path.

5) If we go to report Properties – General – Report Definition – select Edit and save the RDL. Immediately select Update and browse the saved RDL and upload. The report works fine. However the data source reference still remains same.

6) Also if we deploy a report fresh referring the same data source, that too runs fine with no issues.

- Thanks & Regards, RaSuHe

Passing report parameters to a query using a WCF data source

Hello everyone,

I am attempting to pass report parameters to my query. My report's data source is a WCF web service. I can run normal queries fine, but I have found that without the know-how to pass parameters to my query I am limited with my capabilities.

Assume a string parameter named "Name" with a specified default value of "Jmachol90", how would I pass that into the following query at the designated place:

<Query>

<Name>[PASS PARAMETER IN HERE]</Name>

</Identifier>

</Identifiers>

please help create report using sharpeoint list as data source

the dilema is I can use standalone report builder 3.0 to create report from sharepoint list data source. But I cannot upload any report(not just sharepoint source) from report builder 3.0(standalone) to report server

I can create report model in sql BIDS for report server and using builting report builder 1.0 to create a report, but the data provider in BIDS only shows SQLclient and Oracleclient

any idea?

Stored Data Source Credentials in Report Builder 3.0

Hello,

I have setup a SQL Reporting Services 2008 R2 server which contains data sources that connect to databases on a remote SQL 2008 server. In the data source the connection string is defined and "Connect using:" is set to "Credentials Stored Securely in the Report Server", I have entered the credentials required to connect to the remote SQL 2008 server where the database resides and there is no problem when I choose "Test Connection".

When I access the Report Builder through the SSRS website and create a new report I can add the data source to the report without an issue. When I try to create a new dataset and specify to "Use a dataset embedded in my report" I can choose the data source but when I try to then open the Query Designer I am prompted to enter the credentials for the data source. The username I saved in the data source on the Reporting Server seems to default in however the password does not.

I see on MSDN (http://msdn.microsoft.com/en-us/library/ms159736.aspx) the following:

"You can specify a single set of stored credentials that a report server uses to access external data for a report. Stored credentials are used if the report runs unattended. The report server retrieves and uses the credent

SQL Server 2005: Jazz Up Your Data Using Custom Report Items In SQL Server Reporting Services

Custom report items in SQL Server 2005 Reporting Services address your needs for custom reports without the pain of doing it from scratch.

Teo Lachev

MSDN Magazine October 2006

Data Points: Report Controls in SQL Server 2005 Reporting Services

Reporting has always been one of the dark arts of development. The tools typically seem to do just enough to get you to a certain point, then leave you to find workarounds to solve more complex issues.

John Papa

MSDN Magazine July 2006

Display multivalue data in crystal report

i Want to show data for single employee like this like this

Emp Id : xyz

Emp Name : abc

-------------------------------------------------------

Child name Date of birth education

abc 12/12/2000 o levels

Microsoft Report Viewer control to display data on one page

Hello everyone,

I am wondering if the Microsoft Report Viewer control allows for display changes. Say for instance a user wants would like to see all the data requested then another time would like to toggle thru the pages of infomation. So does anyone know if the control allows for display changes from complete view to paginated viewing. I am using MS VS 2008 with ASP.NET 3.0. Thanks for your response.

Tonya

Displaying a Parameter Value in the report footer that corresponds with the parameterized data on ea

I've got a report that has only one parameter, it determines the department (or departments) to base the report on, the parameter is set to allow for multiple values. The report returns only on page per department, so the report could be anywhere from one to a hundred pages, one page per department. I've included a text box in the report footer that displays the report name and the parameter value, the expression looks like this: =Globals!ReportName & " For Department " & Parameters!Dept.Value(0) I know that in this example the zero inside of the parenthesis of the parameter value is what is returning the actual value when the report is rendered, and I understand that the zero is value in the array of parameter values. What I'm looking to do is adapt this expression so that the parameter value rendered on each page corresponds with the data (departement) displayed on the specific page. So using the example of the data, if the user selected three departments in the parameter drop down, then each page that displayed the different department’s information would also display that departments name in the page footer text box. I'm thinking that each time a page is rendered that there is a group or global variable that can be called to provide this dynamically but I can't seem to find the information. Appreciate any help, Dan

Report Builder Report manage data sources - relink programmatically

As part of a site definition solution several report builder report rdl files are uploaded to a report folder.ÃÂ After a site is created with the defintion, the reports must be manually re-linked to the data source through the UI context menuÃÂ ("Manage Data Sources").ÃÂ I have been trying to figure out how to do the re-linking programmatically without luck.ÃÂ Any ideas? ( Reporting Services is configured as integrated with sharepoint)


Categories:

ASP.Net	Windows Application	.NET Framework	C#	VB.Net	ADO.Net
Sql Server	SharePoint	Silverlight	Others	All