Table within a table and use data from master table

chillertje

I have a very annoying problem.

I have 2 datasets. One data sets query's all my servers, and the other dataset query's events for those servers.

so i make a table en put the servernames in the detailrow. That works. But now i need for each server, the events for that server.

then i create another detailrow, en put the dataset events in it. But how can i tell that i need to see only the servers for that row?

example rapport:
server 01:
Diskfull at 19:00 PM
reboot at 19:10 PM

server 02:
Shutdown at 23:00 PM

mwilliams

Hi chillertje,

You could either filter the inner table based on the servername value in the outer table or you could use a dataset parameter in the query for the server info and set the dataSet parameter binding to the server name from the outer table using the binding tab of the property editor. Let me know if you have questions.