i have a subreport and it needs to be displayed only based on some selection criteria, in all other case it needs to be hidden.i made the visibility to hidden, but when i run the report,it gives me a blank page where it usually gets me the subreport.How can i remove this blank page from getting displayed ?
I have a SSRS report in which we have a subreport i am trying to hide the link in excel after exporting from report documents, in report my logic is working fine but when we are deploying in SharePoint application then it is not working. Report is not opening.
How do I hide a subreport if the parent report row containing the subreport is a certain value? I am attempting to create a statement with ageing buckets. In the main body of the report I have to display payments and invoices. If the invoice row is blank, I need to hide the row containing the subreport.
We have a parameter that takes the values of "Yes" or "No" (non-queried). If the user chooses "Yes", we want the subreport to display, but remain hidden on "No".
In the expression for visibility, we have the following: =IIf(cstr(Parameters!Heading.Value = "Yes"),False,True)
When the report runs we get the following error: "The input string was not in the correct format."
Let me first describe my report: I have the following table
Header Group 1 row--There is a textbox that in this row that when toggled makes visible the two below group 1 rows and the detail row. Group 1 row Group 1 row Detail row Group 2 row-- This row has a textbox that can hide the below group 2 row. Group 2 row-- This row contains a subreport.
Currently, I have a parameter that allows the user to conditionally collapse or show the tables' information for printing purposes so the user doesn't have to go through and click on so many plus signs. My problem is I would like to use a parameter to conditionally hide both of the Group 2 rows so that the user cannot view or click on them. The information in Group 2 is extra and not always needed, so I would like to provide the user with a way to hide this information when they go to view the report. However, I imagined this would be easy enough. I went to group2's visibility tab through the table interface and set the expression to "=IIF(Parameter!ShowIndexes.Value, FALSE, TRUE)". However, when I view the report the report is hiding the detail information as well as the Group2 rows.
I have a main report and a subreport. If the subreport doesn't have any data then I hide it, but the main report still shows the white space of where the subreport would show up if it had data. So how can I get rid of the extra white space in the main report?
Is there any way to hide duplicated rows in SSRS except this formula iif(Fields!YourField.Value = Previous(Fields!YourField.Value), True, False) because doesn't work here.
I need to hide the toolbar on report. my client accessing the report on Reportmanager URL.
I have tried this way ; passed the parameters to My report manger URL : &rc:Toolbar=false,But it's not working. I am using Visualstudio 2010.or another quetion Can I make Parameter is to be Read only !
I have used SSRS to develop several dashboards for use with Microsoft CRM.
This works very well: the main dashboard page contains a table with subreports in the table cells.
Some of those subreports show reports containing other subreports, and so on.
Drilldowns into detailed lists and into the CRM entities are popup windows.
The problem I’m having now is with a report that is supposed to show the viewers their planned and completed activities on a week-by-week basis. They see a week at a time, and by pressing Next and Back arrows they can see their next and previous weeks’ information.
I need this subreport to refresh in place on the main dashboard page when they change weeks. I’ve tried putting jump-to-report actions and jump-to-url actions on my Next and Back arrow objects, but everything I try opens a new window.
I want the main dashboard to stay accessible, but I don’t want to have to redisplay the whole dashboard page, because that would rerun all of the reports’ queries and take unnecessary time. The only query that needs to be rerun is for the one subreport I’m refreshing.
Any way to refresh a subreport within the parent report?
Presently I have a main report and subreport, with the subreport having values for a carbon copy contact, which when it is displayed it shows these values:
Peter Piper #Error #Error peterpiper@mycompany.com #Error Donald Duck #Error #Error donaldduck@mycompany.com #Error etc.
When I run the subreport directly, it correctly returns all the values:
Peter Piper 123-345-6789 Calgary peterpiper@mycompany.com T Donald Duck 987-654-3210 Calgary donaldduck@mycompany.com F
Here are the details on SQL Server 2008:
Microsoft SQL Server 2008 (SP2) - 10.0.4064.0 (X64) Feb 25 2011 13:56:11 Copyright (c) 1988-2008 Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2)
I am in the process of migrating 300+ reports and 200ish subreports to SharePoint 2013 hosted. I wanted to avoid the duplication of creating copies of all the subreports across 9 different folders.
I am trying to create a report with a sub report in Sql Server 2012 using Report Builder Version 3. I can run the subreport without any problems. I read where using a shared connection can cause this error so both the main report and the subreport use a connection that is embedded in my report.
For testing, I created the subreport without a parameter and added it to the main report. When I ran it that way, the report worked and sub report displayed the data. So I know it can read from the database.It seems to only give me this error when I am trying to tie the two reports together using a parameter.
I have a report which contains a subreport placed inside a list. when the subreport returns no data. it appears as a blank space in the main report. So i want to suppress the list when the subreport returns no data. Can somebody help me with this?
Hey guys, Is there any way to hide a particular object(table,sp,tr etc) from a particular user?
we are developing softwares for the clients..and Once we install our product we dont want the clients site guys to go and delibrately view the data from sql server but through the front end. Is there anyway that i can do that...?
For Eg..the front end codes are capsulated as DLLs so that no can view the code.. Like that for SQL Server..can we do that kinda stuffs to prevent them?
We have a helpdesk application which is based on an MS SQL database, and which runs with a rather large and complicated C# based interface. We don't have the code for this, so we can't customise it. Long story short, what we want is to create an interface in Access (or similar) which accesses the same database as the helpdesk suite, and allows reading AND writing, and some rather complex operations (which SHOULD be fairly simple to do in SQL).
Unfortunately, I have been given this project, and I know about as much about Access and SQL as I do about Ghengis Khan's fashion sense.
I will follow with more information as required, but I'm going to need a lot of help with this one. First things first, is Access the way to do this? Is it going to be easier to create a new Access DB and synchronise it with the SQL, instead of both applications using the same database?
The only way I can get Access to interrogate the SQL database is to create a Data Access Page - is this the correct starting point? The only problem is that this seems to only offer HTML, and is far from being a friendly interface, at least not to me.
I know that I currently have no grounding in physics and I'm trying to build a space station, but any advice that you could give me would be much appreciated.
In SQL 2000 Query Analyzer, you can set up the text output pane toleave null values blank.That could give you this (assuming it's set to comma-delimited) --CREATE TABLE #Test (A int, B int)INSERT #Test SELECT 1,2INSERT #Test SELECT NULL,4INSERT #Test SELECT 5,NULLINSERT #Test SELECT NULL,NULLSELECT * FROM #TestA,B1,2,45,,I can't figure out how to set up 2005 Management Studio the same way.I can only manage to get outputs like this, with "NULL" instead ofempty fields --A,B1,2NULL,45,NULLNULL,NULLHow can I get rid of the NULLs?Thanks,Jim
Hi,I am intetrested to know if there is a way to hide the information in aspecific column in my table. SQLServer 200. Something like a passwordprotection were you only see *****. I have a DBA but want to hide salaryinformation from him that is stored in the database.Any suggestionsThanksElmo
I am designing a report with a few tables in it which i selectively want to hide if there is no data to display in them. The tables hide themselves but leave behind a big void without compressing the fields beneath them.
Is there anyway to make sure that the tables are hidden and it compresses the space which it would have otherwise occupied?
The two methods i have tried are:
1. Put an expression in the visibility property and set it to true if the row count is zero 2. set the expression in the NoRows property to =""
I have main reports and also sub reports in the same project [folder]. I don't want to show sub reports in the reports drop down list. Can you please let me know how to do it?
Is there a way to hide reports before publishing and then hiding reports via the Report Manager? We have some subreports that before we publish, we would like to set a flag to hidden so the Report Manager will know after the deploy that this report is to be hidden.
I know how to hide groups using Expressions that use parameters that can be passed in, but can you hide groups that are inside other groups. Here is my situation. Our company has different organization levels. On reports the users want to select which organization levels they want to see the #s for. So I set up groups for each org level like so....
Org Level 1 Org Level 2 Org Level 3
The data results are like so
Org Level 1 Org Level 2 Org Level 3 Category $ Amount USA Midwest Kansas 1 500.00 USA Northeast Maine 1 200.00
And I sum the $ Amount Per Category for each Org Level using grouping in the report.
Then based on the selections they make it hides the org levels they don't need to see. The issue is that the report will not show org level 2 or org level 3 if org level 1 is not visible, and org level 3 can't be visible if org level 2 isn't visible, etc.....Anyone know a solution to this situation, I know this has had to have come up.
Help Please! How can I hide databases from users that do not have permission to log onto them in the SQL Enterprise Manager. Thanks in advance for the help. -Rich
I have a request to hide certain parameters in a report based on the current user logged into our web based report viewer using the ReportViewer control fo asp.net.
I am doing the standard stuff required to display the report as shown below.
Code Snippet rptViewer.ServerReport.ReportServerUrl = new Uri("http://172.17.144.26/ReportServer"); // new Uri(MINETSecurity.WebSettings.WebServerPath, UriKind.Absolute); rptViewer.ServerReport.ReportPath = ReportName; rptViewer.ServerReport.DisplayName = "Report1"; rptViewer.ServerReport.ReportServerCredentials = new CustomReportCredentials("myUsername", "myPassword", "myDomain");
Now that i have loaded the report into the viewer i illiterate through the report parameters looking for the ones which the specified user should not see as show below.
Code Snippet ReportParameterInfoCollection MyReportParams = rptViewer.ServerReport.GetParameters(); foreach (ReportParameterInfo MyParameter in MyReportParams) { // returns a value from a custom class which is a predefined value for this user based on the current user logged into the website string Value = CustomParameterValues.ToString(GlobalUserSettings.CurrentUser.CustomValueList); if(Value != "") MyParameter.PromptUser = false; }
Here is where the promblem lies, when i try to set the value of PromptUser i get the following compiler error.
Property or indexer 'Microsoft.Reporting.WebForms.ReportParameterInfo.PromptUser' cannot be assigned to -- its is read only
Is there anything i can do to set certain parameters invisible to the user and set there value myself. I know i could create 2 seperate reports and set the PromptUser value in the designer but i dont really want to be duplicating reports just to hide or show parameters.
I have tried using the SetParameters method of the ReportViewer component to pass the value of the parameters that should be hidden and even set the visible property to false, but it dosn't seem to work.
