Error with Custom Reports SSRS

Hello,

We wanted to make a custom report for customer statements looks fine however we get the cannot create a row of size 9180 which is greater than the allowable maximum row size of 8060 how do i get around this ?

If you’ve added tables to your RDD, I think your best bet is to try excluding as many columns as you can (in any tables you added as well as the “original” tables)… Basically try to get the dataset created by the RDD as lean as you can get it.