[sims] Report Output repeating itself

[ChrisH]

I am trying to extract a load of general information including comments from behaviour incidents, exclusions and Achievement/Behaviour. The only trouble I have now is that the output repeats the exclusions over and over eg there should be 6 unique entries but it keeps repeating them all the way down the page (outputting to excel). The other fields, including behaviour comments seem okay and unique. You only seem to get the "Include Records with No such..." and "display first record only" to use. Is there a particular combination of the other filters to get this to behave?

 

[bfelton]

If you include multiple subreports the lower ones will repeat for each instance of the higher ones.

[ChrisH]

So no way round it? I will have to run each one separately?

[bfelton]

You could potentially include the 3rd party reporting ID for each subreport entry and condense them in excel? not sure how but could be possible...

[ChrisH]

I can remove duplicates in Excel as I do lots of processing for all my reports in VBA but I was just looking to start as "clean" as possible. I'm surprised I haven't run into this issue before

[bfelton]

I have been generating a lot of subreport reports recently when exporting data to PowerBI, I ended up creating separate reports and linking them through admission numbers to get a neater collection of data.

[matt40k]

You've got PowerQuery in Excel, which is the same as in PowerBI (just older version in Excel). No more VBA