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
May 12, 2015
Could we use SSRS Shared Dataset as a source to the SSIS package?
View 3 Replies
View Related
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Sep 21, 2015
What is wrong with this???
=Format(First(Fields!startdate.Value, "DataSet2"), "MM/dd/yyyy")
View 4 Replies
View Related
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
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
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
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
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
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
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
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
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
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
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
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
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
