Master-detail on the same dataset

Hot Topic

Fuzzy Grouping: Any success with > 3 million records?
Unable to install SQL Server 2005 Standard
Synchronize two databases - Looking for concepts and theory
After Install of 2005 still 2000 Engine!
Sum with null values
2000/2005 Mixed Replication
Windows Mobile 5 connecting to SQL Server 2005
Getting error 0x80010112 while executing stored package
Wishlist: MOST WANTED Tasks, Sources, Transformations, and Destinations?
Anyone else finding this painful?

SQL Server

Move data from backroom to frontroom
Use View to speed up?
SQL Server Profiler and connection.Open
link to SQL Server Express from Access 2000
Accessing System Tables (books online)
how can i connect to sqlserver2005 express by ado
Parameterized MDX queries using AdomdParameter
what is the meaning of "64(error not found)" in sys.transmission_queue
The Cubes collection has been updated on the server - error
Non-Default SQL Server Port

Master-detail on the same dataset

Hello,
I have a dataset (web service) which profide the following data:

ProdID ProductName ItemID ItemName
12 ABC AF Item1
12 ABC AE Item2
13 DEF AF Item1
13 DEF AN Item3

I would see the table rendered as

12 ABC
AF Item1
AE Item2
13 DEF
AF Item1
AN Item3

I tryied setting groups but I don't see the correct data (just the first record)

Any help

Thanks,
Pierre




Answer this question

Master-detail on the same dataset

  • chaospixel

    Hello Ayzan,
    not really clear what you mean.

    I have a table with one header and two rows. In the first row I have ProductID and ProductName. In the second row I have ItemID and ItemName.

    Where should I set the group info

    Thanks,
    Pierre



  • MarketFare

    OK, I found it. I set the group info on the wrong row. Thanks for the help.

    Pierre



  • Keith Koh

    Salut Pierre,

    Try to add ProdID and ProducName, in the "Group on" options of your list

    Regards

    Ayzan
  • Master-detail on the same dataset
Answer this question