I'd like the state of the function bars to stay at whatever it was as the user moves from one report to the next rather than opening to full each time a new report is opened. Can this be done through a setting or programatically at teh report level? Is there a <default_toolbars_OpenState> tag or something?
Thanks in advance.
I have a report that has three levels of grouping including headers (containing titles) and footers (containing summary values). I would like to programatically show/hide these header/footer sections based on a Show/Hide paramter. Is that possible? Currently I work around the problem by just having two physical reports (one with the header/footers, one without)
View 6 Replies View RelatedI am doing report development against OLAP. I have Parameter1 and then my second parameter is a boolean (True/False). I want to show Parameter 3/Paramater 4 based on selection of Param2 (So, if true, show Param3, if false, show Param 4) and please remember we are doing this in a sequence.
Is this even possible in SSRS 2005? If yes, how the hell do I achieve it.
PS: Sorry for cursing, but I am about to lose my mind. Any help is much much appreciated.
Hi All,
I have requirement where first I need to show only one report
parameter. Based on user selection I need to prompt or show the user
another report parameter.
Say suppose I have 3 parameters. User selects first value in first
parameter I should not show the other 2 parameters. If user selects
second value in first parameter I should show second parameter and
hide third parameter. There is no relationship between these 2
parameters except user selection. Similarly if user third value in
first parameter then I should show third parameter and hide second
parameter.
Is this possible? I can not see any Visible property for report
parameters.
If yes, how to achieve this functionality?
Appreciate your help.
Regards,
Raghu
Hi all,
I was wondering whether there was a way to implement a "Hide all/show all" option in the report. are there any examples that I could refer to ?
Thanks !
Bernard
We were having a standards meeting today at my company and we talked about the show/hide details button in the UI. We hide reports all the time because they are sub-reports and aren't meant to be run on their own. If we can't hide the "Show Details" button and we can't ban the user with security from running the sub-report because they need to run the Main report which runs the sub-report, then what do we do?
I'd think we have the have the ability to to hide things, or least a creative way to hide them; but I don't want to deploy sub-reports to wierd places just to get around this.
The following posts reference this topic, but didn't address it; yet raise this question.
Thoughts?
Keith
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=950457&SiteID=1
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=204599&SiteID=1
p.s. Just my own two cents, it would seem like a nice feature to be able to hide the "show details" button because there are advantages to hiding things.
How do you hide the "show details" button? i don't want users to be able to click on it and find all the reports we've hidden from them.
View 6 Replies View RelatedHello,
I'm currently investigating whether SQL Reporting Services might be the right solution to some reporting requirements I have been given (web reports).
There is a requirement that some of the columns are hidden to begin with and can be shown by clicking on the header of one of the other columns. E.g. There is a list of clients and a "Total Revenue" column, clicking on the "Total Revenue" column header would show an additional 5 or so columns which show a breakdown of different figures that make up the total revenue.
So my question is this: Is it possible to show/hide columns by clicking on the headers of other columns in the report?
Thanks,
Lachlan
I'd like to hide/show a table based on selected parameters. In the current setup I have a matrix and two tables underneath that need to be displayed from time to time. First of I use a multi-value parameter called "Lieferart". Depending on the parameter I have set the visibility of the two tables with the following expression:
=iif(Parameters!lieferart.Value(0) like "Nagel%", False, True)
This expression doesn't work though, any ideas??? I am also unsure about what I have to do If multiple values from the parameter list are selected as Parameters!lieferart.value(0) doesn't necessarily need to have a label like "Nagel" included...
Hi all,
Is it possible to show or hide columns in a report on the fly, i.e. without having to run the report again?
I have a report in with a parameter to let the user choose between the data to show. However the customer doesn't like it that he has to rerun the report. Any help would be appreciated!
Regards,
Henk
How would I hide certain parameter controls based on user sections in certain controls dynamically at runtime. I am using RS 2003 edition.
View 5 Replies View RelatedI have a parameter "time frame" which contains two value- 6 months ,12 months an 18 months which shows data of 6 months , 12 months and 18 months.
In my ssrs report i have 18 columns :
jan|feb|mar|apr|may|jun|july|aug|sep|oct|nov|dec|jan|feb|mar|apr|my|jun
The first six months will be displayed in each case.
But when i choose 6 months i just want to display first six months only.when i choose 12 months i want to be displayed first 12 months columns only and for 18 months all the columns,.
Hi,
I have some sensitive and non-sensitive info/fields in one of my reports. Is there a way to hide/show the info based on the logged in user? or do I have to create separte reports for each type of info like one for sensitive and another one for non-sensitive info.
Thanks inadvace for your help!
Hi All,
I need to show the Cumulative calculated value only in Total by year/Group. I could not use Visibility expression using
InScope, as it creates *Blank column. Please go thru details below.
Year
Month01 02 03 Total
Salary Salary Salary Salary Cumulative (Calc)
Employee01 20 5 25 25
Employee02 10 10 20 45
.....
Total
How can i achieve this?. Any suggestion on this would be appreciated.
Thanks,
Hi,
Is it is possible to hide some parameters in report? Also it should be possible to pass values to this hidden parameters from the application. When I did this through Report Manager, some error message like ' the parameter 'XXXX' is read-only. ....' appears.
Thank You
Sreeraj.P.T
Hello,
I am wondering if RS has the capability to minimize the parameter portion on the top. I see that parameter can be hidden, but I would need the capability to just minimize and if the user needs to change the parameter, they can still click on a button to un-minimize.
Does that make sense?
-Lawrence
HI All,
I want to send a reports to two person. Reports are going to be delivered automatically. I hope to use snapshot option. In my report there is one column which can be seen by only one person. Can I use parameters to hide one column from one person? If its possible, can you explain how to do that please. If its not possible, what are the other option excet creating two different reports.
Also If I use parameters , can reports be executed automatically?
Thanks
Hi,
anyone has any idea how to make the parameters toolbar to be automatically hidden when the report is first being accessed and subsequently to show the parameters when clicked on the arrows ? I have some users who complained that the parameters list is too long, so they wish to hide it first when accessing the report. I know there's this called rc: Parameters=false but this will permanently hide the toolbar which i don't want.
By the way, i am using sql 2000 reporting services
Hello Everyone,
I have a report which runs in local mode and while designing the report I have placed a single image control inside the list box as I don't know before hand how many images are there :
What is the way to show all the images using the one image control inside the report viewer control. ? Can be 2 or 3 or 4.....
Thanks for all the help.
Harsimrat
I created some controls for filtering the report that will be displayed on the same page, but below these controls. The controls take about 200px of the top of the form, while the report will be displayed in the rest of the page.
I'm using the ReportViewer control in Async mode, so it's being rendered as an Iframe, and this is necessary because some reports will take up to a couple minutes, so I want the loading animation.
As many of you know, this type of scenario will cause two scrollbars to be shown on this Web form: one for the main form, and the other for the Iframe containing the report. To prevent this, I have html,body set to overflow:hidden. This works great at preventing the outer scrollbar from showing, and only the report has a scrollbar.
The problem is that the bottom 200px (see first paragraph above) of the report doesnt show and cant be scrolled to. Has anyone come across a solution for this situation?
I'm basically stuck either having a report with two side by side scrollbars, or a report with 1 scrollbar that cuts off the last portion of each page of a report.
Hello everyone,
Our customer wants to display the exporting date only in the exported file when exports a report to PDF/Excel (we are using ReportViewer Control in ASP.NET). Can anybody tell me how to achieve this?
Thanks a lot.
Danny Li
Hi all,
I have a datamining model and i want to show the model parameters on a webpage. The model is a decisiontree. Is there a method i can use to show a formula of the decisiontree on a page or is a visual representation the only solution to visualize the tree?
How can i visualize the tree? Can I use the data mining add-ons for office 2007 to make a tree in visio and afterwards publish the tree on a sharepoint site? If that is possible is the visualization dynamic, if the model changes does the visualization changes too?
The data mining viewers i think, i can't use because there work only with windows forms. Are there other methods to visualize a decision tree on a webpage?
Thanks,
Dennis
Hi guys,
I have a gridview and textbox. I can filter the grid just fine with the textbox, but I would like to allow the user to type in part of a name.
I thought something like this would work but it doesn't:
Emp_Name LIKE '%'+@Emp_Name+'%'
Thank you.
SelectCommand="SELECT [id], [ref_id], [ref_name] FROM [ref] where [delete_flag] = 'N' AND [flag_transmit] = 'N' AND [ref_name] = @ref_name ">
<asp:ControlParameter Name="ref_name" ControlId="SrchRefName" PropertyName="Text" ConvertEmptyStringToNull="false"/>
The gridview of all the records is displayed on the page by default. There is a lookup of SSN and Name and putting values in those fields should filter the records and display only the row containing entered Name.I have trouble with the SelectCommand. No gridview is displayed with the above command even if value is entered in the Lookup textBox (SrchRefName).But when I change the selectcommand to- (using OR) SelectCommand="SELECT [id], [ref_id], [ref_name] FROM [ref] where [delete_flag] = 'N' AND [flag_transmit] = 'N' OR [ref_name] = @ref_name "> <asp:ControlParameter Name="ref_name" ControlId="SrchRefName" PropertyName="Text" ConvertEmptyStringToNull="false"/> the default gridview is displayed with all the records even though a value is entered in the lookup text box. Please help.
Hi All,
I have not heard any news on this topic elsewhere so thought I would ask here....
I would like to gain control over parameters in terms of:
1. Parameter placement as in how many parameters on a row, not just 2. It would be nice to be able to specify a row number in the defintiion of a parameter for example.
2. Access to the parameter text via a custom assembly to support multi-langauge reports.
I know other folks have talked about these things and some of us 'hope they are coming one day'...I was wondering if that day might be any closer now?
Thanks
Hello,
I'm trying to do something simple but can't make it work. I want to use the result of this sql "Select MAX(Stoptime) AS LatestStop FROM Stoptime" and use it in "Delete from Stoptime Where Stoptime > ?" but here with just the date. How do I set this up with parameters in the Control Flow in Integration Services?
Regards,
Kristian
Sweden
I have reportviewer control into the aspx page and i want to save the parameters informations to the database. but i also want to stick with reportviewer parameter UI instead of my own UI.
Is that possible using ReportViewer?
Thanks in Advance
Rohit
Hi.
Is it possible to set Parameters for the reportViwer control in remote mode.
I tried doing this
ReportViewer1.ServerReport.SetParameters(Session("ClientId")) and got this error
Unable to cast object of type 'System.Int32' to type 'System.Collections.Generic.IEnumerable`1[Microsoft.Reporting.WebForms.ReportParameter]'.
I am just wondering if i can control the access of range of variables from users' logins.
To be more specific, if i a parameter alpha has five values (1,2,3,4,5) and then i have 3 users A, B C, what i need is:
1. A can access Vaues(1, 3)
2. B can access Values (2, 4)
3. C can access Values(3,5)
Is there anyway i can do this either from the stored procedure i am getting the data or i can do it on SSIS development side?
I am trying to create a manifest for one of our clients and want to show the total qty for a product.
Below is my query, the quantity is listed below as TL.Quantity but I think I need to use a SUM function to show the total by product?
Select
TH.TransactionDate,
TH.Reference,
TransactionAccountNumber.AccountNumber as [Client Ref],
Product.Code,
Product.Description,
[Code] ....
Hi guys
I have a table which I need to analyze, what jobs this is working with, what stored procedure is calling this table etc. Is there any built-in function to show me or anybody know how to do it? This is my new job, and there are hundreds of stored procedures and jobs, do i really have to go thru one by one?
Please help.
Michelle
We have been a Crystal shop for ages; we are currently doing a proof-of-concept for a conversion to MS Reporting Services. As such, we are developing some Analysis Services 2005 cubes to drive some new SSRS reports, which our users will access through Report Manager. Unfortunately, we are all MDX noobs here, so we are making heavy use of the Wizards until we can come up to speed.
The problem we are running into is when we develop a report with Date Parameters. When we deploy this report, the date parameter box is a dropdown box instead of a date picker. I've seen a couple of other posts on this topic, but when I try to apply the fixes mentioned in them, I throw errors.
I have two quick questions:
Why does this happen? Is it a limitation in the MDX language, in SSAS, or SSRS? Are there any planned fixes?
Can someone please show me how to fix this on my actual query string for one of our basic reports? I've highlighted the date parameters.
Code Snippet
SELECT NON EMPTY { [Measures].[Lead] } ON COLUMNS, NON EMPTY { ([Store].[Store ID].[Store ID].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@LeadSourceTypeLeadSourceType, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StoreStoreID, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOMEMBER(@FromLeadCreationDateCalendarDate, CONSTRAINED) : STRTOMEMBER(@ToLeadCreationDateCalendarDate, CONSTRAINED) ) ON COLUMNS FROM [Referral Leads]))) WHERE ( IIF( STRTOSET(@LeadSourceTypeLeadSourceType, CONSTRAINED).Count = 1, STRTOSET(@LeadSourceTypeLeadSourceType, CONSTRAINED), [Lead Source Type].[Lead Source Type].currentmember ) ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS
I'm afraid, given my user community, that if I can't get the date picker to work properly, it could be a deal breaker.
Thanks very much in advance for your help.
Regards,
Steve
I have a combo box named [myControl] on an Access form that I can use to select/enter a site name (ABC). There is a button on the same form that runs a report. The underlying record source for the report is a SQL Function. Is there an easy way to pass the combo box value to the SQL Function so that only records for site 'ABC' are displayed in the report? I tried Forms![myForm]![myControl] in the criteria box of the Function and it did not work. THANKS!
View 3 Replies View Related