Hi,
We are having a problem with the Excel renderer that comes with RS2005, It doesn't have an option to OmitHyperlinks so when we export files they come out over 20x the size they should be. So what I'm trying to do is write a Custom Renderer that will take in the Report Object, and Strip out the hyperlinks, then pass it on to the RS ExcelRenderer, but I ran into a little problem.
I'm looping through the ReportItems, and trying to clear out all the Hyperlinks but I keep getting this exception:
Operation is not valid due to the current state of the object.
This is the part of the code thats throwing up the exception.
I have to create a custom rendering extension for SQL Server 2005 Reporting Services.
I followed the instructions in the MSDN article: http://msdn.microsoft.com/msdnmag/issues/05/02/CustomRenderers/default.aspx
I am running the report server under an administrative account provileges on the local machine (XP Pro SP2). The Reporting Services is installed for SQL Server 2005 Trial/Evaluation Edition (not expired yet) and has been upgraded to Service Pack 2. The Report Manager runs under a default ASPNET account.
After deploying the extension according to instructions in the article, I see the custom renderer in the list of available rendering formats in the dropdown in the Report Manager.
However, when I select that renderer and click "Export", a new IE window opens with the following error message:
Server Error in '/Reports$SQLSERVER2005DEV' Application.
That assembly does not allow partially trusted callers. 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: That assembly does not allow partially trusted callers.
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: That assembly does not allow partially trusted callers.]
[Exception: An error occurred during rendering of the report.]
Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433
My "why is it not working" question basically breaks down to 3 questions:
1. Why does this error say "partially trusted" whereas the new element in the rssrvpolicy.config file explicitly asks for "FullTrust" permissions?
2. Is there any deployment step that I'm missing? [For now, it's: - copy-and-paste the dll into ReportServerin directory; - add a new CodeGroup element to the rssrvpolicy.config file; - add a new Extension element to the rsreportserver.config file; - IIS reset; - Reporting Services service restart.]
3. Also, I checked the deployment instructions in BOL (Deploying Rendering Extension: http://msdn2.microsoft.com/en-us/library/ms154516.aspx), just to make sure I didn't miss anything. An interesting this is, the BOL article does NOT mention a requirement for adding a new element into rssrvpolicy.config file. Is this an error in the September 2007 Books Online?
The same error (regarding "partically trusted" - see above) occurs even after I signed the assembly with a strong name key (although this is not mentioned in the articles, but I figured it might be necessary).
Could someone point me in the right direction as to how to properly deploy a custom rendering extension, please?
We have been successful in creating a custom Excel Renderer that works very well on a server configured for SSRS Native mode. However we have another server that is configured to work in SSRS integrated mode that we can not get this custom renderer to work properly. The steps we follow are:
After the report results are displayed we select Actions -> Export -> Excel Custom . So I can see the name of our custom rendering type. After a very short amount of time (no more than a second or 2) I get a frame that says: an unexpected error has occurred. Here is the URL of the web site:
Is there anything that has to be done differently to get a custom renderer to work in SharePoint integrated mode?
Note: here is the article we followed to initially create the renderer that will work in SSRS native mode: http://msdn.microsoft.com/msdnmag/issues/05/02/CustomRenderers/
I have been struggling to deploy a custom rendering extension onto Reporting services 2005. I have followed all the steps given in the MSDN article http://msdn.microsoft.com/msdnmag/issues/05/02/customrenderers/defaul...
Especially -
1. Copied the dll generated to the reporting service bin folder.
2. Made the entry in C:Program FilesMicrosoft SQL ServerMSSQL. 3Reporting ServicesReportServer sreportserver.config file as <Extension Name="CUSTOM_RENDERER" Type="MSDNMagazine.CustomRSRenderer.Renderer,MSDNMagazine.CustomRSRenderer"/
3. Made an entry in C:Program FilesMicrosoft SQL ServerMSSQL. 3Reporting ServicesReportServer ssrvpolicy.config file as
<CodeGroup class="UnionCodeGroup" version="1" PermissionSetName="FullTrust" Name="Custom Render Extension" Description="This code group grants data extensions full trust."> <IMembershipCondition class="UrlMembershipCondition" version="1" Url="C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting Services ReportServerinMSDNMagazine.CustomRSRenderer.dll"/> </CodeGroup>
I am able to see the extension being listed in the Report manager list of available rendering options, But I get the following error from the report server when I try exporting to the custom rendering extension
An attempt has been made to use a rendering extension that is not registered for this report server. 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 attempt has been made to use a rendering extension that is not registered for this report server.
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 attempt has been made to use a rendering extension that is not registered for this report server.] Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension) +489 Microsoft.Reporting.WebForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension) +958
Looking at the logs of the report server at Max trace level, gives me the following dump
w3wp!processing!b!03/01/2007-22:35:22:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An attempt has been made to use a rendering extension that is not registered for this report server., ; Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An attempt has been made to use a rendering extension that is not registered for this report server. w3wp!chunks!b!03/01/2007-22:35:22:: v VERBOSE: ### ID=3f94a6f1-8ff7-448c-8cf3-494ab8fe4837, Length=0, CompressedLength=0, TimeCompressing=0, TimeUncompressing=0, Ratio=0, Buffering=0, Permanent=False w3wp!library!b!03/01/2007-22:35:22:: v VERBOSE: Transaction rollback. w3wp!webserver!b!03/01/2007-22:35:22:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An attempt has been made to use a rendering extension that is not registered for this report server. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An attempt has been made to use a rendering extension that is not registered for this report server. at Microsoft.ReportingServices.ReportProcessing.ReportRendererFactory.GetRenderer(String format, IReportServerInformation serverInfo) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.CreateRenderer(String format) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk createChunkCallback, RenderingContext rc, GetResource getResourceCallback) at Microsoft.ReportingServices.Library.RenderSnapshotAction.Render() at Microsoft.ReportingServices.Library.RSService.RenderFromSessionNoCache(CatalogItemContext reportContext, ClientRequest session, RenderingResult& result) at Microsoft.ReportingServices.Library.RSService.RenderFromSession(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters) at Microsoft.ReportingServices.Library.RSService.RenderNext(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effecectiveParameters, String[]& secondaryStreamNames) at Microsoft.ReportingServices.Library.RenderNextCancelableStep.Execute() at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper() --- End of inner exception stack trace --- at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper() at Microsoft.ReportingServices.Library.RenderNextCancelableStep.RenderNext(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobType type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames) at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory) at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation) at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType) at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent() at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage() w3wp!dbcleanup!9!3/1/2007-22:35:41:: v VERBOSE: Starting database cleanup. w3wp!library!9!3/1/2007-22:35:41:: v VERBOSE: Call to CleanBatch() w3wp!dbcleanup!9!3/1/2007-22:35:41:: v VERBOSE: Cleaning expired sessions from DB w3wp!library!9!3/1/2007-22:35:41:: v VERBOSE: Transaction begin. w3wp!library!9!3/1/2007-22:35:41:: v VERBOSE: Transaction commit. w3wp!dbcleanup!9!3/1/2007-22:35:41:: v VERBOSE: Cleaning expired cache from DB w3wp!library!9!3/1/2007-22:35:41:: v VERBOSE: Transaction begin. w3wp!library!9!3/1/2007-22:35:41:: v VERBOSE: Transaction commit. w3wp!dbcleanup!9!3/1/2007-22:35:41:: v VERBOSE: Cleaning orphaned snapshots from DB w3wp!library!9!3/1/2007-22:35:41:: v VERBOSE: Transaction begin. w3wp!library!9!3/1/2007-22:35:41:: v VERBOSE: Transaction commit. w3wp!library!9!3/1/2007-22:35:41:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams w3wp!dbcleanup!9!3/1/2007-22:35:41:: v VERBOSE: Database cleanup executed.
Im working through the MS example of "removeDuplicates". I cant seem to figure out how to add custom property for input column.
I added the helper method: private static void AddIsKeyCustomPropertyToInput(IDTSInput90 input, object value) { IDTSCustomProperty90 isKey = input.CustomPropertyCollection.New(); isKey.Name = "IsKey"; isKey.Value = value; } I call it from: public override void ProvideComponentProperties() { //... AddIsKeyCustomPropertyToInput(input, false); //... } public override void ReinitializeMetaData() { IDTSInput90 input = ComponentMetaData.InputCollection[0]; if (input.CustomPropertyCollection.Count == 0) { AddIsKeyCustomPropertyToInput(input, false); } // ... }
However when I deployed it and added the component to SSIS package - I cant see the Custom Column "IsKey" in the input column properties window. What am I missing - please help
I got a pre-formated excel sheet as destination. The header is formatted with color.
The requirement is to populate the excel sheet with different data type (name(string), no (int), sal(int), age(int)) from second row onwards. The source data is a SQL table and I am using SSIS to export data to the above excel destination.
Problem: Scenario 1: Using SSIS data flow, populate the excel sheet. In this case, the format of the first row is used by all the new inserted records. So, I am not able to format as per the data type requirement.
Scenario 2: To populate data with required data types, I need to format the second row with the specified data types and then export data into the excel in the SSIS data flow. In this case, there is a blank row in the second row position as shown in the picture: (see the picture on url) http://picasaweb.google.co.uk/h.zulfi/SsisExcel/photo#5171040908106882370
To meet the requirement, I need to remove the blank row in the excel destination. It should look like below: http://picasaweb.google.co.uk/h.zulfi/SsisExcel/photo#5171040912401849682 Is there any other method to achieve the export of data meeting the specified requirement?
If no, then is there any method to remove the blank row from excel apart from using com objects to remove the blank row and shift cells up right.
Any thought and help in this regard would be much appreciated.
We are experiencing problems with reporting services built-in Export to Excel. Basically, the columns get wrapped in Excel, which frustrates users who need to pivot and sort(ie the point of downloading to Excel). Is there a method for removing the column wrapping? Please help
I have a problem when exporting a report to Excel.
The problem is with the custom formatting. The report has a field named amount with its format property = C (on the properties window of the textbox in the report designer). When the user exports the report everything seems ok, calculations and so on... but the problem is when from another workbook a cell makes a reference to the cell amount of the exported report. The exported report, has this format [$-1010409]$#,##0.00;($#,##0.00) on the amount cell. In fact every format type of the report designer, begins with [$-1010409].
To reproduce this error:
Make a simple rdl with a textbox format C. Export it to excel. Create a new workbook and make a cell reference to the exported report formated textbox cell (='\ComputerFolder[ExportedReport.xls]Sheet1'!$E$15). Close the exported report and the new workbook, open the new workbook (not the exported one) and update the reference. Results in a #Ref error.
I am using RGB HEX #s in my report for some colors. It shows up fine when rendering to a browser, however when exporting to Excel my custom colors don't come over. I've tried creating a report.xlt file with my custom colors in it, but when I export to Excel it uses the standard Excel palette instead of the custom palette in my report.xlt.
Any ideas on how to retain my custom colors when exporting to Excel?
Exporting a report to Excel has a lot of issues with appearance. As a result, I created an Excel template that I would like to use when the user selects to export the report to Excel, using the reportViewer toolbar. I haven't found any documentation thus far on how to accomplish this. Does anyone know whether this is possible with SSRS and if so can you please provide information as to how it is accomplished. I have created a similar post where my application code can be reviewed: http://forums.asp.net/t/1183977.aspx
I have a database that has SQL 2000 as the engine and Access 2003 on the front end, we scan our documents and hyperlink them through Access, the address is stored in SQL Server but we are wanting to move SQL, the scanned documents along witht he ADP over to a different server so instead of the files linking to \gcfso1 they will link to \gcfsql. is there a way to update the address link in SqL to link to \gcfsql as an update view rather then relinking them by hand????
sri writes "Suppose I have a table to enter the name,number,address of employees in different coloumns.I want the names to be as hyperlink.how can i get that? should we do that at the time of creating database?or do we need to write the code? If we have to write code please let me know the code also."
Does anyone know how to add a hyperlink with a target frame. In the navigation tab of reporting services I am having difficulites adding http://www.linkgoeshere.com target="framename"
Hello, Im running into some frustrations with the Jump to Hyperlink feature in SSRS. I have a report containing hyperlinks to a URL. Just to keep it simple for now, Ive made that URL http://www.google.com.
Below is the javascript Im using as my expression value to create the hyperlink on the report:
The hyperlink works fine when its parent report is not loaded into a frame; a new browser window opens and loads up Google as expected. But as soon as the parent report is loaded into a frame, the hyperlink doesnt respond at all. I click, and the page just sits there, no error message, nothing. Ive combed quite a few posts and cant come up with any thing that works other than to remove the parent report from the frame and load it into its own browser window. Unfortunately I have to make this work in a frame, because the entire website hinges on this design.
Any ideas as to why the report hyperlinks just seem to go dead when called from a report that resides inside a frame?
Recently we upgraded to SSRS-2008 R2 from SSRS-2008 (enterprise edition) and noticed that all the underlines for hyper-links in all reports are missing. Also the font color has reset back to default color (had set to blue to indicate a hyperlink).
Redeployed the same report from VS-2008 SP1 but no luck. Although the formatting (color + underline) looks ok in the preview mode in VS.if there's any workarounds as many end users are getting confued with this change.
I am trying to replace names found in 'xml' field name as hyperlinks, by matching with the names in database_tags.I am using the following function below, however the UDF is only recognizing one name from the XML fieldname data, instead of all the names present in the XML data.
ALTER FUNCTION [dbo].[ReplaceTags](@XML VARCHAR(MAX)) RETURNS VARCHAR(MAX) AS BEGIN
[code]...
for example, if the XML input data is the following: It consists of: BANKP, BCJA, BCJAM, BFTH, BFTH, and EMPOP.But the updated function is only recognizing two of names BFTH, BFTH, as hyperlinks, from the database_tags table.Is there a way to get the function to recognize more than one names as hyperlinks.
I am creating a custom transformation component, and a custom user interface for that component.
In my custom UI, I want to show the custom properties, and allow users to edit these properties similar to how the advanced editor shows the properties.
I know in my UI I need to create a "Property Grid". In the properties of this grid, I can select the object I want to display data for, however, the only objects that appear are the objects that I have already created within this UI, and not the actual component object with the custom properties.
How do I go about getting the properties for my transformation component listed in this property grid?
I tried to remove AdventureWorksDB in the "Add or Remove Programs" of Contol Panel and I got the following errors: (1) AdventureWorksDB Error 1326: Error getting file security: CProgram FilesMicrosoft SQL ServerMSSQL1MSSQLGetLastError: 5. |OK| and (2) Add or Remove Programs Fatal Error during installation (after I clicked the |OK| button). Please help and tell me how I can solve this problem.
I have uninstalled the CTP version of the SQL Server express so that I can install the released version but CTP version is still listed in the add/remove program list but without the change/remove button. I have been to different sites to find information on cleaning this up and I have ran all the uninstall tool I can find but the problem still prevails. I cannot install the released version without completely getting rid of the CTP version. Please help anyone.
I am having a hard time removing my SQL instance inside the Add/Remove program. After i select the SQL Instance name and then I tried to remove it but it won't allow me to delete it. There isn't any error message or whatsoever. Actually, when i try to log it in my SQL Management studio, that certain sql instance name is not existing according to the message box. Is there any way to remove the Sql Instance in my system?
Is it possible to add hyperlinks to the Report Manager Home Page that link to other aspx pages? I have created some associated data entry aspx pages that I want to enable access to from the Report Manager Home Page (if possible).
What I want to accomplish is that at design time the designer can enter a value for some custom property on my custom task and that this value is accessed at executing time.
I am writing a custom task that has some custom properties. I would like to parameterize these properties i.e. read from a varaible, so I can change these variables from a config file during runtime.
I read the documentation and it says if we set the ExpressionType to CPET_NOTIFY, it should work, but it does not seem to work. Not sure if I am missing anything. Can someone please help me?
In the Editor of my custom task, under custom properties section, I expected a button with 3 dots, to click & pop-up so we can specify the expression or at least so it evaluates the variables if we give @[User::VaraibleName]
Trying to upload excel in server where excel is not installed. BIDs was there in the server, when i am trying to craete Excel source I am not able.what the workround for this.. How to upload excel without excel installed on the server.
I am using a Excel Source to get the data from an excel file to sql server 2005 table. A couple columns are coming in a double precision float, but some values have characters in them, but those values are coming out as null, even though I changed the datatype from float to unicode string. Any inputs on resolving this will be much appreciated.
We have 10 sheets in Excel File and 10 sheet contains errror data. How to load 9 sheets data in to 1 destination and error data in to other destination?
I am trying to get the contents of the Excel Files dynamically and dumping into the SQL Database using SSIS. Through WMI Event Watcher, I could find when one or more Excel files dumped in a particular folder and using ForEach Loop Container I was able to take all the filenames and pass it through Variables. But at the same time in the Data Flow, I have to pass each Sheet of an Excel File to the Excel Source control and export the data to my SQL Database using OLEDB Destination.
For that I need to get the names of each sheets in an Excel File and pass it to the Excel Source Control through variables. But when I give Data Access Mode as "Table name or view name variable" and provide the variable name in that, then it is giving an error message as "A destination table name has not been provided".
And at the same time, Since I was not able to provide an static Filename (as I am passing through Variables), when I tried to map the columns in the OleDB Destination, it is not allowing me to map the columns.
So all these things I should do at Run-time using Variables in SSIS. I don't want to hard-code any filenames or Sheet names. If any one of you have a solution, please share with me.
l've some excel files controlled by Vendor which changing frequently. The only thing does not change is the header name of each column.
So my question is, is there any way to create a new table based on the excel file selected including the column name in SSIS? So that l can use the data reader as source to select those columns l am interested on and start the integration.
i have an SSIS package that exports to an excel file. This works fine. the problem is that it appends the data instead of overwriting the file. Is there any way to overwrite the file like you can with a flat file? I have to email the file everyweek and don't want to have to clear it out manually. Any help would be appreciated
