ecoppen

Thanks! I didn't even consider that the account that runs the report would affect the output. Running the report through my personal account within command reporter instantly gave me the correct output. I will ask my IT guys to take a look at the permissions of the 'automated' account to get that working as expected. That's saved me a headache.

Hi all, I've created a report that works when it's run manually (quite quickly) however when executed by command reporter it produces (quite slowly) a count field/column instead of fields selected via subfilter. The report itself is trying to pull target grades which I'll process later by checking whether the Year field matches the 'End of Y#' for a particular subject. The output should have the columns '"UPN","Year","Basic details","Result","Resultset name"' however ends up with '"UPN", "Year", "Count"'. I've tried passing the subfilter via a PARAMFILE however this didn't seem to make a difference - would this even be necessary? The fields are: UPN Year Group Assessment Results (filtered) - resultset name contains "End of Y" - Aspect name - Result - Resultset name Does anyone have any experience of the slowdown or subreport not triggering via command line? If so, I'd be grateful to know how it can be resolved.