Reporting Services :: Error With Shared Dataset

Apr 23, 2015

I've just recently tried to upload a report to my organisations local SharePoint site (2010)...it has reporting servers functionality and works fine otherwise. I have site ownership but have no control over the SharePoint Farm etc.

The trouble i've ran into is that the new report i've created is being pulled from a third party company's own server, with the shared dataset on their reporting server...it works fine when i run it on my computer or on their software system but it needs to be on the SharePoint site as well. For some bizzare reason it's against their policy to connect direcrtly to the database meaning i can't just create a data-source to sort this mess out.

The report server cannot process the report. The reference for the shared dataset 'DischargePerformancefull' is not valid. (rsInvalidDataSetReference) 

I've tried uploading the dataset into the same sharepoint library as the report but it just comes up with XML errors when i try to open it and it won't let me point the dataset to it from the SharePoint options.

View 2 Replies


ADVERTISEMENT

Reporting Services :: SSRS Shared Dataset As Source For SSIS?

May 12, 2015

Could we use SSRS Shared Dataset as a source to the SSIS package?

View 3 Replies View Related

Reporting Services :: SSRS Dataset Query Design Error Source

Nov 3, 2015

When  I click on the DataSet Query Desginer there is an Error Source:.NetSqlClient Data Provider. why this error comes and I have executed the SQL query in SSMS succesfully and the result comes. However this is causing the report from the report manager to fail.

View 8 Replies View Related

Reporting Services :: Populate One Dataset In SSRS Based On Results From Another Dataset Within Same Project?

May 27, 2015

I have a report with multiple datasets, the first of which pulls in data based on user entered parameters (sales date range and property use codes). Dataset1 pulls property id's and other sales data from a table (2014_COST) based on the user's parameters.

I have set up another table (AUDITS) that I would like to use in dataset6. This table has 3 columns (Property ID's, Sales Price and Sales Date). I would like for dataset6 to pull the Property ID's that are NOT contained in the results from dataset1. In other words, I'd like the results of dataset6 to show me the property id's that are contained in the AUDITS table but which are not being pulled into dataset1. Both tables are in the same database.

View 3 Replies View Related

How Can I Use SQL Reporting Services To Get A Dynamic Dataset From Another Web Service As My Reports Dataset?

May 21, 2007

I found out the data I need for my SQL Report is already defined in a dynamic dataset on another web service. Is there a way to use web services to call another web service to get the dataset I need to generate a report? Examples would help if you have any, thanks for looking

View 2 Replies View Related

Reporting Services :: SSRS Using A Shared Folder

Sep 4, 2015

I am trying to create a basic report in SSRS, with 6 columns but then we receive an excel spreadsheet with different account numbers daily and I am requested to create a report based on those account numbers. so how can I create a shared folder for the users to drop their excel spreadsheet  there and make my SSRS only filter the result set based only on those account numbers?

View 5 Replies View Related

Reporting Services :: SSRS Shared XML From Content Field

Dec 2, 2015

I am attempting to pull certain bits of information from the content field in the ReportServer.dbo.Catalog. I found this blog post that is nearly perfect : URL....However, when I try and bring in the query parameters, I am just getting nulls. All the code is:

--The first CTE gets the content as a varbinary(max)
--as well as the other important columns for all reports,
--data sources and shared datasets.

WITH ItemContentBinaries
AS ( SELECT ItemID ,
Name ,
[Type] ,
CASE Type
WHEN 2 THEN 'Report'
WHEN 5 THEN 'Data Source'

[code]....

I've tried various variations on the bit third line up from the bottom without any joy. I been reading lots on XML this morning and thing my head has completely gone out the window.

View 2 Replies View Related

Reporting Services :: Change Schedule (non-shared) For A Subscription Without Using Web Interface

Sep 23, 2015

At the Moment we use SQL Server 2008 R2 Std. with Reporting Services. I want to change the individual schedules (non-shared) for 170 subscriptions without using the web Interface.

I tried to change table entries for dbo.Schedule and dbo.Subscriptions but the reports did not run. I also know that here are Jobs in the SQL Server Agent for the schedules. Now I need to understand how the mechanism works that updates the job entries from database tables. Is there a stored procedure which can be used?

View 2 Replies View Related

Reporting Services :: Restrict To Shared Schedule Only In SSRS Subscription

Jul 3, 2015

Is there a way to restrict the subscriptions to use Shared Schedule only? We want to make sure that we manage the schedules and they'll only run the subscriptions during the off peak hours.

View 5 Replies View Related

Dynamically Change Initial Catalog In Shared Data Source In Reporting Services?

Oct 30, 2007

First off, let me just say that I'm a complete newbie to SQL Reporting Services, and .NET in general. We have a VB 6 application that is trying to launch an SRS 2005 report in a viewer window. This was accomplished by creating A VB.NET "wrapper" window that launches the report, and allows the report to be previewed, exported, etc. I did not write any of this.

The report is using a Shared Data Source, which points to a specific database. My problem is that the users can select which db they want when they launch the VB 6 Application, so I need to find a way to edit the connection string in the report to specify which database to use on the fly. I have the db name in the "wrapper" application, but I can't figure out how to pass it to the report.


thx,

Paul

View 3 Replies View Related

Reporting Services :: Unable To Run Scheduled Reports From SharePoint In Manage Shared Schedules

Jul 16, 2015

We are running into an issue where we are unable to run scheduled reports from SharePoint in the "Manage Shared Schedules" sections of any given site in our site collection (<site url>/_layouts/15/ReportServer/ScheduleList.aspx).  Reports are able to be generated manually, but never run when scheduled from SharePoint.We are encountering the following error in the SharePoint logs for our server.  

 Microsoft.ReportingServices.Library.InvalidReportServerDatabaseException: , Microsoft.ReportingServices.Library.InvalidReportServerDatabaseException:

The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is '162'.;     Here is the background in our environment:

SharePoint App Server  - Server 2012 R2 running SharePoint 2013 Application server - running SSRS SharePoint Integrated configured through Central Admin.SharePoint SQL Server - Server 2012 R2 running SQL 2012 SP1 for the SharePoint farm - hosts the Reporting Services databases.I have run the script within the Central Admin > Provision Subscriptions and Alerts to give appropriate permissions the the account in use.  Also the reporting services databases were created new as part of the install, so they were not migrated from a previous version.

View 3 Replies View Related

Reporting Services :: IF Statement If Dataset Field Value Equals Value Of Dataset Field

Sep 3, 2015

Using this IIF statement:

=CountDistinct(IIF(Fields!Released_DT.Value = Fields!Date2.Value, Fields!Name.Value,
Nothing))
Released_DT = a date  - 09/03/2015 or 09/02/2015
Date2 = returns another date value in this case 09/03/2015

What I'm trying to do is: count distinct number of people (Fields!Name.Value) if the Relased_DT = Date2.My IIF statement is returning a zero value.

View 4 Replies View Related

Reporting Services DataSet

May 5, 2008

Hi there

I am trying to figure out whether it is a possible or not to have a stored procedure that can return 2 dataset what I mean returning 2 selects and then manipulated within RS? If it's possible, can someone show me how?

The reason I am asking this due to have 2 return table view if you like that I manipulated each one of them differently and I rather do it one process instead of calling the same query for different view.

Thanks

View 5 Replies View Related

Reporting Services DataSet

May 6, 2008

Hi there

I am using RS 2005 and I am trying to figure out whether it is a possible or not to have a stored procedure that can return 2 dataset what I mean returning 2 selects and then manipulated within RS? If it's possible, can someone show me how?

The reason I am asking this due to have 2 return table view if you like that I manipulated each one of them differently and I rather do one query manipulation instead of calling the same query for different view.

Thanks

View 5 Replies View Related

Passing A Dataset To Reporting Services

Feb 2, 2007

I've seen questions similar to this posted, but I'm unable to find a clear answer to what I need to do.

We are currently using Crystal Reports, generating a dataset in our application and passing it to Crystal. Due to the many problems we have with Crystal we are now looking to move to Reporting Services 2005, but I can't find out how to pass it a dataset.

Although we do use SQL Server for data storage, we have many reports with calculations that are way too complicated to use calculated fields, and which change too often to want to store them in the database. One solution might be to store the data temporarily and regenerate it each time it's required, but this doesn't seem very elegant. So please could someone tell me if there is a way to do what I'm after and point me at a page that gives a nice clear explanation.

Thank you

View 2 Replies View Related

Reporting Services Dataset Problem

Apr 24, 2008

Hi everybody,



I use transact sql and a cursor in the dataset of my reporting services report. There is no error on the dataset but i can't add the dataset fields in the layout section (Visual studio business intelligence).



My dataset request :



-- Variable contenant le nom de la Base de Données

DECLARE @name nvarchar(50),

@DB1 nvarchar(50),

@DB2 nvarchar(50),

@DB3 nvarchar(50),

@RQT nvarchar(4000)

-- déclaration du curseur contenant le DataSet avec l'ensemble des DB

DECLARE DB_cursor SCROLL CURSOR FOR

-- RQT -> récupération du nom des DB selon un filtre (WHERE)

SELECT name

FROM master.dbo.sysdatabases

WHERE name LIKE 'SHP_CONTENT%' -- BDs de contenu SHP

ORDER BY name

-- Ouverture du curseur

OPEN DB_cursor

-- Récupération du premier élément du curseur

FETCH NEXT FROM DB_cursor INTO @name

-- Récupération des données des différentes BD

WHILE @@FETCH_STATUS = 0 BEGIN

-- création du nom des tables

SET @DB1 = @name + '.dbo.' + 'Sites'

SET @DB2 = @name + '.dbo.' + 'UserInfo'

SET @DB3 = @name + '.dbo.' + 'Webs'

-- LISTE DES GESTIONNAIRES

SET @RQT = 'SELECT Distinct(Webs.SiteID),UserInfo.tp_login,UserInfo.tp_Title, UserInfo.tp_Email,

Sites.TimeCreated, Sites.DiskUsed,Sites.DiskQuota, Sites.UserQuota,

Webs.FullUrl

FROM '

+ @DB1

+ ' INNER JOIN '

+ @DB2

+ ' ON Sites.OwnerId = UserInfo.tp_ID

INNER JOIN '

+ @DB3

+ ' ON Sites.ID = Webs.SiteID

WHERE Webs.FullUrl LIKE ''sites/%'' AND Webs.FullUrl NOT LIKE ''sites/%/%'''

-- EXECUTION DE LA RQT

-- print @name

EXECUTE(@RQT)

-- BD suivante

FETCH NEXT FROM DB_cursor INTO @name

END



-- FERMERTURE DU CURSEUR

CLOSE DB_cursor

DEALLOCATE DB_Cursor





If someone has an idea ...

View 4 Replies View Related

Reporting Services Stored Procedure Dataset

Sep 26, 2004

I have a big SQL Stored Procedure which works with a cursor inside of it. During the procedure the data is inserted into a table and at the end is a SELECT statement from that table. The problem is that when i create a dataset with that stored procedure and i run it in the Data tab i get the correct select, but in the Fields section of the Report I don't get the fields from the last SELECT, but the fields from the cursor. Am I doing something wrong or is this a bug and how can i fix it.
Thanks!

View 3 Replies View Related

Reporting Services :: 2 Dataset Tables In One Matrix?

Dec 2, 2015

I am having difficulties with what seems to be a common issue. I want to produce a trial balance. The first row of the tablix would include fields: AccountNo, Description and startingbalance from a dataset called tb. Below that, I would like to draw from a dataset called Entries with multiple rows having fields: AccountNo, Desc1, Desc2, Debit, Credit and Balance.     Balance in the Entries table is already computed from the starting balance and the entries above.  There are many AccountNo's with corresponding entries.  

How do I do this?

View 4 Replies View Related

Reporting Services :: Summarizing A Large Dataset

Apr 17, 2015

LOCALID - POSTCODE - GPCODE
PTO1395164 - DN34 1AB - G9999981
PTO1395164 - DN34 1AB - G9999981
PTO1395164 - DN34 1AB - G8909058
PTO1395164 - DN34 1AB - G8909058
PTO1395164 - DN34 1AB - G8909058
PTO1395164 - DN34 1AB - G8909058
PTO1395164 - DN34 1AB - G8909058
PTO1395164 - DN34 1AB - G8909058
PTO1395164 - DN34 1AB - G8909058
PTO1395164 - DN34 1AB - G8909058
PTO1395164 - TZ14 2AX - G8909058
PTO1395164 - TZ14 2AX - G8909058

The sample data above shows 1 customer with multiple episodes (different attend dates – not important here), during the course of these attendances they moved home and moved GP practice.

Is there a simple way in Access to show a summary of this eh PTO1395164 = 2 postcodes, 2 GP’s

THe ultimate aim would be to identify where a customer has changed postcode or GP within a selected timeframe and disregard the rest.

View 4 Replies View Related

Reporting Services :: Format Date From Different Dataset

Sep 21, 2015

What is wrong with this???

=Format(First(Fields!startdate.Value, "DataSet2"), "MM/dd/yyyy")

View 4 Replies View Related

Reporting Services :: Find If Value Exists In Dataset

Sep 9, 2015

I have textboxes that work as checkboxes on my form. I have a stored procedure that brings a set of values back. I need to see if the specific values are in the dataset. If so, I put an X in the textbox if that value is in the dataset. How do I do this? [URL] .....

View 3 Replies View Related

Reporting Services :: Passing Parameters To MDX Dataset

Oct 1, 2015

I have an MDX data-set query as follows: -

Member [Measures].[Measure3] As [Measures].[Value Rent Period Receipts]
Member [Measures].[Measure4] As (([Measures].[Value Rent Period Receipts]*-1)/[Measures].[Value Rent Period Debit])

Select {[Measures].[Measure1]
,[Measures].[Measure2]
,[Measures].[Measure3]

[Code] ....

There are two parameters; the value of lag passed to the LastPeriods function, and tenancy types passed in the where clause

I have a third parameter I would like to use called FirstDate and this I would like to pass to the LastPeriods function as the second argument

FirstDate is a value from my Time dimension, something like [Time].[Fiscal Time].[Sep. 15]

When editing the query to: -

Member [Measures].[Measure3] As [Measures].[Value Rent Period Receipts]
Member [Measures].[Measure4] As (([Measures].[Value Rent Period Receipts]*-1)/[Measures].[Value Rent Period Debit])
Select {[Measures].[Measure1]
,[Measures].[Measure2]

[Code] ....

The code errors. I have tried all sorts of formats such as  LastPeriods(@LagMonths,[@FirstDate]) and LastPeriods(@LagMonths,[Time].[Fiscal Time].[@FirstDate]), but nothing works

View 2 Replies View Related

Reporting Services :: Evaluate Two Values That Came From Different Dataset

Sep 17, 2015

I have an ssrs (report builder) with 2 dataset. the first dataset is a summary if records which the report has a column name qty and i put also a total qty summary in the last rows. the second dataset is a raw data and have a column name qty, also i put a total qty summary in the last row.  The requirements is to be able to evaluate or check the total qty under dataset1  from total qty of dataset2 if equal else if not equal i have to make the font as red so that the user will inform that the total qty has a discrepancy. the users will validate from raw data which are the one items that have a missing qty. How to work on this or is this appilcable in report builder.

View 4 Replies View Related

Does Reporting Services Allow You To Select A Dataset Dynamically?

Apr 30, 2007

I have a remote report ...
I need to call one of two stored procedures depending on which parameters were passed to the report. (Both stored procedures return the same fields.)
Does SQL Reporting Services allow you to switch the dataset or stored procedure name dynamically? If so, where do I put the logic? Right now I have it working with one stored procedure.
I'm thinking that I should just make one stored procedure that takes all parameters and calls one of the other two stored procedures. Do I have any options besides this?

Thanks in advance!

View 3 Replies View Related

Reporting Services :: Input Dataset To Pie Chart

Jun 10, 2015

Parent Name ID Soft Hard Primary VTM

XYZ 2 50 10 40 100
rtm 3 20 20 60 500
RMM 4 40 20 40 300

I have the above output. When I try to input this as a dataset to a pie chart I don't get the data lables for two slices of the pie chart. Only one slice will show the values when showing data label option is enabled.

For the Pie chart, I have added Soft, Hard and Primary as Values. I haven't added a Category group or a Series group. Why isn't this showing the data labels for the other slices?

Do I need to transform the dataset so that it has a category and the value like below?

XYZ,   2, Soft  50
XYZ ,  2, Hard, 10
XYZ,   2, Primary, 40

Will this work since it has a define category that I could insert for the chart.

View 7 Replies View Related

Reporting Services :: Select A Certain Row From Dataset Based On ID?

Oct 9, 2015

If I want to select a value from a certain row in my Dataset.

I have a dataset called labels in my Report. in this data set I have diffrent row and in each row I have a label with an

ID. For example:
ID                        Text
TEXT0001            Hi
TEXT0002            Good Morning
TEXT0003            Good bye

Is this is the right way to get the second row?

=First(Fields!ID.Value="TEXT0002", "Labels")

View 2 Replies View Related

Reporting Services :: Dataset Not Getting All Rows From Store Procedure

Jul 6, 2015

I created a data set using SP. in ssms SP gets all records but in ssrs i am not able to get all records, getting only 5 row.

View 4 Replies View Related

Reporting Services :: Display A Report From Another Dataset In Same List?

May 29, 2015

I would like to display different addresses in the same list:

I have the query for married couples working, Also, I have a separate query of non-married people working.I would like to create a separate datasets for unmarried people in the same report.-Is there way to setup another the second data set without duplicating the fields from the first datasource. I tried to use alias on the second datasets and it did not work okay.

View 3 Replies View Related

Reporting Services :: Dataset In Microsoft Report With Too Many Columns

Dec 1, 2015

I have a dataset with rows that I normally would display in a  table control. I have too many columns and I would like each data row to be display on many lines. How is that possible?

View 4 Replies View Related

Reporting Services :: Multiple Charts From A Single Dataset

May 20, 2015

I'm looking to build a report that is basically a series of line charts that is plotting a value over time.  I can accomplish this one chart/dataset at a time, but I believe with 'List's this can be achieved in a more automated fashion.If I have some data similar to this:

Area_ID, Location_Name, DataValue, ReadingDate
1,Site1,100,1990-10-10
1,Site1,110,1990-11-11
1,Site2,105,1994-01-07
1,Site2,105,1994-02-07
2,Site3,113,1994-06-02
2,Site3,120,1994-07-30
2,Site4,120,1994-06-30
2,Site4,120,1994-07-30

I want the charts grouped by the Area_ID, and then each Location_Name is a Series in that chart.  So in this example, I would end up with 2 charts (Areas 1 & 2), each have 2 series (Area 1: Site1, Site2 and Area 2: Site3, Site4)Is it possible to build this with a list? or do I need to structure the data differently?

View 6 Replies View Related

Queries In Dataset For Reporting Services Report Design

Mar 6, 2008



How can i write diffrent Queries in Data set using If...Else Conditions at the time of report Design.

Regards.

View 9 Replies View Related

Reporting Services :: How To Connect SSRS Report To Dataset

Oct 2, 2015

I have created multiple data sources and datasets in my SSrS project.  I created the datasets so I could use them as the basis for reports.  However, when I open the wizard to create a new report, I am always asked for a data source, and then have to renter the SQL code that I have stored in one of my datasets.  How can I have a report use an existing dataset as it source of data?  Otherwise, the datasets I created seem useless . . .

View 5 Replies View Related

Reporting Services :: Proper Way Of Referencing A Field In SSRS Dataset?

Jul 13, 2015

I am using SSRS 2014 SP1 x64 and VS2013 Update 5.

I have the following expressions to attempt to calculate ageing on a statement report.

=SUM(IIF(DateDiff("d", (Fields!OrderDate.Value, "Invoice"), Now())<=0, (Fields!LineAmount.Value, "Invoice"), 0))
=SUM(IIF(DateDiff("d", (Fields!OrderDate.Value, "Invoice"), now())>=1 and DateDiff("d", (Fields!OrderDate.Value, "Invoice"),Now())<=30, (Fields!LineAmount.Value, "Invoice"), 0))
=SUM(IIF(DateDiff("d", (Fields!OrderDate.Value, "Invoice"), now())>=31 and DateDiff("d", (Fields!OrderDate.Value, "Invoice"), Now())<=60, (Fields!LineAmount.Value, "Invoice"), 0))
=SUM(IIF(DateDiff("d", (Fields!OrderDate.Value, "Invoice"), now())>=61 and DateDiff("d", (Fields!OrderDate.Value, "Invoice"), Now())<=90, (Fields!LineAmount.Value, "Invoice"), 0))
=SUM(IIF(DateDiff("d", (Fields!OrderDate.Value, "Invoice"), now())>=91, (Fields!LineAmount.Value, "Invoice"), 0))

Now when I try to add First to the field selector I get an error stating ... uses a First, Last or Previous aggregate in an outer aggregate.

How exactly do I reference this field from the Invoice dataset (there are at least two datasets)?

View 5 Replies View Related







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