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 |
|
bh0526
Yak Posting Veteran
71 Posts |
 Posted - 2011-12-09 : 12:22:19
|
| I have a simple report that looks like this:Item# Item Name Order# Qty123 Item 123 1 15234 Item 234 2 9987 Item 987 3 24I have a group defined for Item#. There can be more than one Orders per Item#. I want to display just the Item# and Item Name when the report is first displayed. I also want to have a "+" sign next to each Item# and when clicked, shows the multiple Order# and Qty rows.How do I do this?Bob |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-10 : 08:08:29
|
| you need to apply grouping based on fields you want to show in a particular level ( Item#,Item Name in first level, Order# ,Qty in second level). then fpr second level add parent group hierarchy as first level group. FOr row visibility, set property toggle based on another item and link it to parent item.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
k_nataraj
Starting Member
7 Posts |
|
|
|
|
|
Group Expand / Collapse question