hello,
New to Crystal reports:
I have a table called 'Server' with two fields, 'ServerID' and 'hotfix'. This table contains hotfixes found on a machine. A machine may have multiple hotfixes.
I am trying to report on machines that do NOT have a selected range of hotfixes:
Format required:
Machine X
Missing 'y' hotfix
Missing 'z' hotfix
Etc...
How can this be done?
My idea was to concatenate all 'hotfix' records per server into a single string and use the IN statement to find those machines which match and disregard (the 'NOT IN' does not work for me!). Any ideas would be grateful...
Regards,
Hamen
Hamen_Patel@aimfunds.com
New to Crystal reports:
I have a table called 'Server' with two fields, 'ServerID' and 'hotfix'. This table contains hotfixes found on a machine. A machine may have multiple hotfixes.
I am trying to report on machines that do NOT have a selected range of hotfixes:
Format required:
Machine X
Missing 'y' hotfix
Missing 'z' hotfix
Etc...
How can this be done?
My idea was to concatenate all 'hotfix' records per server into a single string and use the IN statement to find those machines which match and disregard (the 'NOT IN' does not work for me!). Any ideas would be grateful...
Regards,
Hamen
Hamen_Patel@aimfunds.com