I know this is not available now, but is it plan in the near future:
I want to be able to set the initial sort order on the interactive sort.
for example, I have a report sorted Asc by Rank. If I click on the interactive sort button on the Rank column, it resorts ascending... totally pointless, and my customers point this out on a weekly basis...
Any plans to add this feature? If not, I will go to connect and suggest it.
You say, "we enjoy the option of specifying sorting for multiple columns within the matrix, table or list within which we are working." But, when I add interactive sorting to the headers of a matrix, the up and down toggles appear in the preview, but the rows are not sorted after clicking.
This works perfectly fine on tables, as you say, but I have yet to see it on a matrix.
Is there any way to change the interactive sorting icon or even adjust it? When I add the functionality to a column, it skews the column heading to make room for it. This means that reports that previously displayed properly no longer look correct. If I adjust the width of the report to allow room for the icon, then the report overflows its boundary in terms of printing.
Also, the icon does not display evenly all the time. Sometimes, it displays directly next to the text and sometimes it is off to the right more.
Does clicking interactive sort button in a column reporting services 2005 result re-execution of the query. Or will it just re-print the rendered data in the layout and so perform better in comparison to the implementation which can be done using drill down to same report with the help of some extra parameters
I want to implement interactive sorting on few columns of my report. That is working fine but the the button coming for interactive sort is taking extra space.
I have some space constrains due to too many columns in the report and so i want that implementation without the button(its taking extra space and also ruining the alignment) , may be with a underline in the column header like hyperlink or something.
I have a report  that has a drill down option that shows all workgroups within a specific  parent group and an interactive sorting ass well on both columns  parent group &  workgroupÂ
This is displayed  in pps combined with a SharePoint
The problem is that after sorting the parent group column by name I then press the drill through icon  (+) next to it hopping to see all workgroups related to each parent group - but insteadÂ
I receive this Reporting Services Error  :
The value for parameter 'SortItem' is not specified. It is either missing from the function call, or it is set to null. (rsMissingParameter)
If I don't press the sorting and just drill through it works fine. the sorting itself also works fine.
I have a report that contains a table with certain columns that have interactive sorting. At the top of the report there is a subreport that contains an embedded image. When I first run the report, the image in the subreport displays. But, when I sort the table interactively, the image turns into a red asterisk inside a white box. When I click the 'refresh' button, the image redisplays correctly. This is occurring in the Visual Studio 2005 Report Designer when you preview the report. I believe I have the most current version of Visual Studio. I'm not sure what to do about this. Any suggestions?
I've been reading a lot of posts on this subject. I understand that the issue is due to the fact that the subreport is only rendered once. So after the main report is sorted on another column, the cell with the subreport produces an error.
What I want to know is whether or not this is considered a defect. And if it is a defect, is it fixed in another version?
I am currently running SSRS SQL2008R2 SP2 (20.50.4000.0)
I am using Report Builder 3.0 and i have report which has a drill down group. The report opens in a collapsed form.This report has interactive sorting on a column. But,when we drill down and sort the column, the group collapses and the details disappear.
In some posts, i have seen that instead of interactive sorting, people recommended a parameter. But i have to do interactive sorting only.
I am facing one problem with reporting services 2005 (SSRS), When i try to pass a parameter to Cube which is built in SSAS, i can not use a parameter where i can type the value instead of choosing it from a dimension.
Any way we can type the value for parameter, instead choosing from the drop down? If can, then how can we create the parameter? and how can i write a MDX to read it?
I have a report where I am giving the users a parameter so that they can select which field they would like to sort on.The report is also grouping by that field. I have a gruping section, where i have added code to group on the field I want based on this parameter, however I also would like to changing the sorting order but I checked around and I did not find any info.
So here is my example. I am showing sales order info.The user can sort and group by SalesPerson or Customer. Right now, I have code on my dataset to sort by SalesPerson Code and Order No.So far the grouping workds, however the sorting does not.
SSRS 2012 - VS2010...The report compares two years with a sort order on a value that has been engineered based on text switched to int. Â When sorting A-Z this is the result in the horizontal axis is: 5th, K, 1st, 2nd, 3rd, 4th, 5th..When sorting Z-A the result in the horizontal axis is:5th, 4th, 3rd, 2nd, 1st, PreK..Z-A is correct but A-Z sorting shows 5th as the start and end. Â The magnitude of the PreK location is correct but the label is wrong on the A-Z sort order. Â The sorting is implemented using the Category Group sorting option.
I am migrating few my oracle codes to T-SQL. Currently am using & (ampersand) interactive prompt of SQLPlus. Is there any equivalent for the above said in SQL Server.
Software packages like Microsoft Small Business Accounting and Quickbooks offer a very powerful reporting module that lets end users change grouping, filtering, sorting, etc at run time (having it change the report dynamically infront of them). More importantly, their reporting tools let users click on details on the reports which opens the data in the form based portion of their software.
For example: If the end user pulls up a financial report, lets say "All Bills for February 07", the user get a report of all the bills that have gone out in that time frame. The end user can then click on the actual details in the report, and the Bill will come up in the Windows Forms portion of their software so they edit the bill, or create a new bill.
I have done a very limited amount of reporting in SQL Server, so I am not sure of how they were able to achieve this. If someone could give me some key words or ideas that I can bring up more information from in google, or even on here, I'd appreciate it.
I have a report that lists customers. Is it possible to create an interactive mechanism so that a user can somehow select a customer and have a subreport update to show that customer's data, without jumping away from the parent report?
We have an issue with interactive sorting. Interactive sorting works in our Dev and test environments but does not work on our production server. We have deployed exactly the same report to each server. All servers are sp2 (9.00.3042.00). When the interactive sort buttons are clicked on production nothing happens. Has anyone seen this?
I can't get interactive sort to work on Report Server reports (but it works on reports I've done in Report Builder using one table per report). I tried it on a different database in a Report Server report and it did work.
There was another post that talked about the collation, which is Latin1_General_CI_AS_KS_WS for the ReportServer and ReportServerTempDB, and SQL_Latin1_General_CP1_CI_AS for the two databases I reported on. But it seems like I'm not doing something correctly since it works in RB but not RS (though the one database report did work).
I am trying to create a dashboard that is split into the five main focus areas of Customer, Finance, Management, People and Innovation. Each focus area has a main report and a series of subreports (within a panel). I use the €˜Jump to report:€™ property at the domain level €“ which works well.
My problems arise when dealing with the subreports. For example, in the €˜People€™ focus area €“ the panel contains 4 subreports covering; contractor vs. fte trends, gender balance trends, compliance trends and investment trends.
Ideally I would like to have four €˜tabs€™ which when clicked would show the relevant subreport. I know this can be done via a full report refresh, but it looks clumsy and is more complex and costly to maintain.
I am happy for any method that might change the €˜Subreport€™ property dynamically or set the visibility of the objects. I want to avoid using the toggle capability as this could result in two or more subreports conflicting and being visible at the same time.
We have run into a really bizzare problem after upgrading to SQL Server 2005 SP2. We have a bunch of matrix reports that have interactive sort in the upper left hand corner, the sort based on Numeric and Text fields. For Example
=Fields!City.Value
=Sum(Fields!Pax.Value)
Now for whatever reason after upgrading to SP2 and making NO CHANGES to the reports or under data sources, interactive sorts that use the =Sum(....) no longer work but interactive sorts on text values still work.
I am new to reporting services. We are creating a report with drill-down capability. We have a Date dimension hierarchy defined as Year - Month - Day.
On the report, we expect reporting services send MDX query to SSAS to get the total sales just for the the year, say 2007, when we click the year 2007. Then it send query just to aggregate sales for that month when we click a month.
But when we build the reports, it looks like it always aggregate for all levels. So the performance is bad to first open the report.
I have a table with WritingMode for the column labels set to tb-rl (vertical writing). I want the text in each label to be right-aligned (i.e. aligned along the actual bottom of the cells), so I set TextAlign = Right. This works fine for all columns until I enable Interactive Sort. When Interactive Sort is activated TextAlign ignores the value and always behaves as if General (or Center) was selected. Is there a solution to this?
By the way: Is it possible to have the vertical text written upwards (bt-lr) instead of downwards?
I've been having trouble getting my RS2005 reports with interactive features (drilldowns) to work in an Iframe and rendered with SOAP.
The main problem now is that the toggle buttons (+ / -) point to the reporting services server and do a URL Access call. I've tried the <ReplacementRoot> element in the DeviceInfo parameter but it doesn't appear to do anything.
I keep on reading about how everything is possible through the web services but it looks as if these interactive features are only available using the URL Access. Is this true?
I'm setting 'interactive sort' property on some columns of my SSRS report. By some reason, this functionality works only for some columns. Settings do not produce any errors and everything is OK on preview level but when report is accessed through web-based Report Manager only some of the sorting arrows appear.
I making a report using Matrix with 2 row groups and 1 column group. The group names are:
Row : CompanyName, TotalUsers
Column: UserType
Detail Group has a count of number of user in each type.
I want to use interactive sort feature on my column group so that when I click on my column header, it sort my detail group data ascending or decending and companyName and total users based on datail group.
In VS 2005 with SQL Server Express: How do I debug a stored procedure that is called from a object datasource control while the asp.net code is running? Thanks
I'm trying to setup the Interactive Conflict Resolver in my C# app via RMO. (using SQL Server 2005)
The only article I can find on MSDN or anywhere is involing T-SQL. Can someone please shed some light on this for me specificaly on the subscriber side.
I have a subreport that has interactive sort on one of the columns in a table. The interactive sort works well when i run the subreport. But when i run the parent report that contains the subreport then the interactive sorting does not work.
Has anyone come across this issue, any help will be greatly appreciated.
My reports are not allowing me to "Clickthrough" to more detailed reports.
I want my report to automatically show a detail record when they select some "interactive data" in my reports.
I have read a page on this stuff ( http://msdn2.microsoft.com/en-us/library/ms345252.aspx ) which states:
In Report Builder, a clickthrough report is a report that provides detailed information about the data contained within the main report. A clickthrough report is displayed when the Report Builder user clicks the interactive data that appears in the main report. These reports are automatically generated by the report server. You, as the model designer, determine what is displayed in clickthrough reports by setting the DefaultDetailAttribute and DefaultAggregateAttribute properties that you assign to an entity in the report model.
Hence, within my report model i have created an entity with a number of DefaultDetailAttributes.
I have not created a specific "click through" report as i would be happy to view the automatically generated report that should contain the attributes defined in the "DefaultDetailAttributes" list.
However, when i view the report, no data items are links (or "interactive data" as the msdn article describe them).
Has anyone got any ideas on how to make the report data interactive?
