Hi,
I got the needing to show the result of the difference between two date-time fields.
I can't add columns to table so I would like to have this calculated field only in my report side.

Shortly, How can I add a new calculated field on a report ?


This is the select who made the right calculation.
SELECT CONVERT(VARCHAR,([FASE2].[DataOra]-[FASE1].[DataOra]),108) As Difference
FROM [dbo].[FASE2], [dbo].[FASE1]
WHERE [FASE2].[IdFa2] = [FASE1].[IdFa1]

I've tried to add a new model and insert the above select but I can't see any new field "Difference"

Thanks

Hello. Is not possible to use the power of Razor engine to create calculated fields?

Hello. We're playing with the Post Load Script in order to manipulate the datatable. Here is the code. Razor is OK but we when we execute the report, a message says that the specified conversion is not valid. I guess that the base cell is an object. How can we get it? Thanks


...Ok...The problem is due to when trying to assign value to null cells. I'm looking for the type to initialize null cells, something similar to:
table.Rows[row][1] = new CellValue(intValue);

Thanks.

@using Seal.Model
@using System.Data
@{
ReportModel model = Model;
DataTable table = model.ResultTable;
ReportExecutionLog log = model.Report;

//Script executed to modify the model result table after it has been loaded from the database
//Modify values in the current result table, rows can also be added and deleted.
//Note that other assemblies can be used by saving the .dll in the Repository 'Assemblies' sub-folder...
log.LogMessage("Modifying table with the model 'Post Load Script'...");

for (int row = 1; row < table.Rows.Count; row++)
{

table.Rows[row][1] = (int)table.Rows[row][1] + (int)table.Rows[row-1][1];
table.Rows[row][2] = (int)table.Rows[row][2] + (int)table.Rows[row-1][2];
table.Rows[row][3] = (float)((int)table.Rows[row][1] - (int)table.Rows[row][2])/(int)table.Rows[row][1];

}

}

Edited by user Monday, May 20, 2019 9:49:02 PM(UTC)  | Reason: Not specified

Thanks epf!.
DataTable cells doesn't have a property nor method called "Value". I think you're refering to ResultTable, but is not my case as in the PostSQL script the table I need to modify is the DataTable.
However, I've found the problem. I was using if (cell == null)...and is not correct. The right method is if(Convert.IsDBNull(cell))....So solved!

Edited by user Thursday, June 6, 2019 11:51:58 AM(UTC)  | Reason: Solved past issue but a new one now.

Thanks epf.
As you recommended, I've CAST to Decimal from the Select and now is working. The problem came from the conversion types that the SQL connector does. Specifically, Real types are converted to single. That's the problem.

Thanks.

Edited by user Thursday, June 6, 2019 11:53:52 AM(UTC)  | Reason: Not specified