how to group for a nested gird

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

RBarryYoung SSC Guru Points: 143329 More actions · Answer 1

Um, what are you actually trying to do? Maybe a small example of what results you want.

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

Patrick.I Hall of Fame Points: 3105 More actions · Answer 2

rbarryyoung (11/12/2008)
Um, what are you actually trying to do? Maybe a small example of what results you want.

What i want is to have a nested grid.

The master grid should have :

STATE AREAS

TEXAS TEXAS- Area 1

then the child grid :

REGION DESKTOPS

------- ----------

PARIS -TEXAS 12

So when you click on a plus sign of the first grid you get child grid

my problem is if i do this:

select * from table where where state = 'TEXAS'

i get something like this:

STATE AREA

------- ---------

TEXAS TEXAS- Area 1

TEXAS TEXAS- Area 2

To display the child grid i pass the area as a parameter but since the areas are duplicate i get back each duplicate record in my child view