Report Model And It's Datasource

Aug 4, 2006

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



View 4 Replies


ADVERTISEMENT

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.

View 4 Replies View Related

Creating A Report Model On A UDB Datasource

Aug 30, 2006

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

View 1 Replies View Related

Error Creating Report Model Using A DB2 Datasource

Jun 12, 2007

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.

View 1 Replies View Related

Report Model/Datasource View, Primary Data Source Problem

May 23, 2007

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?

View 1 Replies View Related

How To Use A Stored Procedure With Parameters To Create The Datasource View For Report Model Builder

Mar 12, 2007

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 Related

Report Model Deployment : The Model ID Of The Submitted Model Must Match That Of The

Dec 5, 2005

Running 2005 Beta 3 Refresh.  When I first deploy, it works fine. Subsequent deployments yield the following error:

View 9 Replies View Related

How To Change The Datasource View Of A Mining Model.

Feb 9, 2007

Hi,

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.

View 4 Replies View Related

Adding DataSet As DataSource To Report Published On Report Server From ClientSide

Jan 15, 2007

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

View 8 Replies View Related

Cannot Run Report On The Report Server With Ssis As A Datasource

Aug 22, 2007

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

View 9 Replies View Related

Report Builder Using Report Model Based On Linked Server (Excel) - Primary Key?

Sep 6, 2007

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

View 3 Replies View Related

Can't Connect To Remote Report Server Model From Report Wizard

Mar 6, 2008



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

View 3 Replies View Related

Report Model: Drill On Calculated Field In Report Builder

Feb 11, 2007

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

View 1 Replies View Related

Dynamic Refresh Of Report Model In The Report Builder

Jan 22, 2007

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.

View 1 Replies View Related

Problem Writing A Report On A Generated Report Model

Apr 26, 2006

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?

View 9 Replies View Related

Report Designer Report That Queries A Cube Model

Jun 15, 2007

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

View 1 Replies View Related

The Name Of DataSource In URL Of Report.

Jan 15, 2007

Hello :

Can we make to cross the name of the DataSource in URL of the report ?



Thank you very mutch.

View 1 Replies View Related

XML Datasource For Local Report

Feb 11, 2008

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 Related

Using A WCF WebService As Report Datasource

Jul 25, 2007

Hello 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.

View 4 Replies View Related

Deploy A Report Model Using Report Manager

Feb 13, 2008

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?

View 6 Replies View Related

How To: Link A Report To A Model As A Clickthrough Report

Jul 14, 2006

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 Related

Problem With Datasource On Report Builder

Jan 29, 2007

I'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

View 5 Replies View Related

Always Asking Report Datasource Login Autentication

Apr 24, 2008

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

View 3 Replies View Related

Datasource Cannot Be Found After Report Redeployment

Nov 3, 2006

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

View 3 Replies View Related

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!!

View 5 Replies View Related

Parameterized Report And DataSource Security

Jan 8, 2008

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

View 3 Replies View Related

Can I Use A Published Report As A Datasource For Other Reports?

Feb 6, 2007

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

View 3 Replies View Related

XML Report Datasource - Web Service Issue With Parameters

Oct 2, 2007

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.

View 5 Replies View Related

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

View 5 Replies View Related

Rendering PDF Report With URL, Force Requery Of Datasource

Oct 11, 2007

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

View 3 Replies View Related

Use Shared Datasource In Embedded Report Code

May 31, 2007

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

View 1 Replies View Related

Assign Datasource To Server Report Dynamically

Feb 6, 2008

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.

View 1 Replies View Related

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.

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved