When trying to print our Ship ticket,m we get the following error:
Cannot read the next data row for the dataset OrderHed. —> System.Data.SqlClient.SqlException: Cannot create a row of size 13778 which is greater than the allowable maximum row size of 8060.
Are you printing out the base SSRS report?
It is a custom form. I have went into developer mode and selected base, and still gives same error.
Are you using a custom report data definition too?
Yes
What did you add to the data definition?
Several fields, but this is the same we had in our old system for years. Nothing recent except for ResDelivery recently.
What was your old system?
You should get rid of any fields you don’t use in your linked tables. This goes for the labels as well. Include only the labels and columns you need.
10.1.400.37, currently in 10.2.300.8. System would be wrong word. Sorry about that.
I think you are running into a sql server limitation on bytes per row. Maybe someone more technical can help me out?? I would say try to exclude any columns and fields that are not necessary and start there.
I have excluded 5 columns and labels. and nothing has changed. Will keep excluding and hopefully it works.
Remember that there is an Exclude all option when you have a table selected and then you can go back through the fields and unmark only ones you want. Try it in your test environment of course. I just don’t get why it would have changed from one version to the next.
I added into the SSRS Query the ResDelivery from OrderHed last week. I am wondering if that may have something to do with it.
As a pick link?
No, I added it to the query, and then, in SSRS said If ResDelivery is true, say Residential Delivery Address, otherwise nothing.
Okay, so I would start with that table. Select it in the report data definition and exclude all labels and columns and include only the ones you want.
I have no idea how to fix it, But I think you and @Kimberley are having the same problem, even if it’s different forms.