Hi all, Been a while since I've been active on the forum.
I've copied the default report "List of assets by compliance state for a configuration item in a configuration baseline." I need to add a few columns from the v_r_user view and maybe some additional computer information to the report so that it is more useful for the end-users. I've tried a few things like adding a simple JOIN to the main select statement and even editing the temp table that is created in the report but no matter what, I continue to be prompted to "Define Query Parameters". No matter what I do from this point on, either most of the fields in the data set disappear, or if I select the check boxes next to all of the fields in the "Define query parameters" dialog, click OK, then Cancel to the prompt, the report eventually errors out with: "Query execution failed for dataset 'DataSet0'. (rsErrorExecutingCommand)" Any ideas? Should it be this hard to add a column to the default reports? I feel like I'm making huge strides in reporting with 2012 but this has me stumped. -Nick-
