I need to use HTML OWC rendering extension as an export option. I typed the following entry in the RSReportServer.config and RSReportDesigner.config files, and nothing occurs. Some suggestion?<Extension Name="HTMLOWC" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.HtmlOWCRenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="false"/>
I have written a custom rendering extension for my reporting services. In one of my function inside custom rendering assembly, I want to access the underlying dataset and manipulate with it. I gain some knowledge on dataextension but not able to use it successfully. Can someone please help me get to underlying dataset?
Thanks.
Is Microsoft planning to include reporting services extensionsion for usering Sharepoint lists as datasource in MS SQL Server 2008?
And what about reporting services extension for building semantic model on Sharepoint lists?
-- Thanks,
I am running SQL Express Advanced addition on an XP pro box. The install went cleanly, and I have no problems creating and publishing reports that use a SQL server data source, however when I try and publish a report that uses an oracle data source I get the following error.
An attempt has been made to use a data extension 'ORACLE' that is not registered for this report server.
The report works fine withing the preview pain of Visual Studio, and it publishes fine within SQL 2005 standard edition.
Can someone please tell me how to register the data extension for ORACLE in SQL Express.
Thanks for your help
Robert Dennis
Hi guys!
I am having a problem with the e-mail delivery extension in MS SQL Reporting Services 2005. I have some reports that use an Oracle data source. When running the reports through Report Manager the data source works fine and the reports display properly. But when running an automatic e-mail delivery of the reports through a subscription I get the following error message (in the ReportServerService log file):
System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
Doesn't this seem strange when the reports run in Report Manager but not when I send the reports through e-mail? I have Oracle Instant client v. 10.2.0.3 installed on the machine. I am wondering if the e-mail delivery extension has an account that needs privilegies to the oracle client home directory or something like that. Any ideas?
Thanks!
/Stefan
When I am saving a SSRS report in excel format in a shared network drive, how can I add the date extension to the filename ?I assume this is something that needs to be handled within the SSRS reporting side rather than the subscription side.
View 5 Replies View RelatedI have created a custom data extension.
I am using this custom data extension from BI Studio.
Que1: I want to create report parameters from BI studio and capture them in my Data Extension.
Que2: Every report parameter has so many properties, like hidden, internal, default value etc, how do capture that information in my data extension, the parameters only give me name and value.
Que3: I know I can capture command Text. So My command can be Select * From tablename where fieldname= @myFieldname. Once I get this commandText in my data extension, How do extract parameters of the command?
Que4: If I have any custom attributes in my RDL file, Can I capture them in my Data Extension ?
Any help is appreciated...
in order to use an SSIS package as a data source in a report, I need to enable the SSIS extension in the RSReprotDesigner.config and RSReportServer.config files. That extension is in neither of these files. I have SSIS running on my machine with Reporting Services.
The path to RSReportServer.config: C:Program FilesMicrosoft SQL ServerMSRS10_50.MSSQLSERVERReporting ServicesReportServer
The path to RSReportDesigner.config: C:Program Files (x86)Microsoft Visual Studio 9.0Common7IDEPrivateAssemblies
Why is this extension not in either of these files?
The following is an abbreviated list of what's present in the RSReportServer.config file:
<Data>
<Extension Name="SQL"
<Extension Name="SQLAZURE"
<Extension Name="SQLPDW"
<Extension Name="OLEDB"
[Code] ....
The following is an abbreviated list of what present in the RSReporDesigner.config file:
<Data>
<Extension Name="SQL"
<Extension Name="SQLAZURE"
<Extension Name="SQLPDW"
<Extension Name="OLEDB"
[Code] ....
I'm running SQL Server 2008 R2
ProductVersion ProductLevel Edition 10.50.1600.1 RTM Enterprise Edition (64-bit)
The operating system is Windows 7 Professional 64 bit.
I installed SSRS 2014 Reporting Services on a 2008R2 Enterprise server. When I try to subscribe to a report (also SQL 2014), the default rendering is MHTML. I want to change this default to EXCEL.
I updated the rsreportserver.config file and restarted SQL Server Reporting Service. Now, the default rendering for a subscription is 'XML file with report data' which is the first <Render> data element. If I change
<DefaultRenderingExtension>EXCEL</DefaultRenderingExtension> back to <DefaultRenderingExtension>MHTML</DefaultRenderingExtension>
And restart SSRS Service, the default subscription rendering is MHTML.
<DeliveryUI>
<Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl,ReportingServicesEmailDeliveryProvider">
<DefaultDeliveryExtension>True</DefaultDeliveryExtension>
<Configuration>
[Code] ....
Using SSRS 2008R2 is it possible to change the file extension of a CSV data driven subscription? I'm outputting a text file with a .csv extension, but users have access to these files and I don;t want them opened with Excel and then saved back in an incorrect format.
These are the options I have from the report "manage" option.
I am using Custom Data Processing Extension to call a stored procedure. Iam getting following error when creating a dataset in report designer using the extension. I wrote the code in c#.
could not update a list of fields for the query. verify that you can connect to the data source and that your query syntax is correct.(Details-Object reference not set to an instance of an object.)
Here is my code
using System;
using System.Collections.Generic;
using System.Text;
using System.IO;
using System.Data;
[Code] .....
I am trying to fetch the sharepoint list data into the SSRS report.
I have given credentials in shared datasource to access remote datasource.
In preview i m getting the following error:
Data extension supports windows integrated security and no credentials only.
Hi,
I am trying the get the custom security extension samples to work on my machine. I have installed everything according the sameple help file. However, i am getting a "Authentication Ticket is not issued by LogonUser." error after I attempted to log on to the report manager thru UILogon.aspx page. I already created an admin user. Upon a closer inspection, I realized that the authentication went thru okay, however, the authentication Ticket Name contained in the "RSAuthenticationHeader" has a duplicate value of "sqlauthticket, sqlauthticket". So apparently, the report server added this value twice to the response header. Has anyone seen this error before? How would you fix it? Also to bypass this error, I parsed out the header and take the correct auth ticket name, now report manager just redisplays the logon page and not letting me thru. Has anyone have seen that before? I am running in Win 2003 server, IIS 6, .NET 2.0 and SQL server 2005 enterprise version.
Thanks for the help,
Eric
Currently we are using Custom Delivery Extension for SSRS 2008R2 We are planning to move it SSRS2012
My Question is: Whether we can use the same Code used for SSRS2008R2 to SSRS2012?
if not what code changes we should do?
Hello,
I am trying to migrate my reports from SQL server 2000 reporting services 32bit to 2005 64bit. I am following the migration steps that MS specified.
Restored my Reportserver and ReportserverTempDB databases
Then I was using the configure Report services to upgrade these databases but I always end up getting the follwoing exception when I run the upgrade on the "Database Setup" configuration for 'ReportServerTempDB' database
System.Data.SqlClient.SqlException: Could not locate entry in sysdatabases for database 'ReportServerTempDBTempDB'. No entry found with that name. Make sure that the name is entered correctly.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Common.DBUtils.ApplyScript(String connectionString, String script)
at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String connectionString, String script)
It's driving me crazy, why is it looking for 'ReportServerTempDBTempDB' in the catalog instead of 'ReportServerTempDB'?
Is it possible to migrate from 32bit to 64bit?
Any help is appreciated
What is Reporting Service Extension and how can I check that whether it is installed in my PC or not.
And if not then what is requirement for get it installed...?
Hi,
I have just install SQL 2005 SP2 and trying to get Window SharePoint Services V3 integrated with SQL 2005 SP2 reporting services.
In SharePoint Central Administration, I select the Reporting Services Integration page and have setup the Report Server Web Service URL and Authentication Mode. I then goto Grant database access, specify the SQL server name, get promted for a username and password that has access SQL Reportserver and get the following error "The group name could not be found"
Does anyone have any ideas?
Thanks
Hi All,
I'm trying to create reports in RS2005 using AS2000 as my data source. I understand that if I use RS2005 on AS2000, I wont be able to enjoy the OLAP based parameters as in using AS2005. Does anyone know an easy way to easily use Parameters in RS2005 while still using AS2000?
Regards,
Joseph
Hello,
i have a small problem with the data sources in the reporting services, maybe you can clarify the situation... I have a MS CRM 3 solution with the reporting services 2005 installed. From an other vendor we have a arcplan solution on the 2000 analysis services. I would like to get access from the 2005 reporting services to the 2000 cube. Is this possible? Ive read that the SSMS cant connect to the 2000 cubes. Can i connect from the reporting services??
thank you
regards
Andreas
I need help about this , What i've done so far is a data processing extension that gets its data from a WS , I use it as a datasource for a report , That report will be displayed withing an ASPX page containing a reportviewer control that displays that report , The problem is catching errors that occurs withing the data processing extension .. ,
When i debugged the extension i saw that after throwing an exception the code ends up inside the "cancel()" event inside the IDBcommand implementation...
In all examples for a data processing extension i could find online they always have a comment saying the cancel is not implemented and throw a NewUnsupportedExtension()..
What happens is i get some uninformative , non-userfriendly error from the reporting services ,
something like "an error occurred during the report processing(rssomehing)"
How should i go about handling those exception that happened inside the data processing extension?
I've tried catching the error inside the event of the reportviewercontrol - reporterror but it seems that event don't fire when those errors are generated..
Any help on how to approach this would be highly welcome
I am trying to import Access reports using Visual Studio 2005 and Access 2007. SQL Server 2005 with Reporting Services is also installed. I select Reports in the Solution Explorer and then Import Reports... Microsoft Access and browse to my Access database. After I select the database I see it open briefly as if it is trying to import the reports but then Access quickly closes and a error pops up: "You already have the database open." I have checked and double checked and the database is not open. I have even tried several different databases and the same errror occurs. Any help would be greatly appreciated.
Hi,
Can we install reporting services 2005 in a machine in which is not installed SQL server 2005.?
Thanks
Hello,
I'm trying to make some reports using the sql 2005 reporting services addin for Visual Web Developer Express 2005. I download the add-in here. So far it installed "successfully". The problem i have is when i try to add a datasource to the report at "Report > Data Sources... " it gives me an error saying: "The system cannot find the file specified."
Another Error it gives is that when I try to drag a DataSet field from the Website Data Sources toolbox tab the visual web developer crashes :/.
An observation that I don't know if this is ok is when I create a new Data Source it creates an App_Code folder inside where my report is /Reports/ and there it saves the DataSet. Just an observation...
This is my development enviorment:
Laptop:
Windows Vista Home Premium (Up to date)
Microsoft Visual Web Developer 2005 with Service Pack 1
Reporting Add-In for Microsoft Visual Web Developer 2005 Express
Server:
Microsoft Windows Server 2003
IIS 6.0
ASP.NET 2.0
Microsoft SQL Server 2005 Express
Reporting Services for SQL Server 2005 Express
Here are some pictures of the erros:
Error 1
Error 2
Please could someone help me fix this?
Thanks in advance.
Hi,
I want to get data from Oracle 10g Stored procedure to Reporting Services 2005. I could pass a SQL text and get a record set, but I want to execute a store proc and get the record set.
1. Add New Data Source
2. Choose Type : Oracle and connection tested OK
3. { call Test_Package.Test_Procedure(?) } is it wrong... how to write???
There is an error in the query. ORA-00911: invalid character
Also make sure that you use the text-based generic query designer (2 panes !) instead of the visual query designer (4 panes) - you can switch between them through an icon on the toolbar in the data view of report designer.
Question : I tried many methods but unable to solve it...
create or replace
PACKAGE Test_Package
AS TYPE Test_Type IS REF CURSOR RETURN Test_Table%ROWTYPE;
END Test_Package;
create or replace PROCEDURE Test_Procedure (
Test_Cursor IN OUT Test_Package.Test_Type,
Test_Parameter IN Test_Table.ID%TYPE
)
AS
BEGIN
OPEN Test_Cursor FOR
SELECT *
FROM Test_Table WHERE Test_Table.ID >= Test_Parameter;
END Test_Procedure;
The below site gave some example but i could not solve it... any suggestions greatly appreciated...
http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=357121&SiteID=17
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/bbc613c4529ed3cd/696624ec4ba70937?q=oracle+stored+procedures
I have a source file as filename.mar it is microsoft access report. When I am loading into my database the file name was something like filename.nov (its current month).
When I ran the package its shows error system cannot find the file filename.nov.
I use an execute sql task and excel connection manager to craete excel file.
Execute sql task:
In the connection:
It works. But when i choose file path to: C:1111.xlsx
And excel version to micorsoft excel 2007. When open the file it created,it promotes the format is not correct. How to solve this?
I'm using Report Builder to create a new report. The problem I'm having is that once I choose a Field from an Entity in the Entities list I can only choose Fields from that Entity. For example, I have two Entities, one called Customers and the other called Delivery. Within the Customer Entity I have several Fields that I want to add to my report, say First Name and Last Name. From the Delivery Entity I have a Status Field which I'd like to include but because I have no way to get back to my Entities list, without removing the Fields from my Report, I can't include that Field.
If I remove the Fields from my report, the Entities list then populates with both the Customers and Delivery Entities, THEN I can choose my Delivery Entity and select the Status Field. But I can't get back to the Customer Entity. I keep going back and forth.
I'm not exactly sure what I'm doing wrong, or if there is a more efficient manner to accomplish what I'm trying to do.
Thanks.
What is the best option to monitor user accesses to published reports? IT department wants to have an idea about the need (value and time) of produced reports.
Regards,
Vitor Mota
Hi,
View 7 Replies View RelatedHello All,
I am getting the following error while I am connecting SQL 2005 reporting services through local and outside
http://localhost/reports
http://servername/reprots
I configured through all the stems through reproting services configuration
You advise/suggestion is greately appriciated.
Ven
---------------------------------------
Server Error in '/Reports' Application.
--------------------------------------------------------------------------------
An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Exception: An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[Exception: An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.]
Microsoft.ReportingServices.Diagnostics.RSConfiguration.ThrowElementMissing(String element) +41
Microsoft.ReportingServices.Diagnostics.UIConfiguration.ParseXML(XmlNode node, RSConfiguration configObject) +1104
Microsoft.ReportingServices.Diagnostics.RSConfiguration.ParseDocument() +972
Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load() +32
[ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information.]
Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load() +166
Microsoft.ReportingServices.Diagnostics.RSConfiguration.Construct(String configFileName) +62
Microsoft.ReportingServices.Diagnostics.RSConfiguration..ctor(String configFileName, String location) +296
Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String configFileName, String configLocation) +134
Microsoft.ReportingServices.UI.Global.get_ConfigurationManager() +84
Microsoft.ReportingServices.UI.Global.get_Configuration() +4
Microsoft.ReportingServices.UI.GlobalApp.Application_AuthenticateRequest(Object sender, EventArgs e) +84
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64
Hi,
I am trying to use reporting services 2005 with a VB SQL stored procedure that i created in visual studio using CLR.
The stored procedure was created successfuly in SQL server but while linking the report to the stored procedure, i am receiving the following message
"An error occurred while retrieving the parameters in the query.
The stored procedure 'mysp' doesn't exist.
Thanxs in advance
I have a sql server 2000 database and sql server reporting services 2000 installed on it i want to install 2005 sql reporting services on sql server 2000 Is Sql server reporting services 2005 works fine with sql server 2000 and what are the settings that i have to perform.
I am trying to learn Reporting Services using the title "MS SQL Server 2005 Reporting Services Step by Step" by Stacia Misner and Hitachi Consulting, published in 2006. I am experiencing problems with some of the exercises. I got as far as Chapter 4 when I followed directions to create a SQL statement to define a query string for a dataset. Pg 80:
select * from vProductProfitability
where year = 2003 and
MonthNumberOfYear = 1
The view vProductProfitability does not exist in the tutorial database that came with the book, rs2005sbsDW. The result of this query is the basis for the entire chapter on developing basic reports and I'm being denied a learning opportunity because the view does not exist. In short, I'm stuck.
I have tried to find somewhere at Microsoft to place this question and get some answers so I can continue thru the tutorial. To no avail. Does anyone have any suggestions?
BTW, the solution that came in the CD is also wrong because the query noted above is also in the solution.
This humble grasshopper seeks wisdom.
Respectfully Submitted,
Dave Matthews
Atlanta, GA
aka FlooseMan Dave