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.

[Nicole-Smith]

You will need to make that field in your load scripts, and then cycle the report on that field.

[canmarroig]

This is exactly what I did but I obtain different results

For instance:

1)

Concatenated fileld	sum(salary)
Brown - Sales - 2012	3.000

2) Selecting separately

Employee: Brown

Dept: Sales

Year: 2012

sum(salary) = 3.500

[#4]

Hi,

Is it posible to upload your application?

[canmarroig]

Sorry but I can't there are some reserved data

[Anonymous]

canmarroig

This documentPreparing examples for Upload - Reduction and Data Scrambling by Rob Wunderlich  may help you make it suitable for sharing.

Best Regards,     Bill

[canmarroig]

Oh, tks!!

[#8]

Do you know of a way to cycle reports on a field automatically? Say I want the same table repeated for each office or for each month. Do I need a third party tool like nPrint?

[Nicole-Smith]

On page settings on the report, you can loop whatever is on the page by a field.  So, for example, what I have pictured below will result in my report having 12 pages, one for each month number:

[#10]

You're incredible. Thank you.