Is there a way to create a Report Model with XML / WebService as datasource?
I am able to generate reports that connect to a WebService through Report Designer, but unable to find similar functionality in Model Designer.
hi everyone,
I created a report model and deployed it. When I open the rpt builder on web I get the following error.
'The selected data source does not have and content available'
Seemed like it would be a easy issue, but I cannot retrieve any data in the rpt model. The datasource I'm using does work for rpts not associated with the rpt model. Any suggestions? It seems like I've missed a step. Thanks, Lisa
Hi all,
I'm just getting started with Reporting Services and have a question.
I'm trying to set up a report model based on a UDB data source. However when I use the report model wizard, I get presented with:
[DB2/SUN] SQL0104N An unexpected token "SET TRANSACTION" was found following "BEGIN-OF-STATEMENT" ... SQLSTATE 42601.
I think that this is trying to set transaction isolation levels however this is not valid SQL for a UDB database.
Is there something that I'm missing with my configuration to make RS know that this is a non-SQLServer database?
Many thanks,
JK
I'm receiving the following message after I've created a datasource and datasource view:
[DB2/SUN] SQL0104N An unexpected token "SET TRANSACTION" was found following "BEGIN-OF-STATEMENT" ... SQLSTATE 42601.
I have a datasource view DSV1. It points to a datasource DS1 that is considered the "primary".
I have created a Report Model that uses DSV1 (and thus uses DS1)
I created a new datasource, DS2 that I would like to use instead of DS1. (I can't just modify DS1 because if I modify it, it will overwrite it when we go to our Production environment and break that datasource)
So, I can go into DSV1 and change all the references from DS1 to DS2.
But that's where the problem lies.
When I try to build, I get the following error:
"The Table property of the Entity "E1" refers to the Table "dbo_View", which is not in the primary data source."
Somehow, the entity is tied to the "primary" datasource. When I change it back to DS1, everything works fine. Any thoughts? What can I do?
I have a stored procedure that takes a date range and returns all the sales in that date range. I'm trying to create the report model for ad-hoc reporting. When I go to create the dataset view, it only lets me select tables or views.... how do I get around this?
View 2 Replies View RelatedRunning 2005 Beta 3 Refresh. When I first deploy, it works fine. Subsequent deployments yield the following error:
View 9 Replies View RelatedHi,
I created on model in Business Intelligence Development studio.I wants to change the datasourceview(dsv) assigned for that view.for e.g
My mining Model is StudModel.dmm.
The dsv for that model is StudDSV.dsv.
I wants to change the dsv for that model to marksDSV.dsv.
How to do that in Business Intelligence Development studio.
Thanks,
Karthik.
Hi
I am Creating Click Once Windows Application with Reporting Services 2005.I have created Report and Published on Report Server.In my windows application I am successfully able to view my published report through report viewer control.
Now in my application I am getting a dataset from my custom webservice. I want this dataset data to be added to my report as datasource at runtime on Client Side ,as my report is on Report Server.
waiting for help!!
Thanks in Advance
Pankaj
Helo All,
I have report which uses an ssis package as a datasource. when I develop the report on the visual studio seems like it runs fine. But when I deployed the same report on to the server (report server 64 bit machine) it is throwing me an error:
An error has occurred during report processing.
Cannot create a connection to data source 'DataSource1'.
is not a valid Win32 application. (Exception from HRESULT: 0x800700C1)
I have both sql sever and reporting server on the same machine and using windows credentials for both the servers(sql and reporting).Then I believe there is no credential issue.
My connection string looks something like this:
="/FILE C:NTSDWKPIKPI_SSISNTSKPICCA_DATA_RECON_DELIVERY.dtsx /SET Package.Variables[User::V_SSRS_PARAM].Properties[Value];" & """" & Parameters!V_SETT_DATE.Value & """"
Could any please help me out of this?
Note: SSIS is parameterized here!
Regards,
Raju
I've created a linked server with a pretty basic Excel spreadsheet, and used this command to create a linked server to it:
sp_addlinkedserver ''XL_SPS_1', 'Excel', 'Microsoft.Jet.OLEDB.4.0', 'c:MyExcel.xls', null, 'Excel 8.0'
I want to use this as the data from which to build a report model. As linked servers don't show up in the Data Source View wizard, I created a view in SQL Server:
create view MyExcel
as
select * from XL_SPS_1...Sheet1$
Okay, great, now the view shows up in the DSV wizard and I can create the data source view. However, when I create a new report model based on this data source view, the Report Model Wizard tells me at "Create entities for all tables" that I've got an error when it processes dbo_MyExcel that "Table does not have a primary key."
I assume this is where the identifying attributes for the entities in the report model are taken from, so I really can't go further. Does anyone have an idea as to how to add a primary key to a linked server (Excel) in SQL 2005? Can this be done? Other than importing spreadsheet data to a SQL table, how can I get around this?
Thanks,
--Stan
Hi,
I have created and deployed a data source (which uses "Credentials supplied by the user running the report") and a model which uses this data source.
Also I have built a report using Report Builder and all works well.
Now I wish to use Visual Studio to build a report, so I'm trying to create a data source from my computer which the report should use and I want it to use the model on the remote server. In the Report Wizard I am using "Report Server Model" and the following connection string:
Server="http://<remoteserver>/reportserver";datasource="/Models/MyModel"
IHowever I can't make the credentials to work. I've tried them all with no luck. What username/password must I use? Because so far nothing of what I have tried works.
Any help is highly appretiated.
Kind Regards,
Robert
Hi,
I've created dsv that contain all fields from table database. in the smdl I've remove some fileds due to security. All fields in the smdl do not contain drill.
Issue: When I created calculated field in the report builder the field has a link. When I clicked the drill I saw all the record data including field that not in the smdl.
Questions:
1) Can I remove the link from the calculated fields?
2) Can I prevent from users drill to fields that not in the smdl?
Thanks,
Assaf
Is it possible to dynamically refresh the report model of the report builder?
could it even be using code with any of the interfaces?
When we add a table or add a column to the table in database , will the report model get refreshed automatically or do we need to do it externally. If so, can we use any of the objects and write a custom code in VB.
I get this error message:
Semantic query execution failed.
The 'PerspectiveID' custom property for the 'query' perspective is either not set or is not set to the string data type.
The report model does have a perspective.
Anyone else seen this?
In Report Designer I am able to create a Model data source and see my entities/fields.
But when I run the report I get a "Failed to execute Query" message.
I know in the past this was an issue because Designer doesn't allow you to specify a perspective.
Does anyone know if this has been resolved?
I'm using SP2
Thank you,
Joe
Hello :
Can we make to cross the name of the DataSource in URL of the report ?
Thank you very mutch.
I have an xml file that defines the fields in my dataset and I want to hook this up to a report so it can uses those fields when creating a local report. However I can't figure out how to do this. I have an RDLC file but I don't know where or how to hook it up to the XSD file. What do I need to do?
View 4 Replies View RelatedHello all,
When trying to configure a WCF service as a report data source I have these following questions:
1. What do I need to provide for the connection string?
I currently wrote http://localhost:8003/ServiceName/ which returns the WSDL. Is that correct?
2. I don't know what to write inside the Query defintion. I currently wrote:
<Query>
<SoapAction>
http://tempuri.org/ServiceContractInterface/MethodName
</SoapAction>
<Method Namespace="http://tempuri.org/ServiceContractInterface"
Name="MethodName">
</Method>
</Query>
and the result is:
Failed to prepare web request for the specified URL. (Microsoft.ReportingServices.DataExtensions).
Can any one please point me in the right direction?!
Thanks.
I have a report model that I am trying to deploy using report manager web service. A folder is created by the administrator to place all my SSRS reports. I deployed .rdl files using the "Upload file" function in "Report Manager". All the SSRS reports work fine but when I tried to upload .smdl file (report model file) using the Report Manager's "Upload file" function it gave me the following error message.
The permissions granted to user 'xxxxxxman' are insufficient for performing this operation. (rsAccessDenied)
Does this mean I only have permission to upload .rdl file but NOT .smdl file to my designated folder?
I'm having some difficulty linking a custome drilldown or clickthroug report to another report that I have already created in report builder. I followed a MSDN article found at http://msdn2.microsoft.com/en-us/library/ms345226.aspx but I cannot find the " Select a page area, select Drill-through reports" option in report manager. Does anyone have a better explanation on how to do this? I'm assuming that when you create the clickthrough report there has to some sore of filter on it that relates to the item of the clickthrough. I guess I'm I little confused, any help would be great. Thanks.
View 5 Replies View RelatedI've got a strange problem with ReportBuilder. I've created a DataSource name Config and a Model name Customers. We been using this model for month and everything was working fine. Now when we try to create a new report we cannot run it. When Report Builder is running i select the "Customer" model. Then i put some fields on the report. When i try to run it i've got an error saying that it cannot create the command for datasource1. What i don't understand is why the error occured in Datasource1 and not in my datasource config ?
When i open the Report Manger and click on the model "Customer" the datasource use by this model is Config. So the problem is not because they're is a mistake in the configuration. I've tried to rebuild my model and datasource then deployed them but i still have the same problem.
Any idea of what the problem is ? I can't figure out
I've severals reports that connect to an ORACLE database, in the RDL file i've the save password but when i open the report again ou i use the sharepoint report viewer the username an password of the oracle database is always asked.
how can i configure the RDL not to ask the password again ?!
thx
Hugo
We have an application using the winforms report viewer, and it displays all our reports perfectly untill I need to redeploy a report.
As soon as a report is re-deployed a refresh of the report in the viewer shows the following error message:
An error has occured during report processing. The data souce 'mydatasource' cannot be found.
This error occurs irrespective of electing to re-deploy ot not re-deploy the datasource, and the only solution seems to be to close the report viewer down and restart it.
I can reproduce the same problem hosting the reports in a web browser as well, with a slightly different error message
An error has occurred during report processing. (rsProcessingAborted). The data source 'mydatasource' cannot be found. (rsDataSourceNotFound)
Under RS2000 any changes that were made to a report, would automatically be shown to the user if the report was refreshed, without having to close the browser/application down and restart it.
Can I configure RS2005 to prevent this error occuring ? I have read that RS2005 seems to work a lot more within the IIS session for the user and cache things it thinks are usefull, so can I turn this behaviour off, or make it run like RS 2000 did, which provided me with a stable reporting platform?
If I cannot do this from the RS end of the system, is there any advice on using the winforms control to get around this issue - i've only just started using the control so I am not familiar with all its aspects !
Thanks
Andy
Hi All,
Is there a way in SSIS to specify SSRS report as a datasource? I don't see any options in the data flow sources..
Thanks a lot!!
Hello.
I am trying to render a report that I set up with SSRS 2005 from an existing .Net web application. The report takes in a multi-valued parameter (sequenceNums) and displays data accordingly.
This is the url I am passing from the web application:
Code Blockhttp://myservername/ReportServer/Pages/ReportViewer.aspx?%2fProjectDBReports%2fCriticality&rs:Command=Render&rc:parameters=false&sequenceNums=4299,4312
Upon redirect, I receive the following error "one or more data sources is missing credentials"
I currently have the following connection settings checked for the DataSource used in the report:
- connect using credentials supplied by the user running the report
- use as windows credentials when connecting to the DataSource
When I attempt to view the report with no parameters being passed in, the report renders properly and I receive a prompt asking me for my credentials.
Do I have to connect to my DataSource using credentials stored securely on the report server?
Thanks in advance.
Sam
ps - i included the url within a code block so no smiley faces would show
Hi,
I have a data table called STOCKPE which holds stock valuation information at the close of business each day. I wish to use reporting services to extract the data in this table on a daily basis and keep a daily history on the report server. I know I can do this - this isn't my problem.
When I have the history of this table on the report server, can the data that the reports on the report server hold be used as a datasource for another report?
I'm no expert in reporting services, so if this is possible, or if there's a better way of doing it, please use small words and short sentences. No offence intended to all the very well educated SQLRS wizards out there, it's just that I'm not one of them and your answer will be lost on me if you use a lot of abreviations and acronyms.
Thanks,
Chris
Hi,
I have set up a report to access a web service and consume one of its methods - a method that returns a datatable set up with a table adapter. Query code example below:
Code Block
<Query>
<Method Namespace="http://AcornExportWebServices.org" Name="GetAllEnquiries"></Method>
<SOAPAction>http://AcornExportWebServices.org/GetAllEnquiries</SOAPAction>
<ElementPath IgnoreNamespaces="true">
GetAllEnquiriesResponse{}/
GetAllEnquiriesResult/diffgram{}/
DocumentElement{}/Enquiry
</ElementPath>
</Query>
This works fine and returns expected results.
However, when I try and return a set of results from a web service that has a parameter specified I get nothing returned. I have tried various different methods including adding the parameter in the dataset dialogue and specifying the parameter and specifying the parameters as in the code example below but still with no joy. Here is the code example with parameters:
Code Block
<Query>
<Method Namespace="http://AcornExportWebServices.org" Name="GetEnquiry">
<Parameters>
<Parameter Name="EnquiryID">
<DefaultValue>1</DefaultValue>
</Parameter>
</Parameters>
</Method>
<SOAPAction>http://AcornExportWebServices.org/GetEnquiry</SOAPAction>
<ElementPath IgnoreNamespaces="true">
GetEnquiryResponse{}/
GetEnquiryResult/diffgram{}/
DocumentElement{}/Enquiry
</ElementPath>
</Query>
When I remove the ElementPath declaration I get back the schema of the table so I believe that is proof that the web method is being contacted but whatever I seem to try I cannot return any results (or the 1 result that the web service should return).
I would be grateful to know if anyone has any ideas or suggestions about this problem.
Thanks.
Hello Everyone,
I make a report to consume a SSIS package, actually I use SSIS to load a datasheet on my Sql Server database, then i expose the aggregate values in a datareader destination. Every work fine in Visual Studio. But when i deploy my report and my Shared Data Source, and I try to run the report i get the next message:
An error has occurred during report processing.
No se puede crear una conexión al origen de datos 'ETLSource'.
The package failed to validate.
I dont Understand why, because when i work in BIDS the work perfect, Actually i'm using sql server authentication in my package connection to avoid the mistakes about report credentials.
That is the code of the ETLSource.
<?xml version="1.0" encoding="utf-8"?>
<RptDataSource xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<Name>ETLSource</Name>
<DataSourceID>c238d65d-a0f3-48da-ae23-323d6ba13bb0</DataSourceID>
<ConnectionProperties>
<Extension>SSIS</Extension>
<ConnectString>-f "C:TempValidaCambioEfec.dtsx"</ConnectString>
</ConnectionProperties>
</RptDataSource>
Also I have SSIS and SSRS in the same machine. And I'm using the same domain Account to run SSIS, SSRS and Reports site.
Thank you for help me
Julian Castiblanco P
Bogotá, Colombia
Greetings,
Let say I first use a URL in a web browser to render a PDF file.
Next the data changes.
Now I use the same browser session and call the URL again to render the PDF file; in the second rendering, the PDF report reflects the old data and not the changed data.
How do I force RS, using the same browser session, to render the second PDF file by requerying the data? Has any body come across the phenomenon? If I open a new browser session, the rendered PDF file reflects the new data. I have used Profiler to look at the SQL calls and sure enough, the second URL RS request does not requery the datasource.
Thanks
-leo
Hi,
I was wondering if there's a way to connect to a shared datasource in the Code section of a report's properties. I want to connect using my shared datasource as defined in my solution and query it to return a value based on user input for a function I need to put there.
Thanks,
Greg
Hello All,
How to assign the DataSource to Server Report which is stored in the remote machine. Now i need to work on it. If you have any solution please pass on it to me.
Thanks,
SR.
I'm trying to create report with datasource as a cube. I'm able to connect to datasource to pull data with a single parameter. But, I'm unable to succeed in creating a cascading parameter.
The following scenario:
I have a dimension "Period" as Paremeter.
The Period dimension is cascaded to year- quarter- month.
So, I would like to create a cascading parameter for period as year - quarter - month.
Please let me know, how to acheive this.
thanks,
Naveen.