Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
volyn
Starting Member
30 Posts |
 Posted - 2010-03-27 : 09:58:24
|
| Hello there,I have created dataset from big table of orders. Point of the report is to show report user orders of all clients between two dates (two parameters).In the report is name of client (country in which he bought our goods - one client could buy goods in both countries), pcs of goods ordered, value of goods he ordered. Data in rows are grouped by Client name and country. There is set descending sorting on table on order value. When I want to set interactive sorting on any table header value, its simply not working. I can click to any i-sorting sign in rendered report, but it is not sorting anything.Could you help please?Thanks for any help |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-03-27 : 11:08:49
|
| what have you set as interactive sorting option for each field?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
volyn
Starting Member
30 Posts |
Posted - 2010-03-27 : 19:27:45
|
| I made now as simple as possible. I have table with columns Factory_code, Pcs_ordered, Order_value. Rows are grouped by Factory_code value and other two columns are summarized. Table has sort value set on SUM(Order_value) DESC.I want to let sort user also on column Pcs_ordered. I dont know how to do that. I am trying to set in interactive sorting tab for textbox in table header Pcs_Ordered. Sort Expression is set to =SUM(Pcs_Ordered.Value),"data region to sort" is set to TABLE and "Evaluate sort expression in this scope" is set to TABLE too.Nothing is changening, when i click on it in rendered report. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-03-28 : 02:39:56
|
| your field Pcs_Ordered contains the required value rite? then you should be using Pcs_Ordered.value rather than sum in interactive sorting. While report renders, click on sort icon on column header for Pcs_Ordered and then you should see results sorted based on it------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Interactive sorting problem of grouped table