Authenticating To Report Server From A Custom Asp.net App
Feb 18, 2008
I have tried to search on the topic, but there's a variety of answers that has left me a bit confused, so let me try asking a-new...
I have RS 2005 installed (Report Server on one server with IIS and everything else, Integrated Security set; the Report Catalog on a separate server with SQL Server 2005, etc.). So far so good.
I can easily access a few of my test reports using URL Access, and I can also access Report Mgr just fine; all that to indicate I'm pretty sure I have RS installed and setup and working correctly.
Now I have a custom ASP.NET 2.0 based web app that, of course, uses Forms based authentication, not Windows. I can create a hyperlink on one my web pages that uses URL Access to get to some of my test reports. But, of course, it's prompts me for (and seems to remember) domain credentials.
That's the piece I want to avoid. I have created a specific Windows domain account that would be used for this purpose. Now, I just need to figure out code to put in my ASP.NET page to pass that along. I am not using the ReportViewer control.
So, I am trying to find a decent reference/example code on how to set the credentials. I have seen much example code that is like:
//assumes a web reference has been setup...
ReportingService rs = new ReportingService();
// establish credentials
rs.Credentials = System.Net.CredentialCache.DefaultCredentials;
But I don't think I want "DefaultCredentials"... I want to use my custom domain account. Any help?
My other wild idea was creating this custom page in a directory where I could drop in a custom web.config that set the <authentication> element to "Windows" then set the <identity> element to my custom account... any thoughts on that would be appreciated.
View 3 Replies
ADVERTISEMENT
Aug 14, 2007
Hi,
I am trying to deploy reports to my secure report server. When I attempt to deploy it's not authenticating me and I get an error:
TITLE: Microsoft Report Designer
------------------------------
A connection could not be made to the report server https://reports.******.com/ReportServer.
------------------------------
ADDITIONAL INFORMATION:
The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. (System.Web.Services)
------------------------------
The remote certificate is invalid according to the validation procedure. (System)
------------------------------
BUTTONS:
OK
------------------------------
I have checked my certificate and it looks okay.
Thanks,
Darren
View 3 Replies
View Related
Apr 20, 2015
we have SSRS and I've worked on my local PC and developed a report which connects to a database e.g. on server 3 with the credentials set as a particular SQL user. All works fine locally but as soon as I deploy the report to the report server (server 2), I receive the following error: Cannot create a connection to data source"
The database server records the following SQL error:"Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. Reason: Could not find a login matching the name provided."what I need to do to successfully run this from server 2? The fact it works locally fine means that the login is working ok I guess so I'm not sure what happens when it is transferred to the database server.The user is a SQL user rather than domain one and the user exists on SQL databases on both servers.
View 2 Replies
View Related
Sep 19, 2007
Hi,
I'm trying to deploy Reporting Services on an Internet-facing web server using a custom security extension (forms authentication). We will be putting Report Manager on the Web Server outside of the firewall, and Report Server on another machine inside the firewall. When testing the solution in a development environment with Report Manager and Report Server on the same box, the solution works fine.
When testing it using the Internet-facing environment described above, it almost works but there seems to be an issue with the authentication cookie that is generated. Here's what happens:
1. User enters credentials on UILogon.aspx and submits form.
2. In the code-behind, LogonUser() is called through a web service proxy and the authentication cookie is returned successfully. The code used here to set the cookie is the same code used in the Forms Authentication sample that ships with RS2005.
3. The user is redirected to Folder.aspx, and the request hangs for a while, and eventually kicks you back out to UILogon.aspx, as if it lost the authentication cookie. When doing a trace on the HTTP header, the cookie is still there.
Is there anything special I need to do to make the Report Server "see" the cookie when I have Report Manager and Report Server on different machines?
Any help would be much appreciated!
Mike
View 2 Replies
View Related
Nov 29, 2006
I have developed a custom report item that works fine in design and preview mode while in Visual Studio. I cannot get it to show up on my deployed reports. Here's what I have done so far:
1. Deployed the report using Visual Studio
2. updated the rsreportserver.config file with the following entry:
<ReportItems>
<ReportItem Name="PedigreeChart" Type="Uabr.Rap.PedigreeChart.PedigreeChartRenderer, Uabr.Rap.PedigreeChart" />
</ReportItems>
3. Updated the rssrvpolicy.config file with the following entry.
<CodeGroup
class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Description="This code group grants Uabr.Rap.PedigreeChart.dll FUllTrust permission. ">
<IMembershipCondition
class="UrlMembershipCondition"
version="1"
Url="C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServerinUabr.Rap.PedigreeChart.dll" />
</CodeGroup>
I've also tried using the StrongNameMembershipCondition with no better results.
4. The dll and its dependencies are copied to the bin directory of the report server.
5. When I load a report with this custom report item on it, the report loads fine with no errors or warnings in the log file (even with verbose tracing). The area where the custom item should be is just white. It's almost like Reporting Services isn't registering the item correctly.
This is particularly frustrating because the report works fine in Visual Studio - apparently I configured that correctly. Any suggestions would be greatly appreciated. I'm stumped.
View 6 Replies
View Related
Jun 4, 2007
Hello everyone,
We have a custom application that connects remotely to a SQL Server 2000 (SP2) database. We would like our application to validate a user's login against Active Directory.
So far I have been able to get a lookup working, but I can not find documentation on how to validate the password from within SQL Server. I found a lot of notes on using ASP.NET objects, or VB, C#, etc, but for this solution it must be done entirely in SQL. It would also be nice if this were SQL Server 2005; we could just embed the C# code and call it as a SQL stored proc, but unfortunately we are left with the constraint that we cannot upgrade this DB at this time.
Linked server 'ADSI' is set up with the sp_addlinkedserver command:
EXEC master.dbo.sp_addlinkedserver @server = N'ADSI', @srvproduct=N'Active
Directory Services 2.5', @provider=N'ADsDSOObject', @datasrc=N'adsdatasource'
Two table functions in our test DB (trying to test both ways I've found in docs):
ALTER FUNCTION [dbo].[GetAuthenticatedUserViaLDAP]
(
-- Add the parameters for the function here
@userId nvarchar(50),
@password nvarchar(50)
)
RETURNS TABLE
AS
RETURN
(
-- Add the SELECT statement with parameter references here
SELECT [SAMAccountName], CN [Name], SN [Last Name], ST State
FROM OPENQUERY( ADSI,
'<LDAP://DC=company,DC=com>;((objectClass=user));SAMAccountName,cn,sn,st')
WHERE [SAMAccountName] = @userId
)
ALTER FUNCTION [dbo].[GetAuthenticatedUser]
(
-- Add the parameters for the function here
@userId nvarchar(50),
@password nvarchar(50)
)
RETURNS TABLE
AS
RETURN
(
-- Add the SELECT statement with parameter references here
SELECT [SAMAccountName], [Name], SN [Last Name], ST State
FROM OPENQUERY( ADSI,
'SELECT SAMAccountName, Name, SN, ST
FROM ''LDAP://bdsserver1/ CN=users,DC=company,DC=com''
WHERE objectCategory = ''Person''
AND objectClass = ''user'' ')
WHERE [SAMAccountName] = @userId
)
So calling either of these table functions from our custom application gives the same result:
select * from dbo.GetAuthenticatedUser('astonaker','abc')
OR
select * from dbo.GetAuthenticatedUserViaLDAP('astonaker','abc')
ResultSet:
'astonaker', 'Anthony', 'Stonaker' 'NULL'
So I can at least tell if a given user exists or not, but I have no visibility into whether the password they entered into our application is valid in LDAP.
I don't want to pass unencrypted passwords through the network, but then I don't know how to encrypt/compare these passwords without using the .NET Connection or DirectoryEntry, etc objects.
Any thoughts/suggestions are greatly appreciated!
View 5 Replies
View Related
Dec 8, 2007
Hi,
is it possible to create a report server project template ? This project must have 2 datasources and 1 specific report
I wanted to use the Export Template, but it isn't available. I can only use it in Developpement Studio not in BIDS.
Thanks to help me
Cédric
View 3 Replies
View Related
Aug 6, 2015
I have a balance sheet report developed and working. What I need to do is add the ability to click (or double-click) on a number and have a separate report (drill-down) open with the detail that makes up that number. I've researched drill-through reports, sub reports, etc. but can't find a way to do what I want.
I'm now thinking that I need to add custom code in the report properties, code window to do this. I'm hoping that there is a VB method I can use to call this report and pass a parameter. Pseudo-code for this function would look something like this: RunReport("DrillDownReport", "Parameter").
This seems like it should be pretty easy but I don't know what the function is in VB for running an SSRS report (if there is one).
Is this possible or am I barking up the wrong code tree?
View 5 Replies
View Related
Mar 21, 2007
I have written CDE to retrieve and process data before generating the report. It works very well inside VS.Net. However, when deployed to the report server I get the following error
An error has occurred during report processing. Cannot create a connection to data source 'CallsTaken'. Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
I have added appropriate CAS entry in rssrvpolicy.config file as following
<CodeGroup
class="UnionCodeGroup"
version="1"
Name="CustomDataExtensionCodeGroup"
Description="Code group for the Custom Data Extension"
PermissionSetName="FullTrust">
<IMembershipCondition
class="UrlMembershipCondition"
version="1"
Url="C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesReportServerinCSS.CustomDataExtension.dll"/>
</CodeGroup>
I have added appropriate entry into rsreportserver.config for data extension as
<Extension Name="Dataset Extension" Type="CSS.RS.Extensibility.CustomDataExtension.DsConnectionWrapper, CSS.CustomDataExtension"/>
Even then I continue to get this error. Any help? Is there anything else I am missing? I am using VS .Net 2005, SRSS 2005 on W23 machine.
I have been stuck here for a while now. Help is appreciated.
Thanks
View 2 Replies
View Related
Dec 11, 2013
I am using the QRCode4CS class [URL] .... to generate QR codes.
I can use the following code to successfully return a bitmap image to a picturebox in a Windows Form Application.
public class CreateQRCodeClass
{
public static Image CreateQRCodeImage(string inputString)
{
QRCode4CS.QRCode qrcode = new QRCode4CS.QRCode(new QRCode4CS.Options(inputString));
qrcode.Make();
[Code] ....
In trying to adapt the same code (below) to display a QR code in an SSRS report I get the error "There is an error on line 1 of custom code: [BC30311] Value of type 'System.Drawing.Image' cannot be converted to '1-dimensional array of Byte.'
Here is the custom code I am using.
Public Function QRCode(ByVal RetailerId As String) as Byte()
Return QRCode4CSCreateQRCode.CreateQRCodeClass.CreateQRCodeImage(RetailerId)
End Function
Here is the revised custom assembly.
public class CreateQRCodeClass
{
public static byte[] CreateQRCodeImage(string inputString)
{
QRCode4CS.QRCode qrcode = new QRCode4CS.QRCode(new QRCode4CS.Options(inputString));
qrcode.Make();
Image canvas = new Bitmap(86, 86);
[Code] ....
What data type can I successfully return to SSRS to display the image?
View 9 Replies
View Related
Mar 18, 2008
Hello everyone,
I created a custom assembly using C# to transform some binary data into text, and in this assembly I used one win32 dll developed by our customer to help me to do the tranformation.
The code I used to call the win32 dll is like below:
[DllImport("tdasuie.dll", EntryPoint = "AlrtLogConditionToText",
ExactSpelling = false, CharSet = CharSet.Auto, SetLastError = true)]
private static extern UInt32 AlrtLogConditionToText(Byte[] pbCondition, StringBuilder pszText, UInt32 dwSize);
I defined a C# method to call the above win32 method and return a string. Then in the report, I called this C# method to get the correct string.
In the report designer, the C# method in the custom assembly can return the correct string in the preview window. But after I deployed the report into the report server, the textbox will only display "#error" in the report manager web page.
Can anybody help me on it? Thanks a lot.
Danny
View 4 Replies
View Related
Apr 25, 2007
Hi , all Microsoft BI experts here,
Thanks for your kind attention.
I am having a question as stated in the subject title, yes, when we want to deploy scorecards to reporting services, as the prerequisite, how can we install and register the scorecard custom data processing extension with the Microsoft reporting services server?
I am looking forward to hearing from you shortly and thank you again.
With best regards,
Yours sincerely,
View 1 Replies
View Related
Aug 2, 2006
I have a user who cannot login to a .mdb when he is logged
in to Windows, on his workstation or any other.
No one can login to the .mdb when he is logged in to Windows.
He CAN login to the same .mdb if someone else is logged in
to Windows, either on his workstation or any other.
When the user logs in he gets the following error:
MS SQL Server Login
Connection Failed:
SQL
State: €˜28000€™
SQL Server Error 18456
[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed
for user €˜domainusername€™
I have removed and recreated the ODBC Connection
while he is logged in. I have tried changing the trusted login to
administrator (in the window that pops up when he fails to connect).
He has the permissions he needs to the .mdb because he can
login under anyone else€™s profile.
I tried copying his profile to a brand new user and ended up
with the same result.
This leads me to wonder if there is some corruption in one
of his profile€™s .dat files or ???
This is the boss€™ account and he does not want to be given a
new username and profile€¦
Microsoft SQL Server
2000 - 8.00.760 (Intel X86)
Running on MS Windows 2003 Server Standard SP1
All workstations are XP SP2 with MS Access 2003 SP2 (from
Office Pro distro)
We use roaming profiles.
All systems within the same physical and logical network and domain.
Any help you can provide will be greatly appreciated.
Please let me know if there is any additional information you need.
Thanks,
Mike
View 6 Replies
View Related
Feb 5, 2008
Hello,
I am trying to create a job that runs a SSIS package. I am getting the following error:
Message
Unable to start execution of step 1 (reason: Error authenticating proxy domainsckeels, system error: Logon failure: unknown user name or bad password.). The step failed.
Our DBA ran the following to create the credentials and proxy account.
USE MSDB
CREATE CREDENTIAL [sckeels] WITH IDENTITY = 'domainsckeels', secret = 'sckeels_credentials'
GO
Sp_add_proxy @proxy_name='ssis_users', @credential_name='sckeels'
GO
Sp_grant_login_to_proxy @login_name='domainsckeels', @proxy_name='ssis_users'
GO
Sp_grant_proxy_to_subsystem @proxy_name='ssis_users', @subsystem_name='SSIS'
Any help with this would be appreciated.
Steven
View 7 Replies
View Related
Feb 6, 2006
I have been attempting to create a snapshot of a database. Just install a SQL2005 cluster. The snapshot appears to create ok, but when I view snapshot agent status I get the following error which I have not been able to figure out:
Unable to start execution of step 2 (reason: Error authenticating proxy ohaevservices, system error: Logon failure: unknown user name or bad password.). The step failed.
This account has admin and dbowner --- Help
View 15 Replies
View Related
Jan 18, 2007
hi everyone
what the matrix's class name ?
where is the matrix's dll?
Can i create a new class extends the matrix?
I want to override the matrix's onpaint method.
Can i do this ?
why the table not have the column group?
View 9 Replies
View Related
Feb 4, 2008
Hi All,
I am using SQL Server 2005 Reporting Services and have successfully created and deployed a Custom Report Item to use instead of the standard Chart Control.
This new Item works fine in both Report Designer (Visual Studio) and when generating Reports on the Report Server
However, I have a requirement that the same chart style must be available in Report Builder. Unfortunately, when using Report Builder to create a new report I can only select Tabular, Matrix or Chart style, and the chart option uses the standard style which is not suitable.
I cannot see any obvious way of including a Custom Report Item within Report Builder, so I have 2 questions :
Can I use a Custom Report Item in Report Builder? None of the samples or tutorials that I have found give any indication of whether this is possible.
Thanks in advance
Paul
View 4 Replies
View Related
Apr 25, 2007
I m trying to deploy reports using rs.exe & rss script. I would like to provide custom Report Name for each report I am deploying (not same as report rdl filename) for more meaningful listing under Report Manager. Is there a way to implement the same?
Thanks
View 5 Replies
View Related
Feb 7, 2007
How would one go about setting the height of a custom report item programmatically?
I have a custom report item that renders back an image of indeterminate height. I cannot simply set RenderItem.Sizing = Image.Sizings.AutoSize; As the image is being rendered back at 300 dpi and will require being set to FitProportional. Therefore I need to set the height to a scale height. I've tried setting CRI.Height to a ReportSize value, but it tells me that I cannot because of the current state of the item.
View 9 Replies
View Related
Jan 4, 2008
Hi,
I'm trying to create a custom report item with the action functionality without sucess, in the Process method I create the Action like this:
Action action = Action;
action.SetDrillthroughAction("myreport");
if (imageMapArea.ActionInfo == null)
imageMapArea.ActionInfo = new ActionInfo();
if (imageMapArea.ActionInfo.Actions == null)
imageMapArea.ActionInfo.Actions = new ActionCollection();
imageMapArea.ActionInfo.Actions.Add(action);
m_ImageMap.Add(imageMapArea);
The Action is the property of the interface:
ICustomReportItem
public Action Action
{
get
{
if (m_action == null)
{
m_action = new Action();
return m_action;
}else
return m_action;
}
}
}
When I click in my custom report item I get theses error message: "The source of the report definition has not been specified"
If I change the line:
action.SetDrillthroughAction("myreport");
for this:
action.SetHyperlinkAction(http://www.google.com/);
Every thing works fine. How can I solve this?
View 1 Replies
View Related
Feb 8, 2008
I'm developing a Custom Report Item that generates a BarCode.
I developed all control functionality but now the problem resides on the Deploy Process.
For the fisrt time I followed 2 steps to deploy component on Visual Studio:
1) Copy the dll on " Program FilesMicrosoft Visual Studio 8Common7IDEPrivateAssemblies "
2) Configure the control in "Program FilesMicrosoft Visual Studio 8Common7IDEPrivateAssembliesRSReportDesigner.config"
RSReportDesigner.config
<ReportItems>
<ReportItem Name="BarCodeReportItem" Type="BarCodeReportItem.BarCodeReportRenderer, BarCodeReportItem"/>
</ReportItems>
<ReportItemDesigner>
<ReportItem Name="BarCodeReportItem" Type="BarCodeReportItem.BarCodeReportDesigner, BarCodeReportItem"/>
</ReportItemDesigner>
On the other Hand I configured SQL Server Reporting services doing that:
3) Copy the dll on " Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServerin "
4) Configure the control in "Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServer
sreportserver.config"
<Extensions>
....
....
<ReportItems>
<ReportItem Name="BarCodeReportItem" Type="BarCodeReportItem.BarCodeReportRenderer, BarCodeReportItem"/>
</ReportItems>
</Extensions>
5) Configure the control in "Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServer
ssrvpolicy.config"
<CodeGroup
class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Description="This code group grants BarCodeReportItem.dll FUllTrust permission. ">
<IMembershipCondition
class="UrlMembershipCondition"
version="1"
Url="D:APPSmssqlMSSQL.3Reporting ServicesReportServerinBarCodeReportItem.dll" />
</CodeGroup>
But when I add the control to the toolbox and Drag Drop the control to the Report Designer an error occurs:
"Custom Report Item BarCodeReportItem is not installed"
What Can I Do?
Thanks for all!
View 2 Replies
View Related
Aug 6, 2007
Hi,
We are developing a custom report item but we cannot find a way to get the report parameters. In Vb examples there is mentioning of globals but these do not seem to be present in the c# enviroment.
Could anyone give a solution on how to get to the report parameter collection in run-time.
Thanks,
Arwin van der Laan
View 8 Replies
View Related
May 17, 2007
I have created a custom assembly and referenced it and the program builds successfully. When I try to run the report in design mode, it will not render, it throws an exception when it tries to create a PDF. When I remove the assembly, the reports work well. So I'm not sure what it is that I'm doing wrong - does anyone have any suggestions?
namespace Calculations
{
public class calcPercentage
{
public static decimal Percentage(decimal decValueOne, decimal decValueTwo)
{
decimal decPercentage = 0;
if (decValueOne == 0 || decValueTwo == 0)
{
decPercentage = 0;
}
else
{
decPercentage = (decValueOne - decValueTwo) / decValueOne;
}
return decPercentage;
}
}
}
Then in my textbox I put:
=Calculations.CalcPercentage.Percentage(SUM(Fields!PreviousYTDExpenseAmount.Value, "Template_OutputData_Sales"), SUM(Fields!PreviousYTDExpenseAmount.Value, "Template_OutputData_CGS"))
I referenced the assembly and added it to C:Program FilesMicrosoft Visual Studio 8Common7IDEPrivateAssemblies and I still get that error message so I do not know what the problem is.
The line where the exception occurs happens here:
byte[] bytes = MyReport.rvOutput.LocalReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamids, out warnings);
Thanks so much for you help! If you have any suggestions about my next error...i'm all ears!
View 7 Replies
View Related
Feb 27, 2008
Hi guys,
i Have the following code for a SSRS Matrix Report.
SELECT NON EMPTY { [Measures].[Ordered Qty], [Measures].[Line Fill %], [Measures].[Qty Fill %], [Measures].[Delivered Qty], [Measures].[Delivered Lines], [Measures].[Ordered Lines] } ON COLUMNS,
NON EMPTY {[Customer].[Customer Name].[Customer Name].ALLMEMBERS * [Market].[Product Group].[Product Group].ALLMEMBERS * {[Time Calculations].[MTD Pr Mth],[Time Calculations].[MTD]} } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS
FROM ( SELECT ( STRTOSET(@DatePeriod, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@DateYear, CONSTRAINED) ) ON COLUMNS FROM [DIFOT]))
WHERE ( IIF( STRTOSET(@DateYear, CONSTRAINED).Count = 1, STRTOSET(@DateYear, CONSTRAINED), [Date].[Year].currentmember ), IIF( STRTOSET(@DatePeriod, CONSTRAINED).Count = 1, STRTOSET(@DatePeriod, CONSTRAINED), [Date].[Period].currentmember ) )
CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS
Parent is the Customer Name, with Drill Down to Product Group.
Is their a way that i can sort this report so the customers with the highest [Measures].[Ordered Lines] for ],[Time Calculations].[MTD] is on the top.
Ive been trying to work out the ORDER command in MDX, but i cannot seem to get it to work..
Any help would be great
Thanks
Scotty
View 5 Replies
View Related
Mar 17, 2008
I'm looking at creating a custom report item which will allow me to input data into a textbox on the rendered report and dynamically update a textbox or another custom report item once I leave focus of that initial textbox. Is there a way to accomplish this? I have read that you can only create CRIs which use "graphic elements and images". Is that a true statement?
The reason why I don't want to have the initial value as a parameter is becuase the client doesn't want to have to click "View Report" everytime they want to see an updated value.
Thanks,
--Josh
View 4 Replies
View Related
Oct 18, 2007
Hello,
We are using custom authentication to acess the report server.Users can access reports only through a .net application. Now we want to give the users the ability to deploy their reports trhough a .net client utility with out changing the anonymous security setting in IIS.
Can anyone point me in the right direction . Can we use rs.exe to deploy reports under forms authenticated mode...
In a nut shell "Is there a way to deploy report through forms authentication"/
Thanks!!
View 2 Replies
View Related
Feb 5, 2008
Hi,
I'm currently on the task to develop a custom report item to display date values from a data source in a Gantt-chart-alike way.
I took a look at the documentation and the examples (especially [1]) but the documentation I found mainly concentrated on the case of assigning a single value to a custom property. As far as I can see I need to access the data source directly to retrieve the data I'd like to show. In the best case I could retrieve data sets only from a certain data grouping. But that's where I'm stuck. I realize I have to define the CustomData property in the designer component, but I have no clue what to set for DataRowGroupings, DataColumnGroupings, DataRows and so on.
I hope somebody can point me to some documentation about the contents of the CustomData class. The MSDN documentation I found is utterly incomprehensible to me.
Thanks in advance!
[1] http://technet.microsoft.com/en-us/library/ms345254.aspx
View 1 Replies
View Related
Jan 31, 2008
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.]
[Exception: An unexpected error occurred in Report Processing.]
Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension) +503
Microsoft.Reporting.WebForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension) +958
Microsoft.Reporting.WebForms.ServerReportControlSource.RenderReport(String format, String deviceInfo, NameValueCollection additionalParams, String& mimeType, String& fileExtension) +84
Microsoft.Reporting.WebForms.ExportOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response) +143
Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context) +153
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +358
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64
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?
Thanks a lot!
View 3 Replies
View Related
Jul 27, 2007
Hello,
I am having a problem with deploying a CRI.
On my local machine the CRI works fine, only at the development machine it doens't works.
I did the following steps:
copy the .dll to the C:Program FilesMicrosoft Visual Studio 8Common7IDEPrivateAssemblies
copy the .dll to the C:Program FilesMicrosoft SQL ServerMSSQL.4Reporting ServicesReportServerin
put this code in rsreportserver.config:
<ReportItems>
<ReportItem Name="BusinessConnectDiagram" type="LogicaCMG.BusinessConnect.DiagrammingCRI.GenerateDiagramRenderer,LogicaCMG.BCDiagramming"/></ReportItems>
put this code in rssrvpolicy.config:
<CodeGroup
class="UnionCodeGroup"
Version="1"
PermissionSetName="FullTrust"
Name="BusinessConnectCodeGroup"
Description="Code group for the Business connect diagrammer">
<IMembershipCondition
class="StrongNameMembershipCondition"
version="1"
PublicKeyBlob="002400000480000094000000060200000024000052534131000400000100010051C346CB2A79947C83804E550CF1561729DB2B5C7DEFF93758E419F16390A295DF4906ADD8FD9A29559D5E3C8BFA73D8D21B64724B1B0E688091C1541FD54D5290D6968C73E9ACA842B1E42AB3DE369F7B545933C8E101A737BB7D22F937921E7F02E00C5121D1DC312DBE96154E5A4E47BD7F489A655A09CF08EABCFB6AB7C1"
/></CodeGroup>
put this code in rsreportdesigner.config
<ReportItems>
<ReportItem Name="BusinessConnectDiagram" type="LogicaCMG.BusinessConnect.DiagrammingCRI.GenerateDiagramRenderer,LogicaCMG.BCDiagramming"/>
</ReportItems>
<ReportItemDesigner>
<ReportItem Name="BusinessConnectDiagram" Type="LogicaCMG.BusinessConnect.DiagrammingCRI.GenerateDiagramDesigner,LogicaCMG.BCDiagramming" /></ReportItemDesigner
I get the following error message:
Could not load file or assembly 'ReportingServicesWebServer,
Also when i stop Reporting Services it won't start again. I get a timeout.
View 2 Replies
View Related
Jun 19, 2007
Hello,
I'd like to use Globals!ReportName and User!Language in custom code like this:
Function Localize(ByVal key As String) As String
Return ReportUtil.Localizer.Localize(Globals!ReportName, key, User!Language)
End Function
If I preview the report I get an error message saying that there is error on line 2 of custom code.
Is it possible to reach report variables in custom code?
Thanks!
Werner
View 8 Replies
View Related
May 4, 2008
I am trying to build a report that allows a user to enter partial text that filters the values in a drop down
For examle;
Lets say I am selecting a value from a drop down for States and I want to type in FL to filter the collection down so that only Florida appears in the select list.
I know the above example wont work since I cannot actaully enter text into a drop down, however
I have also tried to seperate this functionality by creating one report parameter for entering the search text and another parameter that will display a filtered data set using the text entered in the first parameter.
Is this something that reporting services can handle ? If it is please provide a brief example.
Thanks
View 6 Replies
View Related
Mar 14, 2007
How do I reference report items (such as textboxes, datasets, tables, etc...) from within a custom assembly?
Thanks!
View 3 Replies
View Related
Mar 8, 2007
Hi,
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 am writing in C#.
View 5 Replies
View Related
