How to display first value of table records in page header?

(0) Share

Report

Posted on by Community Member

I have an issue that is i want to display a first record value in page header, don't understand let me explain

i designed a table in RDLC it nav 2013 R2 ,here is detailed row is there and take a item list for example k.

in my report fields are Item No.,Name,Qty only three fields and also i added a Textbox in Page Header In this textbox i want to display Every page First Qty Value Is this possible?

when i run my report i got 4 pages in every page header is repeated fine but every page last value is displayed in my header textbox but i want first record ?

please give me suggestion

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (1)

Community Member on at

Like (0)

Report
Copy link

Link copied!

See above attachments Here Header value is Page last value but i want to print First value of every page for that i taken hidden value of First(Fields!Qty.value) and i delclared in as ReportItems!Qty.value then also i got same output how to achieve this one

Was this reply helpful? Yes No
Verified answer

Suresh Kulla 50,269 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

What is printed if you just say Fields!Qty.Value instead of First(Fields!Qty.Value)

Anyhow Try this expression in the textbox, replace TextBox Name with the actual textbox name where the quantity is displayed

=First(ReportItems("Textbox Name").Value)

Was this reply helpful? Yes No