Modify a report

sharon95

Hi! I have to modify a report... My aim is to visualize the grand total (sales invoices - sales credit memos)... In the last two pages of the report there is the sum of the invoices (one one page) and the sum of the credit memos (on the last page). How can I do that? thanks!

sharon95

SOLVED

RockWithNAV

You can use footer in the report for the grand total, and for totaling in each and every page you need to implement Transheader and Transfooter

sharon95

My aim is to do the difference between two expressions in two different textboxes in the report on visual studio. The two expressions are:

=Sum(IIF(Fields!DocTypeG.Value = "FT", cdbl(Fields!Amount_SalesInvoiceLine.Value), 0))
and
=Sum(IIF(Fields!DocTypeG.Value = "NC", cdbl(Fields!Amount_SalesInvoiceLine.Value), 0))

How can I subtract the first (invoices) and the second (credit memos)? Thank you!

sharon95

sharon95 wrote: »

My aim is to do the difference between two expressions in two different textboxes in the report on visual studio. The two expressions are:

=Sum(IIF(Fields!DocTypeG.Value = "FT", cdbl(Fields!Amount_SalesInvoiceLine.Value), 0))
and
=Sum(IIF(Fields!DocTypeG.Value = "NC", cdbl(Fields!Amount_SalesInvoiceLine.Value), 0))

How can I subtract the first (invoices) and the second (credit memos)? Thank you!

I saw that if I copy the first expression into another textbox, the result is zero, while if I copy the second expression I obtain the same value of the original expression... why? Thanks!

kriki

[Topic moved from 'NAV/Navision Classic Client' forum to 'NAV Three Tier' forum]

sharon95

SOLVED