Customising report Manager

Hi guys
I just want user see only content tab in Report Manager and not the property
tab .
I create a new role and select 'VIEW ROLE' and 'VIEW REPORT' tasks,
descriptions says that user will be able to see the properties too. I dont
want let user see the property.
Niether should user see the subscription link.
How could I achieve that
Sincerely
AmeetI don't think it is possible to give a set of permissions where a user will
be able to view the report and not see the properties of the report. If you
don't 'Manage Individual Subscriptions' or 'Manage All Subscriptions'
permissions then they will not see the subscription tab.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ameet" <Ameet@.discussions.microsoft.com> wrote in message
news:2A20E4F6-1158-4845-8032-69DA31902816@.microsoft.com...
> Hi guys
> I just want user see only content tab in Report Manager and not the
property
> tab .
> I create a new role and select 'VIEW ROLE' and 'VIEW REPORT' tasks,
> descriptions says that user will be able to see the properties too. I dont
> want let user see the property.
> Niether should user see the subscription link.
> How could I achieve that
> Sincerely
> Ameetsql

Customising Dimension Security

HI, I'm having problems specifying customised security in the Advanced tab (allowed members). I'm fairly new to mdx script and am trying to restrict access to a STAFF dimension which contains a loginname member which I want to restrict access to based on username matching the loginname DIM. Have tried the following which didn't work:
[STAFF_DIM].[Login Name].members(MID( USERNAME, INSTR(1,USERNAME, "\") + 1, 128 ) )

I read somewhere that this can only be used on leaf layer members (this is the first of 3 layers), also should I be using the filter function? Any help with trying to setup would be great help.
Before using this expression for dimension security, you may want to do some experimentation first, by creating a simple MDX query including this expression, and verifying that it evaluates to the expected member...

Hope this helps

Custom DataFlow Transformation not showing up in toolbox

I've created a custom data flow tranformation and it isn't showing up in the Tool Box Items to be added under the Data Flow Items tab (right click on tool box, 'Choose Items...', then clicked Data Flow Items).

I have done the following:

signed the assembly,

added to GAC,

copied the dll to C:\Program Files\Microsoft SQL Server\90\DTS\PipelineComponents.

It worked previously when I was just starting out, however now I cannot see it. What would cause it to not show up? Everything compiles fine. How would I determine how to fix it so that it shows up?

Apart from the component being in the GAC, there are two key steps to be taken for a custom component to be recognized by the BI Studio:

placing the binary under the folder where SSIS design time checks to enumerate pipeline components, which is at <SQL Installation Folder>\90\DTS\Pipeline Components (I'd double check this on the target machine via the reg key at the very bottom, cause it could be different on a 64bit or in a production server)

custom code and messagebox popup

Hi at all,
I have custom code written the to show a message Box.
It was working fine in DotNet2005 Development enviroment preview tab.
But it is't working when i deploy this report to the web.
Please use a reference to
System.Windows.Forms, Version=2.0.0.0
Public Function Test() As String
System.Windows.Forms.MessageBox.Show("Hello")
' Or
Msgbox "Hello2"
Return "OK"
End Function
Can anyone help me
martinYou can't use System.Windows.Forms for a web page. Please see the following
URL: http://www.freevbcode.com/ShowCode.asp?ID=5918. If you don't want to
go there, use the following function to stream out a message box
Public Sub ASPNET_MsgBox(ByVal Message As String)
System.Web.HttpContext.Current.Response.Write("<SCRIPT
LANGUAGE=""JavaScript"">" & vbCrLf)
System.Web.HttpContext.Current.Response.Write("alert(""" & Message &
""")" & vbCrLf)
System.Web.HttpContext.Current.Response.Write("</SCRIPT>")
End Sub
--
================Living proof that 95% of programmers are idiots.
"Martin Jau" wrote:
> Hi at all,
> I have custom code written the to show a message Box.
> It was working fine in DotNet2005 Development enviroment preview tab.
> But it is't working when i deploy this report to the web.
> Please use a reference to
> System.Windows.Forms, Version=2.0.0.0
> Public Function Test() As String
> System.Windows.Forms.MessageBox.Show("Hello")
> ' Or
> Msgbox "Hello2"
> Return "OK"
> End Function
> Can anyone help me
> martin
>
>

Custom Code

I've created a function in the code tab but when I go back to the text box
that is going to call the custom code through the expression... i type code.
and my function isn't there... anybody else see this?Hi,
"Code" or "Report" is a global object pertaining to Reporting Services.
User defined functions wont be visible since it is not a user created class.
Amarnath
"gdjoshua" wrote:
> I've created a function in the code tab but when I go back to the text box
> that is going to call the custom code through the expression... i type code.
> and my function isn't there... anybody else see this?

Custom assembly problems in RS

Hi,
I have a custom assembly that is working just fine in the Preview tab in Report Designer. However, the popup preview is blowing up with the error: Execute permissions cannot be acquired.
I've added a code group (at the top of the code group section) in the rsPreviewPolicy.config, which is residing in the default location. My .dll is in the correct place and functioning, as evidenced by the preview tab success. The .dll is using ADO.net to call a stored proc in an Oracle database.
I added the code group by directly editing the config file; I'm no XML veteran, so I'm not sure if it's configured correctly. The .Net editor tells me it's "well-formed". When it wasn't well-formed, I got an error regarding loading the file, so I'm assuming this isn't the problem.
Any insight would be appreciated.
Doug
--
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.Did you sign the file using the sn command line tool that comes with VS?
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:%23W6pS%23eaEHA.2840@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I have a custom assembly that is working just fine in the Preview tab in
> Report Designer. However, the popup preview is blowing up with the error:
> Execute permissions cannot be acquired.
> I've added a code group (at the top of the code group section) in the
> rsPreviewPolicy.config, which is residing in the default location. My
> .dll is in the correct place and functioning, as evidenced by the preview
> tab success. The .dll is using ADO.net to call a stored proc in an Oracle
> database.
> I added the code group by directly editing the config file; I'm no XML
> veteran, so I'm not sure if it's configured correctly. The .Net editor
> tells me it's "well-formed". When it wasn't well-formed, I got an error
> regarding loading the file, so I'm assuming this isn't the problem.
> Any insight would be appreciated.
> Doug
>
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
> supports Post Alerts, Ratings, and Searching.|||It sounds like you did not assert permissions to open a database connection.
Unless you assert the permission explicitly in the custom assembly code, it
will fail with a security exception.
Example for opening a connection to a SQL Server:
...
SqlClientPermission permission = new
SqlClientPermission(PermissionState.Unrestricted);
try
{
permission.Assert(); // Assert security permission!
SqlConnection con = new SqlConnection("...");
con.Open();
...
}
You might also want to check out these links:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_rdl_0so6.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconAssert.asp
http://msdn.microsoft.com/library/?url=/library/en-us/dnsql2k/html/dngrfCodeAccessSecurityInSQLServer2000ReportingServices.asp
http://msdn.microsoft.com/library/en-us/RSPROG/htm/rsp_prog_rdl_8wyq.asp
Robert M. Bruckner
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:%23W6pS%23eaEHA.2840@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I have a custom assembly that is working just fine in the Preview tab in
Report Designer. However, the popup preview is blowing up with the error:
Execute permissions cannot be acquired.
> I've added a code group (at the top of the code group section) in the
rsPreviewPolicy.config, which is residing in the default location. My .dll
is in the correct place and functioning, as evidenced by the preview tab
success. The .dll is using ADO.net to call a stored proc in an Oracle
database.
> I added the code group by directly editing the config file; I'm no XML
veteran, so I'm not sure if it's configured correctly. The .Net editor
tells me it's "well-formed". When it wasn't well-formed, I got an error
regarding loading the file, so I'm assuming this isn't the problem.
> Any insight would be appreciated.
> Doug
>
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.