Sales Cr. Memo subtraction in RTC rep.

wilk_u

Hi,
I have a problem with subtraction on lines. In Cr. Memo we have to sets of lines, before and after correction, sum of before lines is A and sum of after lines is B where A > B. So in total line there should be -value. I can't get this proper value, I tried sum, but it sums too high, I think it starts form zero and adds after lines. In dataset results are correct, I just cant display it properly. Have any of You faced this before?

mohana_cse06

Can you show your rdlc data and dataset result?

Did you try by placing the dataset value which has right value in report?

wilk_u

Yes, I've tried to put calculated value, calculated correctly in C/AL. As You can seen on screenshots.
I can't display the proper value of -4012,5. With sum it displays 8025, without just nothing.

Troubles_In_Paradise

wilk_u wrote:

Yes, I've tried to put calculated value, calculated correctly in C/AL. As You can seen on screenshots.
I can't display the proper value of -4012,5. With sum it displays 8025, without just nothing.

Have you tried to set properly the value of the property "Format" of this field?

mohana_cse06

Add the field in body section and check whether you can be able to show or not..

wilk_u

mohana_cse06 wrote:

Add the field in body section and check whether you can be able to show or not..

I don't get it.. Won't display anything without sum and incorrectly -8025 with sum, like in table footer.

I've tried format with expression of Subtotal.Value. Didn't help.

mohana_cse06

I mean to add the subtotal field in body section of the rdlc report and try (you are printing in footer now)

wilk_u

No, it's a body section of the report and footer of the table, but overall it's body section.

mohana_cse06

wilk_u wrote:

No, it's a body section of the report and footer of the table, but overall it's body section.

I know it..

wilk_u

So as I said it displays exactly the same in the table and field. I'm running out of ideas on this. Putting Sum(a) - sum(b) gives the same result..

mohana_cse06

Just wanted to check that whether the subtotal is printing in body section of the table or not as it is printing in dataset..

wilk_u

mohana_cse06 wrote:

Just wanted to check that whether the subtotal is printing in body section of the table or not as it is printing in dataset..

It's not. And with sum it's incorrect.

mohana_cse06

Are the other line details printing correctly?

wilk_u

Yes, amounts in lines etc. Just can't get the proper display of SubTotal, even with a-b. It seems I've tried everything

mohana_cse06

Its strange and difficult to guess as we didnt have exact report..

the problem may be we have somany different lines so try by putting grouping in the table and try..

wilk_u

I made workaround by dividing the sum by value of that how many lines i have.. It seems like not a very proper solution but it works..

I have a request, can somebody clarify to me a concept of grouping?

I would like to do sth like that:

header names etc
other header ("before correction")
body
lines before
"after correction", how to make it appear just once?
lines after
footer
(..)

now i use two tables in body.
Thank You

wilk_u

anybody?


Experience maybe on similar case? I'll appreciate any help..