Not Visible Amount in RTC Report

wilk_u

Hi,
my problem is that I have a variable TotalAmount which adds sales line amount onaftergetrecord of salesline, totalAmount is visible in classic, value correct, but in rtc the field is just blank, not 0 even. I thought that can be the problem of field size, i made it larger, font size is 10, but still i cant get the value in it. Any ideas what can be the problem?
Thanks.

mohana_cse06

Check the value in Dataset (About this report.)

wilk_u

Maybe silly question, but how?
Fields is in dataset, it can be used in expr., but how to heck value there?

Jatin_Patel

On the Report Page Top Right Corner Help Button is there.
On this button press About This Report (Ctrl+Alt+F1).

wilk_u

I see. Thank You.
Value is there and it's correct but still can't make it appear on report

mohana_cse06

is it in all rows or at last row?

wilk_u

last row, body table footer. its one of totals

mohana_cse06

you have used SUM()? try by Last()

wilk_u

Ha.. works with sum() . Thanks mate what does it do? Are the values stored separately and sum? Would think its already a sum when adding is coded every record getter.

mohana_cse06

If we need the sum we have to use Sum()..

AndyIndia

Hi Experts,

I have developed a reports in Classics and have used create layout suggestion option to convert it into rtc report.

Everything is getting printed fine in rtc reports except the section marked in red in the body section of the report.

Kindly help.

Thanks....

mohana_cse06

Check the dataset result also..

AndyIndia

Hi Mohana,

What should i check in data set result. I have checked the visibility property of each field.

At least caption should be visible.

Please Help.

mohana_cse06

Can you show your dataset result to us with fields visible which are not showing in report preview..

AndyIndia

HI Mohana,

I have added the 2 images of my dataset result.

mohana_cse06

Read first 4 replies of this post and check.. ](*,) ](*,)

AndyIndia

Sorry for not understanding what u required.

I have attached the dataset result Image.

mohana_cse06

Look at the first line..its blank..so dont use FIRST()

AndyIndia

Yepppppppyyyyyyyy Solved.

Have used last instead of first.

AndyIndia

Thanks a lot Mohana....

mohana_cse06

AndyIndia wrote:

Thanks a lot Mohana....

Welcome