Custome DLL
May 2, 2008
Hi All,
I am using Custome DLL in My reports.
In my DLL we have a conncetion to database Sql Server 2005 which is fetching some records based on a Query.
My problem is it is working fine in Visual Studio. But in RS http://localhost/reportserver its not working and giving #Error for that particuler member.
I had give permission "SqlClientPermission" in my permission set.
Which is like
</PermissionSet>
<PermissionSet class="NamedPermissionSet" version="1" Name="KReportResourcePermissions">
<IPermission class="FileIOPermission" version="1" Unrestricted="true" />
<IPermission class="SecurityPermission" version="1" Flags="Assertion, Execution" />
<IPermission class="SqlClientPermission" version="1" Unrestricted="true" />
</PermissionSet>
And code group i have added is like
<CodeGroup class="UnionCodeGroup" version="1" PermissionSetName="FullTrust" Name="KReportResourceUtil" Description="">
<IMembershipCondition class="UrlMembershipCondition" version="1" Url="C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServerinGXSLocalization.dll" />
</CodeGroup>
<CodeGroup class="UnionCodeGroup" version="1" PermissionSetName="FullTrust" Name="KReportResourceUtil" Description="">
<IMembershipCondition class="UrlMembershipCondition" version="1" Url="C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServerinGXSLocalization.dll" />
</CodeGroup>
GXSLocalization.dll is my DLL name.
Any one aware about it ??
View 1 Replies
Apr 9, 2008
Hi,
I have 10 rows in my table, it has int as primary key, (Autogen).
I need to take rows in my custome format, I can't use desc, asc on existinc column.. I need to provide order by giving a row no. sequence.
Can you tell me how to do that?
like order by pk (......).
View 8 Replies
View Related
Oct 21, 2006
Hi, I am attempting to implement a custome paging solution for my web Application, I have a table that has 30,000 records and I need to bw able to page through these using a Gridview. Here is my curent code but it generates an error when I try to compile the Stored Procedure, I get the following errors:<Error messages> These are on the first SELECT Line..Msg 4104, Level 16, State 1, Procedure proc_NAMEGetPaged, Line 17The multi-part identifier "dbo.NAME.CODE" could not be bound.Msg 4104, Level 16, State 1, Procedure proc_NAMEGetPaged, Line 17The multi-part identifier "dbo.NAME.LAST_NAME" could not be bound.Msg 4104, Level 16, State 1, Procedure proc_NAMEGetPaged, Line 17The multi-part identifier "dbo.NAME.FIRST_NAME" could not be bound.Msg 4104, Level 16, State 1, Procedure proc_NAMEGetPaged, Line 17The multi-part identifier "dbo.NAME.MIDDLE_NAME" could not be bound.Msg 4104, Level 16, State 1, Procedure proc_NAMEGetPaged, Line 17The multi-part identifier "dbo.NAMETYPE.TYPE" could not be bound.Msg 4104, Level 16, State 1, Procedure proc_NAMEGetPaged, Line 17The multi-part identifier "dbo.FUNERAL.NUMBER" could not be bound.Msg 4104, Level 16, State 1, Procedure proc_NAMEGetPaged, Line 17The multi-part identifier "mort.NAME.CODE" could not be bound.Msg 4104, Level 16, State 1, Procedure proc_NAMEGetPaged, Line 17The multi-part identifier "NAME.LAST_NAME" could not be bound.Msg 4104, Level 16, State 1, Procedure proc_NAMEGetPaged, Line 17The multi-part identifier "NAME.FIRST_NAME" could not be bound.Msg 4104, Level 16, State 1, Procedure proc_NAMEGetPaged, Line 17The multi-part identifier "NAME.MIDDLE_NAME" could not be bound.Msg 4104, Level 16, State 1, Procedure proc_NAMEGetPaged, Line 17The multi-part identifier "NAMETYPE.TYPE" could not be bound.Msg 4104, Level 16, State 1, Procedure proc_NAMEGetPaged, Line 17The multi-part identifier "FUNERAL.NUMBER" could not be bound. </Error Messages><Sotred Procedure> CREATE PROCEDURE proc_NAMEGetPaged @startRowIndex int, @maximumRows intASBEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; SELECT NAME.CODE, NAME.LAST_NAME, NAME.FIRST_NAME + ' ' + NAME.MIDDLE_NAME AS Name, NAMETYPE.TYPE, FUNERAL.NUMBER FROM (SELECT CODE, LAST_NAME, FIRST_NAME + ' ' + MIDDLE_NAME AS Name, NAMETYPE.TYPE, FUNERAL.NUMBER, ROW_NUMBER() OVER(ORDER BY LAST_NAME) as RowNum FROM Name n) as NameInfo WHERE RowNum BETWEEN @startRowIndex AND (@startRowIndex + @maximumRows) -1ENDGO </Stored Procedure> Any assistance in resolving this would be greatly appreciated.. Regards..Peter.
View 1 Replies
View Related
Jun 10, 2006
Hi there,Not sure if this is the right place to ask. I have a custom object in ASP.NET called TransactionResponseObject.And I want to save this object AS IS - in one piece in SQL Server 2005 (instead of taking each and every property of it and individually saving it into separate columsn of a table in the database).Question:1). What type of SQL Server 2005 datatype will I be using in this case ?2). Is there a good and easy tutorial on converting a custom object into XML format? and perhaps saving the xml into the database (I feel it's just an extra step - meaning extra processing which i want to avoid).ThanksTorontoMale
View 1 Replies
View Related
