Resorting a report by Column click

have a report that has about 7 columns
I would like to enable the user to be able to resort the report by simply
clicking on a column heading. For example if my Column names are
County Organization Name Program Name
I would the user to be able to click the County Column header and re-sort
the entire report in a descending alpha order and then also click
Organization name column header to re-sort by column name.
Anyone have any ideas of how this might be accomplished?Various approaches for RS 2000 have been discussed on this newsgroup. Search
the newsgroup for "dynamic sort column" or similar keywords.
You may also want to check a sample posted on GotDotNet:
http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=6a347b53-5594-40f9-861d-876beabeda16
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Report Guy" <Report Guy@.discussions.microsoft.com> wrote in message
news:F6EA8E3B-5810-4914-82D7-520C749E4B11@.microsoft.com...
> have a report that has about 7 columns
> I would like to enable the user to be able to resort the report by simply
> clicking on a column heading. For example if my Column names are
> County Organization Name Program Name
> I would the user to be able to click the County Column header and re-sort
> the entire report in a descending alpha order and then also click
> Organization name column header to re-sort by column name.
> Anyone have any ideas of how this might be accomplished?|||There are also several more examples on www.msbicentral.com
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:up5254EHFHA.2740@.TK2MSFTNGP12.phx.gbl...
> Various approaches for RS 2000 have been discussed on this newsgroup.
> Search the newsgroup for "dynamic sort column" or similar keywords.
> You may also want to check a sample posted on GotDotNet:
> http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=6a347b53-5594-40f9-861d-876beabeda16
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Report Guy" <Report Guy@.discussions.microsoft.com> wrote in message
> news:F6EA8E3B-5810-4914-82D7-520C749E4B11@.microsoft.com...
>> have a report that has about 7 columns
>> I would like to enable the user to be able to resort the report by simply
>> clicking on a column heading. For example if my Column names are
>> County Organization Name Program Name
>> I would the user to be able to click the County Column header and re-sort
>> the entire report in a descending alpha order and then also click
>> Organization name column header to re-sort by column name.
>> Anyone have any ideas of how this might be accomplished?
>|||Ok I went to the link that you posted below. I downloaded the sample report
and am trying to figure it out. Where is the code other other event that
does the re-sort?
I copied the same report parameters into the project I'm working on and they
didn't work. Of course, i taylored the fields in the database to field names
I have in my DB, but I can't get the resort to work. There's no readme or
other documentation, so i'm hoping someone can help me out...
"Robert Bruckner [MSFT]" wrote:
> Various approaches for RS 2000 have been discussed on this newsgroup. Search
> the newsgroup for "dynamic sort column" or similar keywords.
> You may also want to check a sample posted on GotDotNet:
> http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=6a347b53-5594-40f9-861d-876beabeda16
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Report Guy" <Report Guy@.discussions.microsoft.com> wrote in message
> news:F6EA8E3B-5810-4914-82D7-520C749E4B11@.microsoft.com...
> > have a report that has about 7 columns
> >
> > I would like to enable the user to be able to resort the report by simply
> > clicking on a column heading. For example if my Column names are
> > County Organization Name Program Name
> >
> > I would the user to be able to click the County Column header and re-sort
> > the entire report in a descending alpha order and then also click
> > Organization name column header to re-sort by column name.
> >
> > Anyone have any ideas of how this might be accomplished?
>
>

Reposting: Expand All / Collapse All feature

1. Is there a way to Expand All nodes or Collapse All Nodes in a drill-down
report designed with RS ? I find it annoying to click every + sign to open
all nodes. Maybe, there is an easier way that I do not know.
2. When the same drill-down report is partially expanded and I export the
report as-it-is to Excel, the exported file has only the partial
data.....only the data that was expanded. The other data is never exported.
What can I do to resolve this ?
Please respond.Yes, you can do this.
Step 1) Create a textbox outside of your table/matrix. Give it a name, e.g.
Toggler. Step 2) Highlight the row you want to hide/show. Set its Visibility
Hidden property to False, and use the textbox you created at Step 1 as the
ToggleItem property.
Charles Kangai, MCT, MCDBA
"DC" wrote:
> 1. Is there a way to Expand All nodes or Collapse All Nodes in a drill-down
> report designed with RS ? I find it annoying to click every + sign to open
> all nodes. Maybe, there is an easier way that I do not know.
> 2. When the same drill-down report is partially expanded and I export the
> report as-it-is to Excel, the exported file has only the partial
> data.....only the data that was expanded. The other data is never exported.
> What can I do to resolve this ?
> Please respond.
>
>|||Also, if you put the visibility settings at Group line level (i.e.
highlight the whole group by clicking on the left hand tab) rather cell
level, when you export to Excel you'll get full outlining/grouping for
ALL data regardless of how the report is currently 'expanded'. (This
only works with SP1).
Regards
Chris
Charles Kangai wrote:
> Yes, you can do this.
> Step 1) Create a textbox outside of your table/matrix. Give it a
> name, e.g. Toggler. Step 2) Highlight the row you want to hide/show.
> Set its Visibility Hidden property to False, and use the textbox you
> created at Step 1 as the ToggleItem property.
> Charles Kangai, MCT, MCDBA
> "DC" wrote:
> > 1. Is there a way to Expand All nodes or Collapse All Nodes in a
> > drill-down report designed with RS ? I find it annoying to click
> > every + sign to open all nodes. Maybe, there is an easier way that
> > I do not know.
> >
> > 2. When the same drill-down report is partially expanded and I
> > export the report as-it-is to Excel, the exported file has only the
> > partial data.....only the data that was expanded. The other data
> > is never exported. What can I do to resolve this ?
> >
> > Please respond.
> >
> >
> >
> >|||Here is an expand all that I am using:
Create Report parameter: "ExpandAll"
Available Values:
Label: Yes Value: True
Label: No Value: False
Default Value: No
Group1: =Fields!Status.Value
Initial Appearance Expression: =IIF( Parameters!ExpandAll.Value = true,
true, false)
Group2 =Fields!Name.Value
Initial Appearance Expression: =IIF( Parameters!ExpandAll.Value = true,
true, false)
Visibility:
Hidden expression: =IIF( Parameters!ExpandAll.Value = true, False, True)
ToggleItem: Status
Detail records:
Visibility:
Hidden expression: =IIF( Parameters!ExpandAll.Value = true, false, true)
ToggleItem: Name
Good luck,
Chuck Kee
"Chris McGuigan" wrote:
> Also, if you put the visibility settings at Group line level (i.e.
> highlight the whole group by clicking on the left hand tab) rather cell
> level, when you export to Excel you'll get full outlining/grouping for
> ALL data regardless of how the report is currently 'expanded'. (This
> only works with SP1).
> Regards
> Chris
> Charles Kangai wrote:
> > Yes, you can do this.
> > Step 1) Create a textbox outside of your table/matrix. Give it a
> > name, e.g. Toggler. Step 2) Highlight the row you want to hide/show.
> > Set its Visibility Hidden property to False, and use the textbox you
> > created at Step 1 as the ToggleItem property.
> >
> > Charles Kangai, MCT, MCDBA
> >
> > "DC" wrote:
> >
> > > 1. Is there a way to Expand All nodes or Collapse All Nodes in a
> > > drill-down report designed with RS ? I find it annoying to click
> > > every + sign to open all nodes. Maybe, there is an easier way that
> > > I do not know.
> > >
> > > 2. When the same drill-down report is partially expanded and I
> > > export the report as-it-is to Excel, the exported file has only the
> > > partial data.....only the data that was expanded. The other data
> > > is never exported. What can I do to resolve this ?
> > >
> > > Please respond.
> > >
> > >
> > >
> > >
>