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


ADVERTISEMENT

ADO.NET Parameterized Query Security

Sep 6, 2007

I am developing a website for multiple clients, each with their own separate database on SQL Server 2005. The database structures are identical for all clients. I like to use SQL stored procedures for the security advantages (i.e., don't need to grant access to the tables, only exec permissions on the stored procedures), but maintaining and deploying many sp's across all databases is becoming unwieldy and error-prone.

Is there a way to use parameterized queries (SqlCommand, SqlParameter) in C# code (which could be reused for all databases by changing the connection string) without having to grant access to the tables?

View 5 Replies View Related

Missing Permission To Create Datasource, New Folder, Add Security..etc

Jun 20, 2007

I have windows 2003 reporting services 2005 that has been working fine. Now all of a sudden when I go to http://localhost/reports I am unable to assign security to folders(the link is hidden) the New data source button is hidden, the new folder button is hidden, upload folder and report builder are also hidden. I am logged in as aministrator.





Also when I connect to reporting services through SQL Mgmt Studio I have the same issue, there are no options for permissions only a general option.



I'm sure it's a permissions issue but what do i do to resolve?



Thx

View 2 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

Dynamic Parameterized MDX Dataset In Report Table

Oct 10, 2007

Hi, I was wondering if there is a way to solve this issue.

I have the following MDX to retrieve specialised time related data from a cube



Code Block

SELECT NON EMPTY { { { [Measures].[% Vacancy], [Measures].[Total Square Area], [Measures].[Deliveries], [Measures].[Net Absorption] } * { [Time].[Quarter].[2007 Q1], [Time].[Quarter].[2007 Q1].lag(1), [Time].[Quarter].[2007 Q1].lag(2), [Time].[Quarter].[2007 Q1].lag(3), [Time].[Quarter].[2007 Q1].lag(4), ytd( [Time].[Quarter].[2007 Q1]), ytd( [Time].[Quarter].[2007 Q1].lag(4)),ytd([Time].[Quarter].[2007 Q1].parent.lag(1)),ytd([Time].[Quarter].[2007 Q1].parent.lag(2)) } } } ON COLUMNS ,

NON EMPTY { DESCENDANTS( [Location].[All Location], [Location].[Market] ) } ON ROWS

FROM [QMS]

WHERE ( [Overall].[Overall].&[Y] )






I can populate a table with the columns i need from the resulting dataset, however it is not dynamic. i.e.

The dataset field names come up as say,

Measures___Vacancy_Time_All_Time_2007_2007_Q1
Measures___Vacancy_Time_All_Time_2006_2006_Q4

Which i can place in the report...

But if I then want to parameterize [2007 Q1] like as follows




Code Block
="SELECT NON EMPTY { { { [Measures].[% Vacancy], [Measures].[Total Square Area], [Measures].[Deliveries], [Measures].[Net Absorption] } * { [Time].[Quarter].[" + Parameters!Quarter.Value + "], [Time].[Quarter].[" + Parameters!Quarter.Value + "].lag(1), [Time].[Quarter].[" + Parameters!Quarter.Value + "].lag(2), [Time].[Quarter].[" + Parameters!Quarter.Value + "].lag(3), [Time].[Quarter].[" + Parameters!Quarter.Value + "].lag(4), ytd( [Time].[Quarter].[" + Parameters!Quarter.Value + "]), ytd( [Time].[Quarter].[" + Parameters!Quarter.Value + "].lag(4)),ytd([Time].[Quarter].[" + Parameters!Quarter.Value + "].parent.lag(1)),ytd([Time].[Quarter].[" + Parameters!Quarter.Value + "].parent.lag(2)) } } } ON COLUMNS ,NON EMPTY { DESCENDANTS( [Location].[All Location], [Location].[Market] ) } ON ROWS FROM [QMS] WHERE ( [Overall].[Overall].&[Y] )"





so that everything is then driven from a single selected Quarter value, the table report no longer gets populated, as it has hardcoded field values such as

=Fields!Measures___Vacancy_Time_All_Time_2007_2007_Q1.Value

and if the Quarter selected is [2006 Q1] for example, this field will not exist in the dataset.

Is there a way to accomplish this? I am using SSRS 2005 against SSAS 2000 cubes

View 5 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

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

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

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

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

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

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

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

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

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

Custom Security Extension - Report Manager And Report Server On Different Machines

Sep 19, 2007

Hi,

I'm trying to deploy Reporting Services on an Internet-facing web server using a custom security extension (forms authentication). We will be putting Report Manager on the Web Server outside of the firewall, and Report Server on another machine inside the firewall. When testing the solution in a development environment with Report Manager and Report Server on the same box, the solution works fine.

When testing it using the Internet-facing environment described above, it almost works but there seems to be an issue with the authentication cookie that is generated. Here's what happens:

1. User enters credentials on UILogon.aspx and submits form.
2. In the code-behind, LogonUser() is called through a web service proxy and the authentication cookie is returned successfully. The code used here to set the cookie is the same code used in the Forms Authentication sample that ships with RS2005.
3. The user is redirected to Folder.aspx, and the request hangs for a while, and eventually kicks you back out to UILogon.aspx, as if it lost the authentication cookie. When doing a trace on the HTTP header, the cookie is still there.

Is there anything special I need to do to make the Report Server "see" the cookie when I have Report Manager and Report Server on different machines?

Any help would be much appreciated!

Mike

View 2 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

SQL 2012 :: Delete Encrypted Key In SSRS But Now Report Cannot Connect To Datasource

Dec 10, 2014

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

View 0 Replies View Related

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

View 22 Replies View Related

Programmatically Assigning The Datasource In The Server Report Ssrs 2005

Jan 2, 2008

Dear 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

View 2 Replies View Related

Entities Disappear From Report Builder Explorer When Datasource Is A Cube

Feb 1, 2007

I 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

View 1 Replies View Related

Reporting Services :: Creating Datasource As ODBC With AS / 400 For SSRS Report

May 22, 2015

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

View 2 Replies View Related

Use Business Objects (generic List Object) As Datasource To Generate A Report??

Apr 2, 2008

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

View 2 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







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