The Name Of DataSource In URL Of Report.
Jan 15, 2007Hello :
Can we make to cross the name of the DataSource in URL of the report ?
Thank you very mutch.
ADVERTISEMENT
Adding DataSet As DataSource To Report Published On Report Server From ClientSide
Jan 15, 2007Hi
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
Cannot Run Report On The Report Server With Ssis As A Datasource
Aug 22, 2007Helo 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
Report Model And It's Datasource
Aug 4, 2006hi 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
XML Datasource For Local Report
Feb 11, 2008I 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 RelatedUsing A WCF WebService As Report Datasource
Jul 25, 2007Hello 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.
Report Model With XML Datasource
Jan 5, 2007
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.
Problem With Datasource On Report Builder
Jan 29, 2007I'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
Always Asking Report Datasource Login Autentication
Apr 24, 2008I'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
Datasource Cannot Be Found After Report Redeployment
Nov 3, 2006We 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
SSRS Report As A Datasource To SSIS
Feb 5, 2008
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!!
Parameterized Report And DataSource Security
Jan 8, 2008Hello.
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
Can I Use A Published Report As A Datasource For Other Reports?
Feb 6, 2007Hi,
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
Creating A Report Model On A UDB Datasource
Aug 30, 2006Hi 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
XML Report Datasource - Web Service Issue With Parameters
Oct 2, 2007Hi,
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.
Error Deploying Report With DataSource SSIS
Apr 11, 2008
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
Rendering PDF Report With URL, Force Requery Of Datasource
Oct 11, 2007Greetings,
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
Error Creating Report Model Using A DB2 Datasource
Jun 12, 2007I'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.
Use Shared Datasource In Embedded Report Code
May 31, 2007Hi,
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
Assign Datasource To Server Report Dynamically
Feb 6, 2008Hello 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.
How To Create Cascading Parameters In A Report With Cube As Datasource
Mar 11, 2008
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.
SQL 2012 :: Delete Encrypted Key In SSRS But Now Report Cannot Connect To Datasource
Dec 10, 2014I decided to delete the encryption key.After that when I go to the reporting page, the report cannot connect to the datasource.
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'xxxxx'. (rsErrorOpeningConnection)
For more information about this error navigate to the report server on the local server machine, or enable remote errors
What do I suppose to do?
How To Define A Left Outer Join In Report Using ReportModel As DataSource
Aug 25, 2006
Dear ppl,
I got a Report Model Project, in which i have created a model of my Database and deployed it on the server...
Then I have a Report Server project for my reports. The reports are using Report Model as the DataSource...
Now in the Report Designer, inside a report, when I define query for Dataset using Report Model , I can't find a way to write a left Outer Join query... It always performs Inner Joins... was wondering ether Report model supports Outer Joins ?... I might achive this using two different datasets but then i'll end up using two data regions e.g. 2 tables, but i don't want to do that... instead I want all of my data to appear in a single table which can reference to single dataset.
Is there a way to define left outer joins using Report model ? I am new to this Reporting Servces and I might be missing something here... would any body please point out that
Programmatically Assigning The Datasource In The Server Report Ssrs 2005
Jan 2, 2008Dear All:
I am new to SSRS 2005.
I have created many shared datsources and reprots at http://localhost/resportserver.
I am trying to access these reports from ReportViewer in the web application. Actually I want to use these reports for different customers by just changing the datsource programitically.
Is this is a possible?
Thank you
Theju
Entities Disappear From Report Builder Explorer When Datasource Is A Cube
Feb 1, 2007I have scoured the internet looking for someone who has run into this issue with no such luck!
Product: Reporting Services 2005 Analysis Services 2005
Our users use Report Builder as an ad-hoc report tool. Data sources for Report Builder come from Report Servers and Analysis Servers.
I have run into issues where a user will select a source for their report that is based on an AS cube. When they select an attribute (field) from a selected entity in the Report Builder Explorer and drop it on the canvas, all entities except the one the field was selected from disappear.
For example:
A cube has a fact table called "Annual Income" with dimension of employee and demographics. In Report Builder, the entities would be listed in the left hand Report Builder Explorer window as
Annual Income
Employee
Demographics
If I select attributes from Employee or Annual Income, as usual, you will see the related hierarchies of the remaining entities. However, if I select an attribute from Demographics, then the Annual Income and Employee entities just disappear and all I can see is the Demographics entity and its attributes.
Has anyone run into this and if so, any ideas? This is becoming extremely frustrating. I have deleted and rebuild cubes, individual dimensions, and everything else I can think of.
Your responses are appreciated,
Scott
Reporting Services :: Creating Datasource As ODBC With AS / 400 For SSRS Report
May 22, 2015Data Source of the report is AS/400 and I need to create a report in visual studio 2013 with ODBC Connection type and deploy report onto share point 2013. How to create report, data source and deploy on share point.
My problem is how we will create ODBC connection with AS/400 and connect report with AS/400.
Use Business Objects (generic List Object) As Datasource To Generate A Report??
Apr 2, 2008I was wondering if it is possible to use a generic list object to use as the datasource/data for a report? Right now we use these business objects to display information on our website and would be great it we could re-use those objects and create reports based on them. We are doing some calculations etc in the business layer to build these objects, so if we could re-use, that would be best.
Thanks!
Report Model/Datasource View, Primary Data Source Problem
May 23, 2007I 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?
How To Use A Stored Procedure With Parameters To Create The Datasource View For Report Model Builder
Mar 12, 2007I 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 RelatedVisual Studio Hangs When Generating A Reporting Services Report With Cube As The Datasource
Mar 7, 2007When creating a report using reporting Services with a cube as a datasource, visual studio 2005 hangs. I have applied SP1 to visual studio.net 2005 .
This is the query generated by query designer in reporting services. When I try to drag and drop another dimension to slice it by , visual studio hangs.
The fact table has just 10,000 records. Are the number of dimensions used to slice the cube too many? How do I optimize this query?
SELECT NON EMPTY { [Measures].[Avg MT Rate - Speech], [Measures].[Change in Avg MT Rate], [Measures].[Edited Lines Per 1000], [Measures].[Speech Utilization], [Measures].[Time Saved %], [Measures].[Speech Edited for Rev 1], [Measures].[Change in Account Productivity], [Measures].[Hours Saved], [Measures].[Lines Per 1000], [Measures].[Average MT Rate - Total Production], [Measures].[Typed Lines], [Measures].[Productivity Time in hours - Edited Docs],[Measures].[Productivity Time in Hours - Typed Docs],[Measures].[Productivity Time in Hours]} ON COLUMNS, NON EMPTY { ([Dim Customer].[Customer Name].[Customer Name].ALLMEMBERS * [Dim Customer].[Dictator Site Name].[Dictator Site Name].ALLMEMBERS * [Dim Date].[The Month].[The Month].ALLMEMBERS * [Dim Date].[The Year].[The Year].ALLMEMBERS * [Dim MT].[Creator Last Name].[Creator Last Name].ALLMEMBERS * [Dim MT].[Creator First Name].[Creator First Name].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOMEMBER(@FromDimDateTheYear, CONSTRAINED) : STRTOMEMBER(@ToDimDateTheYear, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOMEMBER(@FromDimDateTheMonth, CONSTRAINED) : STRTOMEMBER(@ToDimDateTheMonth, CONSTRAINED) ) ON COLUMNS FROM [ETL DW])) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS
SQL DataSource
Mar 28, 2007I working on a form using an SQL DataSource. I am going to add a where clause. In that where clause a value from a label will be passed from the user.
How do I pass to the HTML Source the label value from the where clause. The value can change from user to user.
Sample below:
SELECT [KeyRolesID], [KeyRolesDesc] FROM [KeyRoles] WHERE ([JobCodeFamily] = @JobCodeFamily).
I want to replace the @JobCodeFamily which is currently coded with a value from the Sql DataSource in the design form with a label value entered by the user.
Wcf For Xml Datasource
Aug 28, 2006Hi, guys
I used an exported wcf service as a web service, try to use it as the reporting datasource,
[OperationContract]
DataSet GetTestReportData();
the app.config in the service host:
<configuration>
<appSettings>
<add key="BaseReportingAddress" value="http://localhost:8999/ReportHandlerService"/>
</appSettings>
<system.serviceModel>
<services>
<service name="Reporting_Handler.ReportHandlerService">
<endpoint address="http://localhost:8999/ReportHandlerService"
binding="basicHttpBinding"
behaviorConfiguration="ReportingServiceBehavior"
contract="Reporting_Handler.IReportingHandler"/>
</service>
</services>
<behaviors>
<behavior name="ReportingServiceBehavior">
<metadataPublishing
enableGetWsdl="true"
enableMetadataExchange="true"
enableHelpPage="false">
</metadataPublishing>
</behavior>
</behaviors>
I set the datasource type as xml and the connection string to http://localhost:8999/ReportHandlerService, the query string for dataset is
<Query>
<SoapAction>
http://tempuri.org/IReportingHandler/GetTestString
</SoapAction>
<Method Namespace="http://tempuri.org/IReportingHandler/"
Name="GetTestString">
</Method>
</Query>
but it doesn't work, I tried use a pure asp.net web service and it works. can anyone help me to set the connecting string for datasource and query for dataset when it using wcf as the web service? Thanks in advance.
bruce
What Is A Datasource Used For?
Mar 18, 2008Hi All,
I have a question about the datasource that we create on the Report Manager. What is it used for? In the below connection string which is given in the "Connection String" text box of a datasource link:
"Data Source=ProdServer;Initial Catalog=Northwind"
What is this datasource used for? Is it used only to use the ReportServer database or even our queries incorporated in the RDL files will be run against this datasource? I think the latter should not happen because while creating RDL files also, we provide a connection string to run the stored procedures against that datasource.
Please let me know about the same.
Thanks a lot and let me know if the question is not clear.
Manoj Deshpande.