SSRS Report Does not print preview or print

Kinetic ERP
,
1

I cannot print preview or print a report off the Quote Entry module. It is a custom report. The standard report works fine. I get the following error when I try to print:

“Program Ice.Services.Lib.RunTask when executing task 4079258 raised an unexpected exception with the following message: RunTask:
Ice.Core.SsrsReporting.SsrsCaller.SsrsException: The SSRS server returned the status code 500 (InternalServerError) with the following error text:
The Value expression for the field ‘Calc_HasMisc’ contains an error: Input string was not in a correct format. —> Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The Value expression for the field ‘Calc_HasMisc’ contains an error: Input string was not in a correct format.”

I have identified the field causing this issue and instead of returning a True/False value, it is returning a string. I checked the RDD and the field is set up as a logical Yes/No field there. I don’t see any error in the dataset either. How can I get this field to behave properly and return a boolean instead of a string ?

2

This is where I’m assuming the stock Quote Form is using it… to toggle the visibility of the Line Misc. Charges subreport.

image
image935×567 42.1 KB

Not sure how you modified your custom report, so really can’t help much. Did you modify this visibility expression at all?

3

Hi David,

No we did not modify this visibility expression at all. It is the same as the standard report. The Calc_HasMisc field returns the string “Calc_HasMisc” instead of True/False in our custom report though which is generating this error message. I have no idea why this field is behaving this way. Nothing in the RDD or the data set should make it return a string.

1 Like