hello,
I want to show an URL link (as a calculated field URL : cat_name&report_name&datereport & '<URL>http://myserver/id='&idreportnumber), based on the latest date of contribution.
I have severals tables. Category_reporting link to name_of reporting
name_of_reporting link to datereporting_table
Ex:
Categ_table:
Cat_name, id_categ
MARKET_RISK, 1
CREDIT_RISK, 2
OPERATIONAL_RISK, 3
Name_reporting Table:
Report_name, id_cat, id_name
BaseMetals market, 1, 1
Oil Market, 1, 2
OilCredit, 2, 3
Date_contribution table
datereport, id_name, idreportnumber
15/6/2011, 1, 1
16/6/2011, 1, 2
17/6/2011, 1, 3
10/6/2011, 2, 4
14/6/2011, 2, 5
16/6/2011, 3, 6
18/6/2011, 3, 7
i would like to do a pivot table showing only the latest report, with url link, ie:
MARKET RISK
BaseMetals Market 17/6/2011 URL=cat_name&report_name&datereport & '<URL>http://myserver/id='&idreportnumber
oilmarket 14/6/2011 URL = ....
CREDIT RISK
oilcredit 18/6/2011 URL = .....
Please find in attach file the example that i have tried to do, but doesn't work ....
Tkh you for your help
