I'm running the following query in SQL Server 2005:
select name from master..syslogins;
It is being executed from within a stored procedure.
For user 'sa' - I get the complete list of users.
For a user (say 'user1') with NO sysadmin privilege - I get only two names: 'sa' and 'user1'
Is there a way for me to retrieve the complete list of users even for 'user1' without making any changes to his profile (or making very MINIMAL changes to profile)?
I don't want to give sysadmin profile to this user.
I know 'GRANT VIEW ANY DEFINITION TO public' works, but don't want to do that either.
I'm trying to write an expression for the "Hidden" property of a column in a table. The column is only populated with data if the group on my table is open. If the group is collapsed, then the column is empty. I'd like to make the column hidden if the group is collapsed. So I'm thinking it would be something like this:
But I can't find anyone who has written this anywhere.
I'm basically trying to make this report do the same thing a matrix does, but the matrix doesn't let me label the columns. I put textboxes above the matrix in line with the columns, but when I deploy the report to ReportManager, the textboxes get thrown all over the place and don't line up with the columns anymore.
So I guess if you can't answer the first question, an alternate question I have is how are you supposed to label the columns (row groups) in your matrix? They don't have headers, if I try to line textboxes up with them they get all messed up during deployment. They have that textbox up there in the top left corner that runs across the top of all of the row group columns, but if I put labels separated spaces in that textbox, the spaces get removed in rendering so the text is pushed all to the left and doesn't line up anymore.
I have a matrix in which there are 7 columns.I need to control visibility of a column based on the prompt values provided. For example: If prompt values are Act,Ban,Mag then only these column data should come up if i do not select any of these then they should not show up.
I have a field on a report where on occasion, will display 'PR'. We need to have this field hidden if that is the value of the field. I wrote an expression for visibility like: iif(Fields!ThisName.Value="'PR'", false, true), however it still diplays. Is there something else that I need to do here?
I want to control the visibility of the report bases on if certain columns have the data or not. Since our DB can accept EMPTY strings. I need to check for both NULLs and EMPTY STRINGS.
I have writen the following VB function
Public Function IsEmpty(ByVal value As Object) As Boolean If IsNothing(value) Then Return true Else If(value.ToString().Length = 0) Return true End If Return false End Function
In the "visibility" expression window I have the following
=(Code.IsEmpty(Fields!COLUMN1.Value)) and (Code.IsEmpty(Fields!COLUMN2)) and (Code.IsEmpty(Fields!COLUMN3))
We're working on a new release of a software.In the existing version, each client connects and executes a long batch ofanalysis on some tables.In the new release, we need to allow each client to execute analysis on asubset of data, according to certain login information.Our idea is:1) Connection to db2) Creation of one View according to restrictions3) Execution of analysis using just created view and some tables.The problem is that executingcreate view myvista asselect * from tb_data where testo='A1'from two different clients, creates just one view.Question: Does it exist a way of creating a VIEW with a connection scope,something like 'select into ##temptable'?We tried Create View #MyVista or ##Myvista, but this name is not accepted.Alternative way, is creating a ##TempTable, at the beginning of the batch,and using it as data source instead of full table, but, due to really hugeamount of data, this could really disturb server performances.Thanks for any helpAlberto
I'm trying to show a column only if a certain parameter contains a certain string of characters. So far I've got it working if the parameter is equal to the string of characters by doing =IIF (Parameters!Param1.Value = "String1", False, True) but I would like it to work if the Param1.Value contains "String1" ... I tried =IIF (Parameters!Param1.Value like "%String1%", False, True) but it doesn't work. Any suggestions?
I am trying to create a report that should have a dynamic toggle visible, so that when the parent is of a certain type the toggle button (+, -) would not appear and in the other case it will.
Is this possible? I can use expressions in the visible field but not in the toggle one, so how can i manage it?
Hi,I have a report with various tables, some of them can be empty.
When empty, and hidden property set to false only one line apears blank in my report, but if i set the hidden property to true it results in an empty space with the same height as the table i´m trying to hide.
My goal is to have no blank spaces at all when a table is empty.
I have one column group and three static columns. I'd like to control static column visibility property depending on a field value. I.e. Hidden: =Fields!GroupId<>5.
But I'm not able to find visibility property in column object. Neither in properties explorer nor RDL documentation. I'm only able to set hidden property in textbox objects.
Hi, Is there a way to set the visibility of a chart as can be done for a textbox or table or matrix? My requirement is that the chart should be visible only if certain data conditions are met.
I built a report, that displays several Subreports. Then a request came, if it wouldn't be possible, to build a switch to turn on/off a page break after each report.
Since RS doesn't support a fexible page break controlling (you can either set or not set a page break hardcoded), I got an idea for a workaround:
After my Subreport I put a rectangle with a page break. Now every Subreport was displayed on a separate page.
Then I set the visibility for the rectangle to "hidded" and as expected, there was no page break after each subreport.
So far, so good. I then created a boolean parameter and set the Visibility expression to:
=Not Parameters!PageBreakAfterEachReport.Value
Now here comes the strange thing: If the Parameter is false, the rectangle is not displayed and therefor there is no page break, BUT, if the parameter is true, the rectangle is displayed correctly but there is STILL NO page break!!!?!?!!?!?
Why does the page break work, when I set the visibility hardcoded, but not when I try to control it via a parameter & expression?
Problem is that when I choose Insititutional Agency from the drop down list it evaluates the expression and shows the textbox, when another state is choosen it still shows the textbox and I dont want it to? I have ran a test to show the expression (Parameters!state.Value) in a text box, and its showing the right values each time i run the report?
I have two DataSet and two tables in a report. Almost identical reports (top 5). Both DataSet have a Boolean indicator and I am to append an asterisk to a column in the detail rows if indicator is true. If an asterisk appears, I am to display the footer, that has a comment in it explaining the asterisk.
Public Class AsteriskFootNote
'
' To be used on the Visibility.Hidden attribute
'
Dim _FooterVisiblity As Boolean = True
Public ReadOnly Property FooterVisibility() As Boolean
Get
Return _FooterVisibility
End Get
End Property
'
Function AsteriskIndicator(ByVal strInd As String) As String
If (strInd.ToLower = "true") Then
_FooterVisibility = False
Return "*"
End If
Return ""
End Function
'
End Class
I have instantiated two classes Dollars and Hours. In the detail, call the
=Fields!Descr.Value & Code.Dollar.AsteriskIndicator( Fields!MultiInd.Value ) In the footer visibility, I assign hidden:
=Code.Dollar.FooterVisibility But it does not work. The tables act as if they assign the Hidden value, then processes the detail rows.
I have a main report and wanted to embed a sub report in the main table. This is pretty easy enough.
The main report lists the suppliers we have. And the sub report lists any sub suppliers affialiated to those suppliers.
I have set the sub report visibility settings to hidden and is toggled by the suppliers ID.
The problem is that NOT ALL suppliers will have sub-suppliers, yet when you run the report the user gets presented with the option to toggle all suppliers' ID.
Is there any way to have a main report that only allows the user to click on a suppliers ID when that particular supplier has a sub supplier?
I'm attempting a create a matrix report that will have some rows with drilldown data and some without. On the rows without drilldown data, I wanted to hide the toggle image so that the user would know there was none available. So far, I've only been able to accomplish this by creating a duplicate row group and displaying no text for its cell. Then by changing its visibility, the toggle image would go away. However; while this makes the report look good, it breaks the export to excel because the other row column that contains the data must stay visible and the excel drill down functionality goes away.
Does anyone have a way of changing the visibility of the toggle image on a row by row basis within the Matrix control?
Hopefully a simple question about parent-child package relationship. For this example, let's say I have a simple setup - one parent package: parent.dtsx, and one child package: child.dtsx. The parent package calls the child package via the ExecutePackage Task.
If I add an OleDB ConnectionManager to the parent package called MySqlConnectionManager, should I be able to reference this connection via a script task (or custom component) from my child package? I realize that I will have a problem doing this at design time, but I thought I could get around it with the script task or custom component. That said, when I look in the Connections collection at run-time from within my child package, I do not see the parent package's MySqlConnectionManager. Am I missing something, or is this the way it was intended to work?
How can I alter the visibility of the group headers when they don't have access into the scope of the groups themselves ? At startup, I only want to show group1's header. If I expand an item in group 1, then I only want to show headers for group 1 and 2, etc ...
Hi, currently I am using a matrix of the below format:
Column Grouping a) Months (From dataset) b) Amt | Cnt | Ave (Static)
Desired Collapsed View Jan Feb Mar Ave Ave Ave Figures 10 20 30
Current Collapsed View Jan Feb Mar Ave Ave Ave Figures 10 20 30
Expanded View Jan Feb Mar Amt Cnt Ave Amt Cnt Ave Amt Cnt Ave Figures 100 10 10 200 10 20 300 10 30
Issue Faced When viewing the RS report online, the months cell do not "shrink" even though Amt & Cnt columns were hidden in the Collapsed View. When the report was exported to excel, the desired collapsed view was showed where the months cell were "resized" when the drilling is collapsed.
Question Is there any setting required to enable the months cell to "auto shrink" when Amt & Cnt columns are hidden?
Don't know if this is the right place to ask the question, didn't know where to put it...
Strange thing is happening to me...I created different forms that all point (Record Source) on tables (one form - one table). Each table has some columns with Default or Binding Value set. I have a user that has Insert, Delete, Update and Select permissions.
When I insert a new record using the front end, some forms show the default values correctly, others don't show them at all (all the columns that should be populated with a default value are empty). If I add a View Definition permission to problematic tables --> surprise, surprise, default values get implemented...I'm confused...
Any ideas? Can a user w/ View Definition do some damage to the table?
I need to toggle visibility of group of columns in reporting services report, just like we can do for rows. I know that individual fields can be hidden, but i need to hide/show complete column.
I am trying to use either a rectangle or a list to provide page break functionality between 2 tables in a report.
If I set PageBreakAtStart, I get a nice page break between the 2 tables.
However, If there are no rows in the first table, I do not want the page break. So I add this expression in the list/rectangle hidden property: =iif(RowNumber("Data")= 0,true,false)
Once I add this, or any other expression to the list/rectangle, the page break stops working, even tho the list/rectangle is being shown. If I set Hidden back to False, the page break works. If I use =False in an expression, the page break stops working again.
Hi, I have a table with three group headers. I want the header row in the third section to be toggled by a textbox in the second header. This works as expected. However, there are times when there is no data in the third section. When this happens, the third section header row shows even though there is no data. I can also create an expression for the third section header's hidden property that looks for the existence of data, but then the toggle is deactivated. I need some way to say, "here's the toggle item. Show the header if there is data for it."
I have a report that gets exported to Excel. In the report there is an expression in the visibility field on one of the detail lines to hide it if it meets certain criteria. When run directly and exported to PDF, it displays correctly (hiding the lines as requested). When exporting to Excel, the lines are not hidden.
how visibility can be toggled between two textboxes in ssrs? For example if textbox1 is visible and textbox2 is hidden initially and textbox2 should be visible when clicked on textbox1 and textbox1 should go invisible when textbox2 is shown... and then again when clicked on textbox2, textbox1 should be visible and textbox2 should go invisible.In a short, it is like switching visibility between 2 textboxes... A click on first textbox should display the second textbox and another click on second text box should display first text box.I cannot provide parameter as it is not there in the requirement. how to toggle the text within a single text box to fulfill above requirement...
