What's now the best way to add a grand total column at the end of the cross tab?

Sorry!!

A bit of a beginners fault :blush: .... the field "kstplcode" in the @columns variable was not the same as the field "oms25_0" in the data-query! :doze:

Thanks for your help,...

There is a comma! As far as I know the syntax is correct for the columns variable. Or not?

Sorry, I omitted a remark at the end of the line, but I left one minus-sign there. My fault! My original query is correct and does not have this minus-sign.

I'm...

... oeps, I forgot to mention that the RunningValue has to be converted to double as well.

So:

=RunningValue(Cbl(Fields!SumQty.Value, sum, "EmployeeNumber")

That's all folks!

Hi

Using ReportItems didn't work.

I solved it another way:

- I created a new calculated field in the dataset (right click in dataset) with the exact expression that I used in my...

Thanks Varun.

Problem is that the application inserts dates with YYYY-DD-MM, but somehow in SQL Server it is converted to YYYY-MM-DD.

Hoep you have another clue.

reg,

Michiel