Interactive sort not working if sub report

Hi,
I am having an issue that when a sub report that contains fields that
are setup to do interactive sort only work if they are displayed as the
parent report. If they are included as a sub report when trying to do
a sort the page just posts back but comes back unsorted.
Is there a work around for this or is it just not possible on SSRS
2005?
Please Help!
Chrischris wrote:
> Hi,
> I am having an issue that when a sub report that contains fields that
> are setup to do interactive sort only work if they are displayed as the
> parent report. If they are included as a sub report when trying to do
> a sort the page just posts back but comes back unsorted.
> Is there a work around for this or is it just not possible on SSRS
> 2005?
> Please Help!
> Chris|||Chris,
I had the same problem with sorting in a sub report, I then changed my
report to not contain a sub report, however I found that when you group
your data in a table using a "Group On" expression, sorting does not
work either. Sorting only appears to work on non-grouped data fields
in a table and not in a sub report.
chris wrote:
> Hi,
> I am having an issue that when a sub report that contains fields that
> are setup to do interactive sort only work if they are displayed as the
> parent report. If they are included as a sub report when trying to do
> a sort the page just posts back but comes back unsorted.
> Is there a work around for this or is it just not possible on SSRS
> 2005?
> Please Help!
> Chris|||my report with sub-report is word well when sorting.

Interactive sort doesn't work for multiple sub-reports

I have a report, which contains two nearly identical sub reports. In the IDE, when I test the containing report, each of the sub-reports works fine, in particular, the interactive sort feature works for both. When I deploy the reports to the test server (desktop running Windows XP, SQL Server 2005 Developer’s Edition, and SQL Reporting Services 2005, reports are served as web pages), the interactive sort feature seems to work only for one of the sub-reports. The other sub-report causes a postback, and refreshes, but does not return sorted. It appears as though whichever sub-report I attempt to sort first, sorts fine. When I attempt to sort the other sub-report, it does not sort.

Any ideas?

May not help, but when I have gotten these types of errors before, often deleting the primary and sub-reports from the Report Server and then redeploying all reports will help. I don't know why, but we have to do that often for deployment when there are certian types of changes.

Good luck.

|||Thanks for the reply! Unfortunately, this did not help. Anyone else run into problems with the built-in sorting for sub-reports?|||

Hi Dan -

I was not able to reproduce your problem with mulitple subreports and user sort. Could you please go to http://connect.microsoft.com/ and file a defect report and attach your .rdl files.

Thanks, Jon
SQL Reporting Services Team

|||

i have the same problem. A report with 3 sub-reports, on the third one the sort seem's to be disabled, i can see arrows but if i click on them only a postback occur without sorting and the two arrows stay (normally only one remain into a blank circle after a sort). If i run this sub-report alone, the sorting is working.

If i remove the third sub-report, the same problem happen on the second sub-report. The sorting was working before. Strange bug i think.

I have SQL Server 2005 SP1 with the latest fix after SP1 installed.

Sorry for my poor english... :)

Interactive sort doesn't work for multiple sub-reports

I have a report, which contains two nearly identical sub reports. In the IDE, when I test the containing report, each of the sub-reports works fine, in particular, the interactive sort feature works for both. When I deploy the reports to the test server (desktop running Windows XP, SQL Server 2005 Developer’s Edition, and SQL Reporting Services 2005, reports are served as web pages), the interactive sort feature seems to work only for one of the sub-reports. The other sub-report causes a postback, and refreshes, but does not return sorted. It appears as though whichever sub-report I attempt to sort first, sorts fine. When I attempt to sort the other sub-report, it does not sort.

Any ideas?

May not help, but when I have gotten these types of errors before, often deleting the primary and sub-reports from the Report Server and then redeploying all reports will help. I don't know why, but we have to do that often for deployment when there are certian types of changes.

Good luck.

|||Thanks for the reply! Unfortunately, this did not help. Anyone else run into problems with the built-in sorting for sub-reports?|||

Hi Dan -

I was not able to reproduce your problem with mulitple subreports and user sort. Could you please go to http://connect.microsoft.com/ and file a defect report and attach your .rdl files.

Thanks, Jon
SQL Reporting Services Team

|||

i have the same problem. A report with 3 sub-reports, on the third one the sort seem's to be disabled, i can see arrows but if i click on them only a postback occur without sorting and the two arrows stay (normally only one remain into a blank circle after a sort). If i run this sub-report alone, the sorting is working.

If i remove the third sub-report, the same problem happen on the second sub-report. The sorting was working before. Strange bug i think.

I have SQL Server 2005 SP1 with the latest fix after SP1 installed.

Sorry for my poor english... :)