When I create a report with multiple UnDP status entries I get a separate report line for each entry. For example I have an inventory report that shows Server Name, Server IP and Server Model # (Model # is collected by a UnDP) this report is fine as when you run it you get one line of information for each server. If I try and add info from another UnDP (like server serial number I now get two lines for each server in the report with one line showing the model # and another showing the serial #. Haven't found a way around this via the Report Writer GUI is there some way to manually manipulate the SQL to get the output I want ?
Show me your report build out as it is to show all the data, even if on separate lines.
- also you can show SQL, copy and paste that here, as SQL should be more capable in doing what you need here.