How to display or hide field labels and values at run time

[Zorron]

I use Crystal Reports 8.0.
I have a table called Musicplayer in SQL Server2000.
In a dataset ds I fetch all the following values:

Musicplayer
_______

Type 1 2
cassette_playlength 55
cassette_playbackpos 5.2
cassette_OptionName1 Cassette1
cassette_OptionName2 Cassette2
dvd_playlength 86
dvd_OptionID dvd_player1
dvd_OptionID2 dvd_player2


So when the report is generated, the values of only the related Musicplayer type should be displayed. For eg: If I generate a report which has one cassette and one dvd type, then the report should look like

1 Cassette Play Length : 55
Cassette Play Back Position: 5.2
Cassette Option Name 1 : Cassette1
Cassette OptionName2 : Cassette2
_____________________________________________

2 DVD Play Length : 86
DVD Option1 : dvd_player1
DVD Option2 : dvd_player2

_____________________________________________

Any help is extremely appreciated.

Many Thanks in advance.

Ron

[V361]

Have you tried creating a group... Group on music player type, Not sure if that is what you are looking for or not...