Issue with multiply selected reports

Hornsyld

Hi,

Working on a report where some fields have a 'Eksternal Doc No.'

If i select 3 reports where 1 of them got a 'Eksternal Doc No' and the 2 others have empty fields and press print.

The report will make a pdf with all 3 reports included, but will write the eksternal doc no on all of them even trough they dont have a eksternal doc no.

=First(Fields!EksternalDocumentNo_SalesInvoiceHeader.Value, "DataSet_Result")

I know this takes the first, so ofc this is the problem, but how do you do it the right way?

postsaurav

Hi,

Its seems to be a custom Report and the Field seems to be a part of Page Header in Design and have expression as you specified insted of Code.GetData() .

Refer to the standard Report how Field on Header get value from Body. Its actually get First of the Record if the Report is designed correctly.

postsaurav

Hi,

Its seems to be a custom Report and the Field seems to be a part of Page Header in Design and have expression as you specified insted of Code.GetData() .

Refer to the standard Report how Field on Header get value from Body. Its actually get First of the Record if the Report is designed correctly.

Hornsyld

Hi Postsaurav,

That is correct - its a custom report and a part of the Page header.

So you are saying that the right way is to use Code.GetData() ?
In that case - How do find out which dataset and a position i have to use to get the EksternalDocumentNo_SalesInvoiceHeader?

Hornsyld

I found a good video for this.
https://www.youtube.com/watch?v=dievcKyhoWU
Thanks for the help.