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 |
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
 Posted - 2009-05-07 : 13:01:03
|
| Greetings,I am creating a report form, rdl, using Visual Studio. I have tried all kinds of datasets and they work fine order the data result properly when I click on the run button ! But on previewing the data it does not look anything like the result set in the dataset. Is there anywhere in the layout I need to specify so it keeps that sort order.Also how do I keep everything together in the report, right now I haev one page per row?Thanks!!!!!<><><><><><><><><><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
|
|
IBoonZ
Yak Posting Veteran
53 Posts |
Posted - 2009-05-08 : 04:52:18
|
| try using a list box --> properties and the sort by the attribute you want. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-05-08 : 13:07:47
|
quote:
Originally posted by yosiasz
Greetings,I am creating a report form, rdl, using Visual Studio. I have tried all kinds of datasets and they work fine order the data result properly when I click on the run button ! But on previewing the data it does not look anything like the result set in the dataset. Is there anywhere in the layout I need to specify so it keeps that sort order.Also how do I keep everything together in the report, right now I haev one page per row?Thanks!!!!!<><><><><><><><><><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion
you need to apply sorting based on field you want in container (table,matrix,..) where you show data. Also check whether you've set insert pagebreak property in your data rows, this might cause data to break into different pages. |
|
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2009-05-08 : 13:27:18
|
| thanks y'all. Got it! now another question. I am used both a list and a matrix. IS there a way to make things collapsable. The report is huge so for example I want to collapse it by Branch and then commodity such as aluminim, Boonzinium and Visakium<><><><><><><><><><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-05-08 : 13:56:44
|
| you can. there's a property called toggle visibility based on another report item. just set it for low level groups based on top level row. |
|
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2009-05-08 : 16:04:53
|
| ok so far so good. I have a table in a list. table has 5 columns.Column 1 : CommodityColumn 2 : DescriptionColumn 3 : Week DayColumn 4 : DateColumn 5 : ValueI want to be able to collapse the whole table by commodity. That is when user opens report I want to show starting collapsed by Commodity. Should commodity not be part of table?Merci<><><><><><><><><><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-05-09 : 04:52:48
|
| yup. it should be part of table, but at a higher level row. then show other details in next row and toggle their visibility based on upper row. |
|
|
|
|
|
|
|
|
Sort in my report