Concatenate 3 fields for pdf report

[canmarroig]

Hi, i'm wondering how can be possibile :

i need to cycle my report on a dimension made by a concatenation of 3 different fields made in my script like this:

EMPLOYEE&'-'&DEPT&'-'&YEAR as AGGR_PDF

Results of a selection made by my concatenated field aren't the same results selecting every single field.

[#2]

What about making a text object repeat on every page (that contains the office name)? Sorry for all of the questions today!

[Nicole-Smith]

If in your text object you put =[Your Office Name Field], it should work the same way with the banding on the page.