|
|
You're in the
sql server reporting services
group:Sorting?
sql server reporting services:
can simply click the column header to sort? Is this functionality not available? I have tried exporting to excel and find that my columns are merged together for the table and I get an error when I try to sort in Excel. Seems pretty handicapped to me, am I missing something?
There are ways around the sorting issue but it takes effort (basically you
create links at the top that when you click on it you re-run the report with the new sorting. The next version will have sorting built in. As far as Excel, I just fought through this myself. What is happening is if there is anything above your table then when it exports it to Excel it merges cells together which messes up doing any sorting. Here is what I did. I create a copy of the report that I take out anything above the table (no extra textboxes). I hide the report because no one needs to use it directly. Then I create a link at the top of the report that uses jump to URL where I pass in the parameters of the current report to the copy and I specify to render it as Excel. You now end up with the data they were just looking at but in a format that is better for Excel (no merged cells). -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "Becker" <Becker@discussions.microsoft.com> wrote in message news:B98EB1E3-E200-4ED0-8C90-A7A9B642BF5C@microsoft.com... >I see how I can sort data in a table or list, but how do I make it so users > can simply click the column header to sort? Is this functionality not > available? > > I have tried exporting to excel and find that my columns are merged > together > for the table and I get an error when I try to sort in Excel. > > Seems pretty handicapped to me, am I missing something? >
Thanks Bruce, I suppose this will work as a work around. Seems cumbersome,
but oh well. Do you have any examples of the way to get the links to appear on the HTML report page? Does that involve adding custom code to the report? [quoted text, click to view] "Bruce L-C [MVP]" wrote:
> There are ways around the sorting issue but it takes effort (basically you > create links at the top that when you click on it you re-run the report with > the new sorting. The next version will have sorting built in. > > As far as Excel, I just fought through this myself. What is happening is if > there is anything above your table then when it exports it to Excel it > merges cells together which messes up doing any sorting. Here is what I did. > I create a copy of the report that I take out anything above the table (no > extra textboxes). I hide the report because no one needs to use it directly. > Then I create a link at the top of the report that uses jump to URL where I > pass in the parameters of the current report to the copy and I specify to > render it as Excel. You now end up with the data they were just looking at > but in a format that is better for Excel (no merged cells). > > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > "Becker" <Becker@discussions.microsoft.com> wrote in message > news:B98EB1E3-E200-4ED0-8C90-A7A9B642BF5C@microsoft.com... > >I see how I can sort data in a table or list, but how do I make it so users > > can simply click the column header to sort? Is this functionality not > > available? > > > > I have tried exporting to excel and find that my columns are merged > > together > > for the table and I get an error when I try to sort in Excel. > > > > Seems pretty handicapped to me, am I missing something? > > > >
I haven't done this but I assume it is a matter of creating a link (any text
box you can do a right mosue click, properites, advance properties) and get to where you set the jump to URL. Another simple this is to add a sort by report parameter and then have that part of your sql. You can use an expression for your sql. ="select * from sometable order by " & parameters!Paramname.value -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "Becker" <Becker@discussions.microsoft.com> wrote in message news:C8DD7EB0-F534-4410-8CF3-8799C2E02CC4@microsoft.com... > Thanks Bruce, I suppose this will work as a work around. Seems > cumbersome, > but oh well. > > Do you have any examples of the way to get the links to appear on the HTML > report page? Does that involve adding custom code to the report? > > "Bruce L-C [MVP]" wrote: > >> There are ways around the sorting issue but it takes effort (basically >> you >> create links at the top that when you click on it you re-run the report >> with >> the new sorting. The next version will have sorting built in. >> >> As far as Excel, I just fought through this myself. What is happening is >> if >> there is anything above your table then when it exports it to Excel it >> merges cells together which messes up doing any sorting. Here is what I >> did. >> I create a copy of the report that I take out anything above the table >> (no >> extra textboxes). I hide the report because no one needs to use it >> directly. >> Then I create a link at the top of the report that uses jump to URL where >> I >> pass in the parameters of the current report to the copy and I specify to >> render it as Excel. You now end up with the data they were just looking >> at >> but in a format that is better for Excel (no merged cells). >> >> >> -- >> Bruce Loehle-Conger >> MVP SQL Server Reporting Services >> >> "Becker" <Becker@discussions.microsoft.com> wrote in message >> news:B98EB1E3-E200-4ED0-8C90-A7A9B642BF5C@microsoft.com... >> >I see how I can sort data in a table or list, but how do I make it so >> >users >> > can simply click the column header to sort? Is this functionality not >> > available? >> > >> > I have tried exporting to excel and find that my columns are merged >> > together >> > for the table and I get an error when I try to sort in Excel. >> > >> > Seems pretty handicapped to me, am I missing something? >> > >> >> >>
Interactive sort is not available in RS 2000, but is being added to RS 2005.
-- Rajeev Karunakaran [MSFT] Microsoft SQL Server Reporting Services This posting is provided "AS IS" with no warranties, and confers no rights. [quoted text, click to view] "Becker" <Becker@discussions.microsoft.com> wrote in message news:B98EB1E3-E200-4ED0-8C90-A7A9B642BF5C@microsoft.com... >I see how I can sort data in a table or list, but how do I make it so users > can simply click the column header to sort? Is this functionality not > available? > > I have tried exporting to excel and find that my columns are merged > together > for the table and I get an error when I try to sort in Excel. > > Seems pretty handicapped to me, am I missing something? >
Hi Bruce,
I am currently facing the same problem where in when I export to excel, the users are not able to sort on the columns as the cells are merged. I have report where in I have 4 column headers and below which I display the rows of data associated with the columns. What I do not understand is, how do the remove the extra text boxes when I make a copy of my report rdl file. I dont see any extra text boxes but I have spaces between column names. Is that what you mean by extra text boxes? Eg. Col1 Col2 Col3 Col4 -------------------------------------------- A1 A2 A3 A4 B1 B2 B3 B4 ...... In the above case, is there a better way to format the columns without any spaces? If so, please advice. I need to export this to excel and then sort by all the 4 columns above. Any assistance in this regard will be very helpful. Thanks Mukund [quoted text, click to view] "Bruce L-C [MVP]" wrote:
> I haven't done this but I assume it is a matter of creating a link (any text > box you can do a right mosue click, properites, advance properties) and get > to where you set the jump to URL. > > Another simple this is to add a sort by report parameter and then have that > part of your sql. You can use an expression for your sql. > > ="select * from sometable order by " & parameters!Paramname.value > > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > "Becker" <Becker@discussions.microsoft.com> wrote in message > news:C8DD7EB0-F534-4410-8CF3-8799C2E02CC4@microsoft.com... > > Thanks Bruce, I suppose this will work as a work around. Seems > > cumbersome, > > but oh well. > > > > Do you have any examples of the way to get the links to appear on the HTML > > report page? Does that involve adding custom code to the report? > > > > "Bruce L-C [MVP]" wrote: > > > >> There are ways around the sorting issue but it takes effort (basically > >> you > >> create links at the top that when you click on it you re-run the report > >> with > >> the new sorting. The next version will have sorting built in. > >> > >> As far as Excel, I just fought through this myself. What is happening is > >> if > >> there is anything above your table then when it exports it to Excel it > >> merges cells together which messes up doing any sorting. Here is what I > >> did. > >> I create a copy of the report that I take out anything above the table > >> (no > >> extra textboxes). I hide the report because no one needs to use it > >> directly. > >> Then I create a link at the top of the report that uses jump to URL where > >> I > >> pass in the parameters of the current report to the copy and I specify to > >> render it as Excel. You now end up with the data they were just looking > >> at > >> but in a format that is better for Excel (no merged cells). > >> > >> > >> -- > >> Bruce Loehle-Conger > >> MVP SQL Server Reporting Services > >> > >> "Becker" <Becker@discussions.microsoft.com> wrote in message > >> news:B98EB1E3-E200-4ED0-8C90-A7A9B642BF5C@microsoft.com... > >> >I see how I can sort data in a table or list, but how do I make it so > >> >users > >> > can simply click the column header to sort? Is this functionality not > >> > available? > >> > > >> > I have tried exporting to excel and find that my columns are merged > >> > together > >> > for the table and I get an error when I try to sort in Excel. > >> > > >> > Seems pretty handicapped to me, am I missing something? > >> > > >> > >> > >> > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |