I am sure there is a more elegant way of doing this, and without seeing your code this is just a bit of an assumption.

However it would seem...

I am sure there would be a way to achieve what you are asking, however sometimes it might be easier to change your source and then it will make the...

How is CopayType being populated?
Is it possible to split this into the separate fields that the column group is dynamically creating?  Then you could use a Tablix and then...

Sorry just managed to enlarge your screenshot. 

I don't know if I fully understand, however shouldn't it just be dividing the column 1 Req over 2 Count to...

Could you not use inline if function?
Something like
=iif(ReportItems!CopayType.Value="1 Req", ReportItems!CopayValue.Value,0 or something else)iif(/ReportItems!CopayType = "2 Count", ReportItems!CopayValue.Value,0 or something else)
I am not sure what you would put...

To get the percent calculation, you need to divide the correct report items value for the fields that you want to calculate for example.

For the sub total line,...

Ok try the same as I said before but this time right click on the Username grouping.

If you right click on the group name in your case 'Specialty' you should find an 'Add Total' option.  You can then choose either before or after each group split.

In case anyone else does have this issue.

The next thing we tried after finding a thread about this on another forum was to flush the DNS cache.  This...

I am having similar issues.  Has anyone found a solid solution to this.  Currently I am changing the provider to SQLOLEDB.1 and testing this.

It is happening across a...

You could try PowerApps.
https://powerapps.microsoft.com/en-us/
Very quick and easy...

If you have VM's.  This software is very good.  Whilst it takes an image of the server it still allows for object level recovery.

Fairly cost effective as well.

Are these physical servers or VMs?
Thanks
Mark

You can use BIT fields and then set the default value to 0 in SQL.  This gets around the issue I have experienced in the past.

Thanks

What are the fields in the table?  Is there a bit (Yes/No field for Access) field?