How to make a Report with dynamic Header in Report Builder

(1) Share

Report

Posted on by Community Member

Hello everyone,

i am new in Dynamic NAV. I have a Header and Body for my Report. I want to have a Dynamic Header. That means for each Header, i have Data for a Body.

Let say in the Header i have No.=100 and in the Body, the Data for 100 is display. For No.=101, the Data for 101 is display in Body.

How can i configure it in Report Builder? So how can i make the Header dynamic?

Thanks

Pierre

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (7)

Verified answer

Community Member on at

Like (1)

Report

Hello allipierre,

Standard Dynamics NAV do this if you select range of documents in the request page like this:

You can see any invoice or order in development enviroment (report 205,206,207, ...).

The Header and Body is updated on each record.

If are you attempting to do a report from scratch, I recommend you to use Code.GetData in header textboxes, with this function the values will be updated each time that the header dataitem takes another record.

You have more information about GetData and SetData here:

http://navnilesh.blogspot.com.es/2015/01/rdlc-report-getdata-and-setdata.html

I hope this will help you.

Was this reply helpful? Yes No
Verified answer

Marcellus 2,735 on at

Like (0)

Report

Hi Pierre,

Check this video: How Do I Use SetData and GetData in Microsoft Dynamics NAV 2013 R2

Was this reply helpful? Yes No
Verified answer

Tina Menezes 2,582 on at

Like (0)

Report

Hi,

You need to use SetData and GetData in reports along with Code.GetData(Value Index, Group Index). After defining all your Code.SetData with all the fields in your hidden textbox you can get the value index for each and you need to start counting from 1. You can refer the below link which gives steps in detail.

http://navnilesh.blogspot.in/2015/01/rdlc-report-getdata-and-setdata.html

In the above link the value index is 82 means you have defined your field value in the hidden textbox at the 82nd line.

Was this reply helpful? Yes No
Verified answer

Amol Salvi 18,698 on at

Like (0)

Report

Check standard report like 205,206. You will get more idea.

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Hey Martin,

Thanks to Answers me. i have do that. The header works fine now. I put the hidden textbox in a the List in Body. Now i have a Issue with the Body.

The Body don't display Data for the Header. For Example, there is a No. in Header. when this No. ist 100, i want to display only

The Data for this 100 in Body. I have make a Row group for the List with the Field of this No.(100). Maybe i make the Body Wrong?

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

Hi allipierre,

If are you doing a report like an invoice, order... the Row Group should be like this:

Group on: Sales Header Document Type

And on: Sales Header No

IMPORTANT: This groups are not in the details_group.

This will group the lines by Type of Document (Purchase, Sale..)

And By Document No.

If first Document No. is := 100

Records will show the information from Document No. 100

When the report finish reading lines, will take the next document No. := 101

And records will show the information from Document No. 101

I hope this will help you,

Ask everything you want :)

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

Hey Martin,

Thanks for Quickly Answers and for the Help. I have made that, but it repeat the Table in one Page, i font know why.

Below is a Image about the Output. in Some Page there are Tables duplicate and another Page , there are Empty. I show you empty table, because all Information are privat for the Company.

Thank for help

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

Hi,

Did you changed the DataItemLink Property, on Lines dataitem?

You have to link the field of lines table which have the No. of the Document Header, to the Document Header No. field

If you know about SQL: DataItemLink concept is like an inner join +-

I'm not sure if you were asking about this.

Try this and let us know,

I hope this will help you

Was this reply helpful? Yes No