SSRS Report with BAQ and Relationship

Kinetic ERP
1

Good Day all,

I am rather stumped on this one. I :
Created A Data Definition with 2 BAQ’s and 1 relationship between them ( see Screen clip) .
Created a Report Style using this Data Definition
Created SSRS Report from Actions menu
Downloaded SSRS report ( we are Cloud folk, please don’t hold that against me…)
Made simple Table report and got Error Below. Have since recreated all above steps and left report blank
Uploaded SSRS Report.
Ran SSRS report ( Added to Menu.)

This is the error I got from System Monitor. Note I have not included complete error, rather dry reading and I suspect that the part about The scale (7) for column ‘JobHead_ProdQty’ must be within the range 0 to 6. is the culprit… I can include the full message if requested.

Program Ice.Services.Lib.RunTask raised an unexpected exception with the following message: RunTask:
System.Data.SqlClient.SqlException (0x80131904): The scale (7) for column ‘JobHead_ProdQty’ must be within the range 0 to 6.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

image
image757×499 42.8 KB

image
image861×587 54.4 KB

Am I missing something ??

I did play around with the BAQ for the job list changing the Column display format. The error will change regarding the Scale as I change the length of the Format…

image
image1025×563 69.1 KB

THanks

Dean

2

The scale refers to the number of digits to the right of the decimal point.

JobHead.ProdQty should be a decimal, so try and format it in your BAQ with 2 or 3 decimal places - it appears to be formatted as an integer.

3

Arrggg, I get the dork of the day award. I usually delete the decimal places on BAQ’s for dashboards because we make 1 or 2 or 50 of items. Not decimal places…