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.
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] ....
I'm trying to add a custom report format to ssrs 2005 as per this [URL] I've added the code snippets in the example to three different ssrs 2005 server RSReportServer.config files but it does not work i.e do not show up in the export drop down when rendering report.
I've tried starting and stopping reporting services and it still does not works.
I've also modified the existing csv extension with different options to see if it works but to no avail.However it works with SSRS2008 R2 . In fact it works right after I saved the config file, no restart needed.For SSRS2005 the file is in C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServer. I checked the registry setting just to make sure I'm looking at the correct installation 'HKEY_LOCAL_MACHINE', 'SOFTWAREMicrosoftMicrosoft SQL Server90ToolsClientSetup', 'SQLPath' The three ssrs2005 instances are in three different physical servers and the problem is with all of them so it is not an isolated incident. I've dbowner rights to all three servers. The server versions are 9.0.4060, 9.0.4035 and 9.0.4053
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?
My system environment: win2008 R2 SP1 64bit + SQL 2005 SP4 32bit
I amended the configuration file of rsreportserver.config with the below:
<Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering" >
<Configuration>
<DeviceInfo>
<Encoding>UTF-8</Encoding>
</DeviceInfo>
</Configuration>
</Extension>
If I run the report and then click export by selecting the csv format, it looks ok with the encoding of UTF-8.
However, the same report , when I created a subscription and saved it in the hard driver. Its encoding became USC-2 Little Endian.
I have a image in SSRS which is of PNG in format. when I preview the image it is coming as expected but if I export that to PDF the image is having the black color back ground. One more point to be noted here is my actual image file is having a small shading in it which is not visible properly, but the same back ground is coming with full black color line in the PDF form.
Another issue is : I have 3 sub reports in my SSRS report. In the preview I can see the data is coming in order of sub reports but if I export it to PDF the second sub-report data is coming at the end of the report and first and 3rd sub reports are fine. But If I have only one record for 2nd sub-report the order is same in both the Preview page as well as in the PDF format.
I have some HTML stored in a SQL Server table that I want to render in Reporting Services 2008,
HTML data contain HTML table. While generating report, SSRS not able to render it properly as table.
How we can display the HTML data as it is in SSRS 2008?
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] .....
Is there a support of printing report with matrix that is set to RTL (LayoutDirection) which displays in ReportViewr control with property RightToLeft set to RightToLeft.Yes in DisplayMode = PrintLayout.
The report looks fine in the report viewr in DisplayMode = Normal, but when goes to PrintLayout, it seems that the left data on page is rendered first.
Example: This is the display of the report viewer, I would like to print the columns by the same order it displays here:
And this is the result when clicking Print Preview: the first page displays the data of the last columns and if i go to the last page (page 9) i will see the data of the first column as displays in the previous gif, I don't have a clue why?
Is there a property that can be set to force the print layout to render RTL. Anyway, it seem to me as a bug since the Report Viewer displays the data correctly and renders the data RTL as expected.
I have scoured the Microsoft forums and the internet to find out how I can generate the output of a CSV report that has double quotes around each value and is comma separated as follows:
"Abcd","123456","Efghi","789012","JKLMN"
If I try to concatenate double quotes around the values in the stored procedure or in the RDL, two double quotes appear around each value as follows.
""Abcd"",""123456"",""Efghi"",""789012"",""JKLMN""
I understand that this is because the default qualifier is double quote. What I see is that every time a double quote appears in a value (along with commas and line breaks), the qualifier will activate. Is there any way to turn this off for double quotes?
If I try to enter: <Qualifier>false</Qualifier>, the word "false" appears as the qualifier instead.
The only way I have found that produces a result similar to what I need ("Abcd","123456","Efghi","789012","JKLMN") is if I add a line break - chr(10) in the RDL in each field. However, this won't work for me because I can't have line breaks in each field in the output.
Note that in SSRS 2005, I was able to produce the report output as I state above by setting the field delimiter and qualifier as follows:
<FieldDelimiter>@?!?@</FieldDelimiter>
<Qualifier>?#^?</Qualifier>
This essentially turned the field delimiter and qualifier off, as the values entered would never appear in the data. I then could add double quotes and commas in the RDL. This used to work in the old version but does not anymore.
I have a chart with series that needs conditional colour for three conditions. One condition must be transparent. I have tried the various IFF or SWITCH expressions below and some work fine in SSDT but when I deploy them to the browser the formatting is lost. This simple IFF expression works. The series is transparent as required both in SSDT (Visual Studio BIDS) and IE11 and Firefox browsers but I need two other conditions.
=IIF(Fields!ExhibitionID.Value = -1, "#00ffffff", "Red")
Both of the expressions below work in SSDT (Visual Studio BIDS) as expected but when deployed to the browser none of this formatting is rendered and all series are in blues even the ‘transparent’ series. No red at all.
=IIF(Fields!ExhibitionID.Value = -1,"#00ffffff", IIF(Fields!ExhDepartment.Value = 27,"Orange","Red"))
=Switch(Fields!ExhibitionID.Value
= -1,"#00ffffff",Fields!ExhDepartment.Value = 27,"Orange",(Fields!ExhDepartment.Value <> 27) AND (Fields!ExhibitionID.Value <> -1),"Red")
I have tried deleting various files RDL and DATA. I have tried uploading the file from report manager in IE and I have tried editing the file in report manager.
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 designed a fairly simple report in report designer that uses an analysis services cube as its input, and a basic matrix object as the primary design component. Cube performance either via object browser in Analysis Services or via connection from Excel is great. It does exactly what you build a cube for, i.e. it builds aggregations you can get to quickly. However rendering from a report designer report within Report Manager is a different story.
Even though this report is being rendered from an execution snapshot, it is painfully slow at opening and closing different levels of drill down. The report does have six levels of drill down, which I am sure is a factor. If I use a smaller dataset, performance does become more acceptable. However, I don't consider the requirements of my report to be all that extraordinary.
My conclusion thus far is that larger data sets with many possible page renderings are not the best candidates for HTML rendered reports. In this case Microsoft's cube analysis add-in to Excel might be a better choice. Thoughts and feedback on either how to improve the rendering speed or other presentation alternatives that would perform better would all be welcome.
I'm using Reporting Services 2005 SP1 and wrote some code to render reports server-side.
My sample report has few parameters that must be passed so I pass these parameters with code.
<My code>
ReportServiceExecution.ReportExecutionService rs = new ReportServiceExecution.ReportExecutionService();
rs.Credentials = System.Net.CredentialCache.DefaultCredentials;
string extension, mimeType, encoding;
ReportServiceExecution.Warning[] warnings;
string[] streamID;
ParameterValue[] parameters = new ParameterValue[2];
parameters[0] = new ParameterValue();
parameters[0].Name = "pID";
parameters[0].Value = "6548747";
parameters[1] = new ParameterValue();
parameters[1].Name = "pClass";
parameters[1].Value = "8";
ExecutionHeader header = new ExecutionHeader();
ExecutionInfo executionInfo = rs.LoadReport(reportPayslip.Name, null);
executionInfo = rs.SetExecutionParameters(parameters, "en-us");
rs.ExecutionHeaderValue = header;
rs.ExecutionHeaderValue.ExecutionID = executionInfo.ExecutionID;
byte[] report = rs.Render("PDF", "<DeviceInfo><Toolbar>False</Toolbar></DeviceInfo>", out extension, out mimeType, out encoding, out warnings, out streamID);
</My code>
Actually, I have several more parameters but I've checked the collection and all the parameters I want are there and have values. Their names match those found in executionInfo.Parameters. But when I run my code I get the following error on Render():
<Error>
"This report requires a default or user-defined value for the report parameter 'pClass'. To run or subscribe to this report, you must provide a parameter value. ---> This report requires a default or user-defined value for the report parameter 'pClass'. To run or subscribe to this report, you must provide a parameter value. ---> This report requires a default or user-defined value for the report parameter 'pClass'. To run or subscribe to this report, you must provide a parameter value."
</Error>
I've double-checked and my parameter array does have the problematic parameter, I passed it a value but when I check executionInfo.Parameters I see that it's the only parameter that hasn't been give a default value after calling SetExecutionParameters(). So my parameters do seem to be passed but one seems to refuse getting a value. If I comment out the SetExecutionParameters() line I get, as expected a similar error but on another parameter (first one in the executionInfo.Parameters collection). So I'm left to beleive that the SetExecutionParameters() has some kind of bug as it works for all but one parameter. I've checked casing, spelling, tried passing phony parameters and from what I've seen I should be getting an error when I pass the parameters if I got something wrong.
Any help would be much appreciated.
hi,
I have a trouble in filtering with SQL reporting services 2005 (SSRS). Please help me in clearing this issue.
I have a textbox and an dropdownbox with all the column names of a table in it. I will be entering some text in the textbox and will select a column name in the dropdownbox. I should get a result by checking the value of the textbox in the selected colum from the dropdownbox.
I give the query in where condition as: "(@dropdownvalue LIKE @Textboxname) ", which is not working.
Thanks in advance,
John.
In SSRS 2005, how to get the address bar URL. Is there any built-in function?
View 7 Replies View RelatedWe use Reporting Services for most of our reporting needs internally. However, we do have several products that we ship out into the field that run off local databases. These applications require reporting but often are not big enough for SQL Server and rarely run on a server with IIS.
Since MS has made .RDL an open xml standard does anyone know if there are any client rendering engines being developed? We would like the ability to develop all of our reports in .RDL and have them rendered in Reporting Services or in our standalone apps that run off MSDE or Access. Currently this is not possible. But, I think that someone could write a client renderer (like Crystal Reports has) to allow the use of .RDL files off a local data source without SQL Server and Web Services.
Thanks for any info on the subject.
Smoke
I have created reports using Reporting Services and the problem I am having is with the Print Layout. I view a report with parameters and print. I then change the parameters and click 'View Report' again and the new report is displayed. However, the report does not refresh in the Print Layout, so if I try to print the 2nd report, the first report is the one that is printed. Any ideas how to solve this?
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,
When rendering extension for RTF or Doc or WordML will be available?
Will it be released in service pack for SQL2K5 or it will be released in next version of SQL Server?
Hi,
I'm using SSRS 2005 which connects to SQL Server 2005. I need to pass Multi valus for single parameter...
E.g. Command type : Text
SELECT * FROM COUNTRY where CountryId IN ( @CountryID)
If i tried to preview using single parameter, it shows the record without any problem. However when i tried to put multi values, it gives error message?? I read somewhere which says, need to set to multivalue. But, i could not find the place to set the multi value option...
How to solve it?? Your suggestion/recommendations greatly appreciated.
Thanks
rama
Hi All,
I installed SQL Server 2005 SP2 recently. After that when I try to
deploy a solution in SSRS 2005, I get a dialog box with title:
"Reporting Services Login". It has my server listed as the first row:
"http://localhost/reportserver" and then it has two text boxes asking
for Username and Password.
I checked my IIS settings and only Integrated Security is checked for
the Reports Server folder (and for the entire website). I tried to
change that to Allow Anonymous Access = Checked, but still the same
problem.
Any ideas?
Thanks! GB
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
Does someone of you know a rendering extension for ppt. Any integrated or third party componens ?
The management wants to have the reports as powerpoint presentation
Best regards
HANNES
I am building reports using MS Visual Studio, and in the Preview tab I have the Refresh button and a button with a X to stop a report while rendering. However, when I deploy the report to the reporting server and I run it from the application the X button is not there, and users would find it useful sometimes to be able to stop long running reports. Is this a configuration change?
View 2 Replies View RelatedWe're migrating from SSRS 2005 to SSRS 2008. We use itextsharp (a pdf processing library) to merge different PDF outputs into one large PDF file. This was working brilliantly in SSRS 2005, but in SSRS 2008, itextsharp *can* open and parse the PDF, but itext sees the "content" section of the PDF pages as blank. So, the resulting composite PDF ends up being a series of blank pages. Acrobat 9 and a couple other PDF tools (tested linux Evince and win GIMP) seem to be able to open the SSRS 2008-generated PDF fine, but the java-version of itext, and the .net version of itext (itextsharp) see nothing but blanks.So, I realize this points to a problem with itext, but I'm curious if merging PDFS outputed from SSRS 2008, and what PDF tools/libraries they are using.
View 7 Replies View RelatedWhen 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.
We are using RS2005 for a year now and never had any problems especially with mail subscriptions.
Since we transferred from single RS machine to web farm everything works ok except mail subscriptions. Subscription sometimes (?!?!?!?!) refuse to export report to a document of any kind. I repeat that this is a random thing which is more often with PDF and less with Web Archive or Excel. We are using shared schedules and on demand execution of AddEvent stored procedure by night batches to send mail to users. Also, original error from RS log says something that this kind of operation is not supported for server working in native mode. We don't have SharePoint so we never used it in any other way then native mode and it worked.
Any idea will be appreciated!
Thanks in advance.
Update 26.06.2007
It seems that problem is not loading dll used to export report to a file but loading email subscription extension (dll that needs to be loaded for execution of email subscription.)
Original error from RS Log:
w3wp!library!1!06/22/2007-11:06:43:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedNativeModeException: The operation is not supported on a report server that runs in native mode., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedNativeModeException: The operation is not supported on a report server that runs in native mode.
w3wp!extensionfactory!1!06/22/2007-11:06:43:: e ERROR: Exception caught instantiating Report Server DocumentLibrary report server extension: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.TypeInitializationException: The type initializer for 'Microsoft.ReportingServices.SharePoint.SharePointDeliveryExtension.DocumentLibraryProvider' threw an exception. ---> Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedNativeModeException: The operation is not supported on a report server that runs in native mode.
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor, Boolean& bNeedSecurityCheck)
at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean fillCache)
at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean fillCache)
at System.Activator.CreateInstance(Type type, Boolean nonPublic)
at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
at System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
at Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.CreateExtensionObject(Extension extConfig).
I want to Set Rendering Extension Report based,
Example
Report 1 should have the rendering options of EXCEL and PDF.
Report 2 should have the rendering extension of EXCEL only.
I referred below link for change the rendering extension. [URL] .... but its for all the reports format.
Hi everyone,
Our system is set up using SQL Server 2000 and Reporting Services for SQL Server 2000. Our web application is built with Visual Studio 2003, C# and .Net Framework 1.1 and is a 3-tier application. On both our localhost and development builds of the application, the images that get rendered do show up properly. On our live build, the images do not.
One difference that we found is that on the live build, users do not have file permission access to our middle tier that is running reporting services. After examining the URL of where the image is trying to point to, we see that it is trying to access the middle tier from the front presentation tier.
My question is, is there a way to send a certain parameter into the Render method to have the images stored somewhere else? Any help would be greatly appreaciated. Here is the code we currently have:
ReportingService rs = new ReportingService();
rs.Credentials = System.Net.CredentialCache.DefaultCredentials;
try
{
//Response.Write("Format: " + format);
if (format == "HTML4.0")
{
// Render arguments
byte[] result = null;
string historyID = null;
string devInfo = "<DeviceInfo><HTMLFragment>True</HTMLFragment></DeviceInfo>";
DataSourceCredentials[] credentials = null;
string showHideToggle = "true";
string encoding;
string mimeType;
Warning[] warnings = null;
ParameterValue[] reportHistoryParameters = null;
string[] streamIDs = null;
ParameterValue[] reportParameters = null;
SessionHeader sh = new SessionHeader();
reportParameters = new ParameterValue[5];
reportParameters[0] = new ParameterValue();
reportParameters[0].Name = "par_userID";
reportParameters[0].Value = userID;
reportParameters[1] = new ParameterValue();
reportParameters[1].Name = "par_menuID";
reportParameters[1].Value = menuID;
reportParameters[2] = new ParameterValue();
reportParameters[2].Name = "par_URL";
reportParameters[2].Value = reportURL;
reportParameters[3] = new ParameterValue();
reportParameters[3].Name = "par_startPage";
reportParameters[3].Value = startPage;
reportParameters[4] = new ParameterValue();
reportParameters[4].Name = "par_endPage";
reportParameters[4].Value = endPage;
//Clean up old files
RemoveFiles(ConfigurationSettings.AppSettings["tempFileLocation"]);
result = rs.Render(reportPath,
format,
historyID,
devInfo,
reportParameters,
credentials,
showHideToggle,
out encoding,
out mimeType,
out reportHistoryParameters,
out warnings,
out streamIDs);
// // For each image stream returned by the call to render,
// // render the stream and save it to the application root
// byte[] image;
// string optionalString = null;
// string tempFilePath = ConfigurationSettings.AppSettings["tempFileLocation"].ToString();
//
// foreach (string streamID in streamIDs)
// {
// image = rs.RenderStream(reportPath,
// "HTML4.0",
// streamID,
// null,
// null,
// reportHistoryParameters,
// out optionalString,
// out optionalString);
//
// FileStream stream = File.OpenWrite(tempFilePath + streamID + ".png");
// stream.Write(image, 0, image.Length);
// stream.Close();
// }
// Write the results to the current Web page
string htmlout = Encoding.ASCII.GetString(result);
htmlout = htmlout.Replace("<hr/>", "");
rs.Dispose();
return htmlout;
}