The Tip (of the iceberg)

All our tips in one neat spaghetti pile

28-Mar-2024
27-Mar-2024
26-Mar-2024
25-Mar-2024
08-Mar-2024
07-Mar-2024
06-Mar-2024
05-Mar-2024
04-Mar-2024
01-Mar-2024
29-Feb-2024
28-Feb-2024
28-Feb-2024
27-Feb-2024
26-Feb-2024
18-May-2022
11-Apr-2022
07-Apr-2022
06-Apr-2022
05-Apr-2022
22-Mar-2022
21-Mar-2022
15-Mar-2022
14-Mar-2022
11-Mar-2022
10-Mar-2022
24-Feb-2022
09-Feb-2022
24-Jan-2022
21-Jan-2022
19-Jan-2022
18-Jan-2022
17-Jan-2022
24-Nov-2021
02-Nov-2021
05-Oct-2021
27-Sep-2021
23-Sep-2021
22-Sep-2021
20-Sep-2021
09-Sep-2021
07-Sep-2021
06-Sep-2021
01-Sep-2021
31-Aug-2021
28-Aug-2021
26-Aug-2021
24-Aug-2021
23-Aug-2021
20-Aug-2021
15-Aug-2021
15-Aug-2021
17-Feb-2021
11-Feb-2021
03-Feb-2021
02-Feb-2021
01-Feb-2021
29-Jan-2021
28-Jan-2021
27-Jan-2021
26-Jan-2021
25-Jan-2021
23-Nov-2020
17-Nov-2020
12-Nov-2020
11-Nov-2020
10-Nov-2020
09-Nov-2020
05-Nov-2020
06-Oct-2020
23-Sep-2020
21-Sep-2020
14-Sep-2020
08-Sep-2020
07-Sep-2020
07-Aug-2020
16-Jul-2020
15-Jul-2020
13-Jul-2020
09-Jul-2020
06-Jul-2020
30-Jun-2020
29-Jun-2020
26-Jun-2020
25-Jun-2020
24-Jun-2020
23-Jun-2020
22-Jun-2020
17-Jun-2020
16-Jun-2020
15-Jun-2020
09-Jun-2020
08-Jun-2020
04-Jun-2020
03-Jun-2020
02-Jun-2020
20-May-2020
14-May-2020
13-May-2020
12-May-2020
11-May-2020
08-May-2020
07-May-2020
06-May-2020
05-May-2020
04-May-2020
01-May-2020
30-Apr-2020
29-Apr-2020
28-Apr-2020
27-Apr-2020
04-Apr-2020
03-Apr-2020
30-Mar-2020
27-Mar-2020
26-Mar-2020
25-Mar-2020
24-Mar-2020
23-Mar-2020
20-Mar-2020
19-Mar-2020
18-Mar-2020
17-Mar-2020
06-Mar-2020
28-Feb-2020
24-Feb-2020
21-Feb-2020
20-Feb-2020
19-Feb-2020
14-Feb-2020
13-Feb-2020
12-Feb-2020
11-Feb-2020
10-Feb-2020
09-Feb-2020
18-Dec-2019
17-Dec-2019
16-Dec-2019
25-Nov-2019
22-Nov-2019
05-Nov-2019
04-Nov-2019
09-Oct-2019
08-Oct-2019
07-Oct-2019
30-Sep-2019
13-Sep-2019
12-Sep-2019
11-Sep-2019
10-Sep-2019
09-Sep-2019
06-Sep-2019
05-Sep-2019
04-Sep-2019
03-Sep-2019
02-Sep-2019
29-Aug-2019
28-Aug-2019
15-Aug-2019
14-Aug-2019
13-Aug-2019
12-Aug-2019
09-Aug-2019
08-Aug-2019
07-Aug-2019
05-Aug-2019
02-Aug-2019
01-Aug-2019
30-Jul-2019
26-Jul-2019
24-Jul-2019
22-Jul-2019
19-Jul-2019
28-Jun-2019
27-Jun-2019
26-Jun-2019
25-Jun-2019
24-Jun-2019
21-Jun-2019
21-Jun-2019
14-Jun-2019
13-Jun-2019
12-Jun-2019
05-Jun-2019
04-Jun-2019
03-Jun-2019
17-May-2019
16-May-2019
15-May-2019
14-May-2019
07-May-2019
06-May-2019
04-May-2019
03-May-2019
02-May-2019
29-Apr-2019
26-Apr-2019
25-Apr-2019
24-Apr-2019
23-Apr-2019
16-Apr-2019
15-Apr-2019
15-Apr-2019
11-Apr-2019
10-Apr-2019
09-Apr-2019
08-Apr-2019
03-Apr-2019
02-Apr-2019
01-Apr-2019
29-Mar-2019
28-Mar-2019
27-Mar-2019
26-Mar-2019
25-Mar-2019
22-Mar-2019
21-Mar-2019
20-Mar-2019
19-Mar-2019
18-Mar-2019
15-Mar-2019
14-Mar-2019
13-Mar-2019
12-Mar-2019
11-Mar-2019
08-Mar-2019
07-Mar-2019
06-Mar-2019
05-Mar-2019
04-Mar-2019
01-Mar-2019
28-Feb-2019
18-Feb-2019
15-Feb-2019
14-Feb-2019
13-Feb-2019
12-Feb-2019
11-Feb-2019
22-Jan-2019
21-Jan-2019
19-Dec-2018
18-Dec-2018
17-Dec-2018
14-Dec-2018
13-Dec-2018
12-Dec-2018
11-Dec-2018
10-Dec-2018
07-Dec-2018
06-Dec-2018
05-Dec-2018
04-Dec-2018
03-Dec-2018
30-Nov-2018
29-Nov-2018
27-Nov-2018
26-Nov-2018
22-Nov-2018
21-Nov-2018
19-Nov-2018
16-Nov-2018
14-Nov-2018
14-Nov-2018
13-Nov-2018
12-Nov-2018
09-Nov-2018
08-Nov-2018
07-Nov-2018
06-Nov-2018
05-Nov-2018
01-Nov-2018
31-Oct-2018
30-Oct-2018
22-Oct-2018
16-Oct-2018
15-Oct-2018
12-Oct-2018
12-Oct-2018
11-Oct-2018
10-Oct-2018
09-Oct-2018
08-Oct-2018
08-Oct-2018
14-Sep-2018
12-Sep-2018
11-Sep-2018
10-Sep-2018
07-Sep-2018
06-Sep-2018
05-Sep-2018
04-Sep-2018
03-Sep-2018
31-Aug-2018
30-Aug-2018
29-Aug-2018
28-Aug-2018
27-Aug-2018
24-Aug-2018
23-Aug-2018
22-Aug-2018
21-Aug-2018
20-Aug-2018
17-Aug-2018
16-Aug-2018
16-Aug-2018
15-Aug-2018
14-Aug-2018
13-Aug-2018
10-Aug-2018
08-Aug-2018
07-Aug-2018
03-Aug-2018
01-Aug-2018
31-Jul-2018
30-Jul-2018
26-Jul-2018
25-Jul-2018
24-Jul-2018
23-Jul-2018
20-Jul-2018
19-Jul-2018
18-Jul-2018
17-Jul-2018
16-Jul-2018
13-Jul-2018
12-Jul-2018
11-Jul-2018
10-Jul-2018
09-Jul-2018
06-Jul-2018
05-Jul-2018
04-Jul-2018
03-Jul-2018
25-Jun-2018
20-Jun-2018
05-Jun-2018
04-Jun-2018
28-May-2018
25-May-2018
24-May-2018
23-May-2018
16-May-2018
15-May-2018
14-May-2018
04-May-2018
03-May-2018
02-May-2018
01-May-2018
23-Apr-2018
20-Apr-2018
19-Apr-2018
18-Apr-2018
16-Apr-2018
13-Apr-2018
12-Apr-2018
11-Apr-2018
10-Apr-2018
09-Apr-2018
06-Apr-2018
05-Apr-2018
04-Apr-2018
03-Apr-2018
02-Apr-2018
27-Mar-2018
26-Mar-2018
23-Mar-2018
22-Mar-2018
22-Mar-2018
19-Mar-2018
17-Mar-2018
16-Mar-2018
16-Mar-2018
12-Mar-2018
27-Feb-2018
26-Feb-2018
23-Feb-2018
22-Feb-2018
21-Feb-2018
20-Feb-2018
19-Feb-2018
16-Feb-2018
15-Feb-2018
14-Feb-2018
13-Feb-2018
12-Feb-2018
09-Feb-2018
08-Feb-2018
07-Feb-2018
06-Feb-2018
05-Feb-2018
02-Feb-2018
01-Feb-2018
31-Jan-2018
30-Jan-2018
29-Jan-2018
26-Jan-2018
25-Jan-2018
24-Jan-2018
23-Jan-2018
22-Jan-2018
19-Jan-2018
18-Jan-2018
17-Jan-2018
12-Jan-2018
10-Jan-2018
09-Jan-2018
08-Jan-2018
23-Dec-2017
22-Dec-2017
21-Dec-2017
20-Dec-2017
19-Dec-2017
18-Dec-2017
15-Dec-2017
14-Dec-2017
13-Dec-2017
11-Dec-2017
08-Dec-2017
07-Dec-2017
06-Dec-2017
05-Dec-2017
04-Dec-2017
01-Dec-2017
30-Nov-2017
29-Nov-2017
28-Nov-2017
27-Nov-2017
24-Nov-2017
23-Nov-2017
22-Nov-2017
21-Nov-2017
20-Nov-2017
17-Nov-2017
16-Nov-2017
15-Nov-2017
14-Nov-2017
13-Nov-2017
10-Nov-2017
09-Nov-2017
08-Nov-2017
07-Nov-2017
06-Nov-2017
02-Nov-2017
01-Nov-2017
31-Oct-2017
30-Oct-2017
27-Oct-2017
26-Oct-2017
25-Oct-2017
24-Oct-2017
23-Oct-2017
20-Oct-2017
19-Oct-2017
18-Oct-2017
17-Oct-2017
16-Oct-2017
13-Oct-2017
11-Oct-2017
09-Oct-2017
06-Oct-2017
05-Oct-2017
04-Oct-2017
03-Oct-2017
02-Oct-2017
29-Sep-2017
28-Sep-2017
27-Sep-2017
26-Sep-2017
25-Sep-2017
24-Sep-2017
23-Sep-2017
22-Sep-2017
21-Sep-2017
20-Sep-2017
19-Sep-2017
18-Sep-2017
17-Sep-2017
16-Sep-2017
15-Sep-2017
14-Sep-2017
13-Sep-2017
12-Sep-2017
11-Sep-2017
08-Sep-2017
07-Sep-2017
06-Sep-2017
05-Sep-2017
04-Sep-2017
02-Sep-2017
01-Sep-2017
31-Aug-2017
30-Aug-2017
29-Aug-2017
28-Aug-2017
27-Aug-2017
26-Aug-2017
25-Aug-2017
24-Aug-2017
23-Aug-2017
22-Aug-2017
21-Aug-2017
20-Aug-2017
19-Aug-2017
18-Aug-2017
17-Aug-2017
16-Aug-2017
15-Aug-2017
14-Aug-2017
13-Aug-2017
12-Aug-2017
11-Aug-2017
10-Aug-2017
09-Aug-2017
08-Aug-2017
07-Aug-2017
06-Aug-2017
05-Aug-2017
04-Aug-2017
03-Aug-2017
02-Aug-2017
01-Aug-2017
31-Jul-2017
29-Jul-2017
28-Jul-2017
27-Jul-2017
26-Jul-2017
25-Jul-2017
24-Jul-2017
23-Jul-2017
22-Jul-2017
21-Jul-2017
20-Jul-2017
19-Jul-2017
18-Jul-2017
17-Jul-2017
16-Jul-2017
15-Jul-2017
14-Jul-2017
13-Jul-2017
12-Jul-2017
11-Jul-2017
10-Jul-2017
06-Jul-2017
05-Jul-2017
04-Jul-2017
03-Jul-2017
30-Jun-2017
29-Jun-2017
28-Jun-2017
27-Jun-2017
26-Jun-2017
23-Jun-2017
22-Jun-2017
21-Jun-2017
20-Jun-2017
19-Jun-2017
16-Jun-2017
15-Jun-2017
14-Jun-2017
13-Jun-2017
12-Jun-2017
09-Jun-2017
08-Jun-2017
07-Jun-2017
06-Jun-2017
05-Jun-2017
02-Jun-2017
01-Jun-2017
31-May-2017
30-May-2017
29-May-2017
25-May-2017
24-May-2017
23-May-2017
22-May-2017
19-May-2017
18-May-2017
17-May-2017
16-May-2017
15-May-2017
12-May-2017
11-May-2017
10-May-2017
09-May-2017
08-May-2017
05-May-2017
04-May-2017
03-May-2017
02-May-2017
01-May-2017
28-Apr-2017
27-Apr-2017
26-Apr-2017
25-Apr-2017
24-Apr-2017
21-Apr-2017
20-Apr-2017
19-Apr-2017
18-Apr-2017
17-Apr-2017
14-Apr-2017
13-Apr-2017
12-Apr-2017
11-Apr-2017
10-Apr-2017
07-Apr-2017
06-Apr-2017
05-Apr-2017
04-Apr-2017
03-Apr-2017
31-Mar-2017
30-Mar-2017
29-Mar-2017
28-Mar-2017
23-Mar-2017
17-Mar-2017
14-Mar-2017
13-Mar-2017
09-Mar-2017
08-Mar-2017
07-Mar-2017
06-Mar-2017
05-Mar-2017
03-Mar-2017
02-Mar-2017
01-Mar-2017
28-Feb-2017
27-Feb-2017
24-Feb-2017
23-Feb-2017
22-Feb-2017
16-Feb-2017
15-Feb-2017
14-Feb-2017
13-Feb-2017
10-Feb-2017
09-Feb-2017
08-Feb-2017
07-Feb-2017
06-Feb-2017
01-Feb-2017
31-Jan-2017
30-Jan-2017
26-Jan-2017
25-Jan-2017
24-Jan-2017
23-Jan-2017
09-Jan-2017
06-Jan-2017
05-Jan-2017
04-Jan-2017
03-Jan-2017
26-Dec-2016
23-Dec-2016
22-Dec-2016
21-Dec-2016
20-Dec-2016
19-Dec-2016
16-Dec-2016
15-Dec-2016
15-Dec-2016
14-Dec-2016
13-Dec-2016
12-Dec-2016
09-Dec-2016
08-Dec-2016
07-Dec-2016
06-Dec-2016
05-Dec-2016
02-Dec-2016
01-Dec-2016
30-Nov-2016
29-Nov-2016
28-Nov-2016
25-Nov-2016
24-Nov-2016
23-Nov-2016
22-Nov-2016
21-Nov-2016
18-Nov-2016
17-Nov-2016
16-Nov-2016
15-Nov-2016
14-Nov-2016
11-Nov-2016
10-Nov-2016
09-Nov-2016
08-Nov-2016
07-Nov-2016
04-Nov-2016
03-Nov-2016
02-Nov-2016
01-Nov-2016
31-Oct-2016
28-Oct-2016
27-Oct-2016
26-Oct-2016
25-Oct-2016
24-Oct-2016
21-Oct-2016
20-Oct-2016
19-Oct-2016
18-Oct-2016
17-Oct-2016
14-Oct-2016
13-Oct-2016
12-Oct-2016
11-Oct-2016
10-Oct-2016
07-Oct-2016
06-Oct-2016
05-Oct-2016
04-Oct-2016
03-Oct-2016
30-Sep-2016
29-Sep-2016
28-Sep-2016
27-Sep-2016
26-Sep-2016
23-Sep-2016
22-Sep-2016
21-Sep-2016
20-Sep-2016
19-Sep-2016
16-Sep-2016
15-Sep-2016
14-Sep-2016
13-Sep-2016
12-Sep-2016
09-Sep-2016
08-Sep-2016
07-Sep-2016
06-Sep-2016
05-Sep-2016
02-Sep-2016
01-Sep-2016
31-Aug-2016
30-Aug-2016
29-Aug-2016
26-Aug-2016
25-Aug-2016
24-Aug-2016
23-Aug-2016
22-Aug-2016
19-Aug-2016
18-Aug-2016
17-Aug-2016
16-Aug-2016
15-Aug-2016
12-Aug-2016
11-Aug-2016
10-Aug-2016
09-Aug-2016
08-Aug-2016
05-Aug-2016
04-Aug-2016
03-Aug-2016
02-Aug-2016
01-Aug-2016
29-Jul-2016
28-Jul-2016
27-Jul-2016
26-Jul-2016
25-Jul-2016
22-Jul-2016
21-Jul-2016
20-Jul-2016
19-Jul-2016
18-Jul-2016
15-Jul-2016
14-Jul-2016
13-Jul-2016
12-Jul-2016
11-Jul-2016
08-Jul-2016
07-Jul-2016
06-Jul-2016
05-Jul-2016
04-Jul-2016
01-Jul-2016
30-Jun-2016
29-Jun-2016
28-Jun-2016
27-Jun-2016
24-Jun-2016
23-Jun-2016
22-Jun-2016
21-Jun-2016
20-Jun-2016
17-Jun-2016
16-Jun-2016
15-Jun-2016
14-Jun-2016
13-Jun-2016
10-Jun-2016
09-Jun-2016
08-Jun-2016
07-Jun-2016
06-Jun-2016
03-Jun-2016
02-Jun-2016
01-Jun-2016
31-May-2016
30-May-2016
27-May-2016
26-May-2016
25-May-2016
25-May-2016
24-May-2016
23-May-2016
20-May-2016
19-May-2016
18-May-2016
17-May-2016
16-May-2016
13-May-2016
12-May-2016
11-May-2016
10-May-2016
09-May-2016
06-May-2016
05-May-2016
04-May-2016
03-May-2016
02-May-2016
29-Apr-2016
28-Apr-2016
27-Apr-2016
26-Apr-2016
25-Apr-2016
22-Apr-2016
21-Apr-2016
20-Apr-2016
19-Apr-2016
18-Apr-2016
15-Apr-2016
14-Apr-2016
13-Apr-2016
12-Apr-2016
11-Apr-2016
08-Apr-2016
07-Apr-2016
06-Apr-2016
05-Apr-2016
04-Apr-2016
01-Apr-2016
31-Mar-2016
30-Mar-2016
29-Mar-2016
28-Mar-2016
25-Mar-2016
24-Mar-2016
23-Mar-2016
22-Mar-2016
21-Mar-2016
18-Mar-2016
17-Mar-2016
16-Mar-2016
15-Mar-2016
14-Mar-2016
11-Mar-2016
10-Mar-2016
09-Mar-2016
08-Mar-2016
07-Mar-2016
04-Mar-2016
03-Mar-2016
02-Mar-2016
01-Mar-2016
29-Feb-2016
26-Feb-2016
25-Feb-2016
24-Feb-2016
23-Feb-2016
22-Feb-2016
19-Feb-2016
18-Feb-2016
17-Feb-2016
16-Feb-2016
15-Feb-2016
12-Feb-2016
11-Feb-2016
10-Feb-2016
09-Feb-2016
08-Feb-2016
05-Feb-2016
04-Feb-2016
03-Feb-2016
02-Feb-2016
01-Feb-2016
29-Jan-2016
28-Jan-2016
27-Jan-2016
26-Jan-2016
25-Jan-2016
22-Jan-2016
21-Jan-2016
20-Jan-2016
19-Jan-2016
18-Jan-2016
15-Jan-2016
14-Jan-2016
13-Jan-2016
12-Jan-2016
11-Jan-2016
08-Jan-2016
07-Jan-2016
06-Jan-2016
05-Jan-2016
04-Jan-2016
24-Dec-2015
23-Dec-2015
22-Dec-2015
21-Dec-2015
18-Dec-2015
17-Dec-2015
16-Dec-2015
15-Dec-2015
14-Dec-2015
11-Dec-2015
10-Dec-2015
09-Dec-2015
08-Dec-2015
07-Dec-2015
04-Dec-2015
03-Dec-2015
02-Dec-2015
01-Dec-2015
30-Nov-2015
27-Nov-2015
26-Nov-2015
25-Nov-2015
24-Nov-2015
23-Nov-2015
20-Nov-2015
19-Nov-2015
18-Nov-2015
17-Nov-2015
16-Nov-2015
13-Nov-2015
12-Nov-2015
11-Nov-2015
10-Nov-2015
09-Nov-2015
06-Nov-2015
05-Nov-2015
04-Nov-2015
03-Nov-2015
02-Nov-2015
30-Oct-2015
29-Oct-2015
28-Oct-2015
27-Oct-2015
26-Oct-2015
23-Oct-2015
22-Oct-2015
21-Oct-2015
20-Oct-2015
19-Oct-2015
16-Oct-2015
15-Oct-2015
14-Oct-2015
13-Oct-2015
12-Oct-2015
09-Oct-2015
08-Oct-2015
07-Oct-2015
06-Oct-2015
05-Oct-2015
02-Oct-2015
01-Oct-2015
30-Sep-2015
29-Sep-2015
28-Sep-2015
25-Sep-2015
24-Sep-2015
23-Sep-2015
22-Sep-2015
21-Sep-2015
18-Sep-2015
17-Sep-2015
16-Sep-2015
15-Sep-2015
14-Sep-2015
11-Sep-2015
10-Sep-2015
09-Sep-2015
08-Sep-2015
07-Sep-2015
04-Sep-2015
03-Sep-2015
02-Sep-2015
01-Sep-2015
31-Aug-2015
28-Aug-2015
27-Aug-2015
26-Aug-2015
25-Aug-2015
24-Aug-2015
21-Aug-2015
20-Aug-2015
19-Aug-2015
18-Aug-2015
17-Aug-2015
14-Aug-2015
13-Aug-2015
12-Aug-2015
11-Aug-2015
10-Aug-2015
07-Aug-2015
06-Aug-2015
05-Aug-2015
04-Aug-2015
03-Aug-2015
31-Jul-2015
30-Jul-2015
29-Jul-2015
28-Jul-2015
27-Jul-2015
24-Jul-2015
23-Jul-2015
22-Jul-2015
21-Jul-2015
20-Jul-2015
17-Jul-2015
16-Jul-2015
15-Jul-2015
14-Jul-2015
13-Jul-2015
10-Jul-2015
09-Jul-2015
08-Jul-2015
07-Jul-2015
06-Jul-2015
03-Jul-2015
02-Jul-2015
01-Jul-2015
30-Jun-2015
29-Jun-2015
26-Jun-2015
25-Jun-2015
24-Jun-2015
23-Jun-2015
22-Jun-2015
19-Jun-2015
18-Jun-2015
17-Jun-2015
16-Jun-2015
15-Jun-2015
12-Jun-2015
11-Jun-2015
10-Jun-2015
09-Jun-2015
08-Jun-2015
05-Jun-2015
04-Jun-2015
03-Jun-2015
02-Jun-2015
01-Jun-2015
29-May-2015
28-May-2015
27-May-2015
26-May-2015
25-May-2015
22-May-2015
21-May-2015
20-May-2015
19-May-2015
18-May-2015
15-May-2015
14-May-2015
13-May-2015
12-May-2015
11-May-2015
08-May-2015
07-May-2015
06-May-2015
05-May-2015
04-May-2015
01-May-2015
30-Apr-2015
29-Apr-2015
28-Apr-2015
27-Apr-2015
24-Apr-2015
23-Apr-2015
22-Apr-2015
21-Apr-2015
20-Apr-2015
17-Apr-2015
16-Apr-2015
15-Apr-2015
14-Apr-2015
13-Apr-2015
10-Apr-2015
09-Apr-2015
08-Apr-2015
07-Apr-2015
06-Apr-2015
03-Apr-2015
02-Apr-2015
01-Apr-2015
31-Mar-2015
30-Mar-2015
27-Mar-2015
26-Mar-2015
25-Mar-2015
24-Mar-2015
23-Mar-2015
20-Mar-2015
19-Mar-2015
18-Mar-2015
17-Mar-2015
16-Mar-2015
13-Mar-2015
11-Mar-2015
11-Mar-2015
10-Mar-2015
09-Mar-2015
06-Mar-2015
05-Mar-2015
04-Mar-2015
03-Mar-2015
02-Mar-2015
27-Feb-2015
26-Feb-2015
25-Feb-2015
24-Feb-2015
23-Feb-2015
20-Feb-2015
19-Feb-2015
18-Feb-2015
17-Feb-2015
16-Feb-2015
13-Feb-2015
12-Feb-2015
11-Feb-2015
10-Feb-2015
09-Feb-2015
06-Feb-2015
05-Feb-2015
04-Feb-2015
03-Feb-2015
02-Feb-2015
30-Jan-2015
29-Jan-2015
28-Jan-2015
27-Jan-2015
26-Jan-2015
23-Jan-2015
22-Jan-2015
21-Jan-2015
20-Jan-2015
19-Jan-2015
16-Jan-2015
15-Jan-2015
14-Jan-2015
13-Jan-2015
12-Jan-2015
09-Jan-2015
08-Jan-2015
07-Jan-2015
06-Jan-2015
05-Jan-2015
24-Dec-2014
23-Dec-2014
22-Dec-2014
19-Dec-2014
18-Dec-2014
17-Dec-2014
16-Dec-2014
15-Dec-2014
12-Dec-2014
11-Dec-2014
10-Dec-2014
09-Dec-2014
08-Dec-2014
05-Dec-2014
04-Dec-2014
03-Dec-2014
02-Dec-2014
01-Dec-2014
28-Nov-2014
27-Nov-2014
26-Nov-2014
25-Nov-2014
24-Nov-2014
21-Nov-2014
20-Nov-2014
19-Nov-2014
18-Nov-2014
17-Nov-2014
14-Nov-2014
13-Nov-2014
12-Nov-2014
11-Nov-2014
10-Nov-2014
07-Nov-2014
06-Nov-2014
05-Nov-2014
04-Nov-2014
03-Nov-2014
31-Oct-2014
30-Oct-2014
29-Oct-2014
28-Oct-2014
27-Oct-2014
24-Oct-2014
23-Oct-2014
22-Oct-2014
21-Oct-2014
20-Oct-2014
17-Oct-2014
16-Oct-2014
15-Oct-2014
14-Oct-2014
13-Oct-2014
10-Oct-2014
09-Oct-2014
08-Oct-2014
07-Oct-2014
06-Oct-2014
03-Oct-2014
02-Oct-2014
01-Oct-2014
30-Sep-2014
29-Sep-2014
26-Sep-2014
25-Sep-2014
24-Sep-2014
23-Sep-2014
22-Sep-2014
19-Sep-2014
18-Sep-2014
17-Sep-2014
16-Sep-2014
15-Sep-2014
12-Sep-2014
11-Sep-2014
10-Sep-2014
09-Sep-2014
08-Sep-2014
05-Sep-2014
04-Sep-2014
03-Sep-2014
02-Sep-2014
01-Sep-2014
29-Aug-2014
28-Aug-2014
27-Aug-2014
26-Aug-2014
25-Aug-2014
22-Aug-2014
21-Aug-2014
20-Aug-2014
19-Aug-2014
18-Aug-2014
15-Aug-2014
14-Aug-2014
13-Aug-2014
12-Aug-2014
11-Aug-2014
08-Aug-2014
07-Aug-2014
06-Aug-2014
05-Aug-2014
04-Aug-2014
01-Aug-2014
31-Jul-2014
30-Jul-2014
29-Jul-2014
28-Jul-2014
25-Jul-2014
24-Jul-2014
23-Jul-2014
22-Jul-2014
21-Jul-2014
18-Jul-2014
17-Jul-2014
16-Jul-2014
15-Jul-2014
14-Jul-2014
11-Jul-2014
10-Jul-2014
09-Jul-2014
08-Jul-2014
07-Jul-2014
04-Jul-2014
03-Jul-2014
02-Jul-2014
01-Jul-2014
30-Jun-2014
27-Jun-2014
26-Jun-2014
25-Jun-2014
24-Jun-2014
23-Jun-2014
20-Jun-2014
19-Jun-2014
18-Jun-2014
17-Jun-2014
16-Jun-2014
13-Jun-2014
12-Jun-2014
11-Jun-2014
10-Jun-2014
09-Jun-2014
06-Jun-2014
05-Jun-2014
04-Jun-2014
03-Jun-2014
02-Jun-2014
30-May-2014
29-May-2014
28-May-2014
27-May-2014
26-May-2014
23-May-2014
22-May-2014
21-May-2014
20-May-2014
19-May-2014
16-May-2014
15-May-2014
14-May-2014
13-May-2014
12-May-2014
09-May-2014
08-May-2014
07-May-2014
06-May-2014
05-May-2014
02-May-2014
01-May-2014
30-Apr-2014
29-Apr-2014
28-Apr-2014
25-Apr-2014
24-Apr-2014
23-Apr-2014
22-Apr-2014
21-Apr-2014
18-Apr-2014
17-Apr-2014
16-Apr-2014
15-Apr-2014
14-Apr-2014
11-Apr-2014
10-Apr-2014
09-Apr-2014
08-Apr-2014
07-Apr-2014
04-Apr-2014
03-Apr-2014
02-Apr-2014
01-Apr-2014
31-Mar-2014
28-Mar-2014
27-Mar-2014
26-Mar-2014
25-Mar-2014
24-Mar-2014
21-Mar-2014
20-Mar-2014
19-Mar-2014
18-Mar-2014
17-Mar-2014
14-Mar-2014
13-Mar-2014
12-Mar-2014
11-Mar-2014
10-Mar-2014
07-Mar-2014
06-Mar-2014
05-Mar-2014
04-Mar-2014
03-Mar-2014
28-Feb-2014
27-Feb-2014
26-Feb-2014
25-Feb-2014
24-Feb-2014
21-Feb-2014
20-Feb-2014
19-Feb-2014
18-Feb-2014
17-Feb-2014
14-Feb-2014
13-Feb-2014
12-Feb-2014
11-Feb-2014
10-Feb-2014
07-Feb-2014
06-Feb-2014
05-Feb-2014
04-Feb-2014
03-Feb-2014
31-Jan-2014
30-Jan-2014
29-Jan-2014
28-Jan-2014
27-Jan-2014
24-Jan-2014
23-Jan-2014
22-Jan-2014
21-Jan-2014
20-Jan-2014
17-Jan-2014
16-Jan-2014
15-Jan-2014
14-Jan-2014
13-Jan-2014
10-Jan-2014
09-Jan-2014
08-Jan-2014
07-Jan-2014
06-Jan-2014
25-Dec-2013
24-Dec-2013
23-Dec-2013
20-Dec-2013
19-Dec-2013
18-Dec-2013
17-Dec-2013
16-Dec-2013
13-Dec-2013
12-Dec-2013
11-Dec-2013
10-Dec-2013
09-Dec-2013
06-Dec-2013
05-Dec-2013
04-Dec-2013
03-Dec-2013
02-Dec-2013
29-Nov-2013
28-Nov-2013
27-Nov-2013
26-Nov-2013
25-Nov-2013
22-Nov-2013
21-Nov-2013
20-Nov-2013
19-Nov-2013
18-Nov-2013
15-Nov-2013
14-Nov-2013
13-Nov-2013
12-Nov-2013
11-Nov-2013
08-Nov-2013
07-Nov-2013
06-Nov-2013
05-Nov-2013
04-Nov-2013
01-Nov-2013
31-Oct-2013

Tip #44: Reflecting current user in CRM SSRS reports

It is a best practice to reflect the user running the report in an SSRS report and when the report was run in the report footer. This gives you a snapshot of who ran the report, and if there are any questions about the validity of the data reflected in the report, can be very helpful to troubleshoot the issues. Maybe the person running the report doesn’t have security permission to view all the data.

If you read an SSRS book, it will probably tell you to use the built in User!UserID expression in SSRS to reflect the current user. However, when writing reports for CRM, this doesn’t work. The reason is, for CRM reports, all users authenticate to the SSRS server using the same account (the Microsoft Dynamics CRM service account). If you use User!UserID, the report will reflect the name of the CRM service account in the footer.

If you are using SQL based reports, you can get the current user by using the CRM SQL function fn_FindUserGuid. Create a dataset in your RDL with the following query.

select fullname
from FilteredSystemUser
where systemuserid = dbo.fn_FindUserGuid()

If you are using Fetch based reports, you can get the current user by using the following FetchXML query.

<fetch version="1.0" output-format="xml-platform" 
       mapping="logical" distinct="false">
   <entity name="systemuser">
      <attribute name="fullname" />
      <attribute name="systemuserid" />
      <order attribute="fullname" descending="false" />
      <filter type="and">
         <condition attribute="systemuserid" 
                    operator="eq-userid" />
      </filter>
   </entity>
</fetch>

Tip #43: Embed a pre-filtered report in an iFrame

One of the benefits of the Microsoft Dynamics CRM SSRS pre-filtering capabilities is that you can run a report in context of a record, such as an account, so when you run the report, it just shows data related to that record. Reports can also be embedded in forms with iFrames, and prefiltering is very handy to make the embedded report reflect just the record you are viewing on the form.

    1. Add an iframe to your form in which to display the report. In this example I called it “IFRAME_Report.” Set the URL for the iFrame to about:blank and uncheck the “Restrict cross frame script” checkbox.
    2. Run the prefiltered report from the report menu or the form “run report” button. If you see the filter screen, filter the report to the desired record.
    3. After the report runs, copy the URL in your browser. If the URL bar is not displayed, click CTRL+N.
    4. Replace the highlighted lines in the following function to match your report URL. Note–you don’t want the website domain part of the URL–the /crmreports/viewer… URL makes it dynamic, so the report should work in any environment, as well as offline.
    5. Call the showReport function in the OnLoad event.
function showReport()
{
   //Get iframe
   var iframeObject = Xrm.Page.getControl("IFRAME_Report");

   if (iframeObject != null) {
      var strURL = "/crmreports/viewer/viewer.aspx"
         + "?action=run&context=records&helpID="
         + "Name%20of%20Report"
         + ".rdl&id=%7b"
         + "33db4d7f-446e-e311-940f-005056ab530d"
         + "%7d&records="
         + Xrm.Page.data.entity.getId()
         + "&recordstype=1";

      //Set URL of iframe
      iframeObject.setSrc(strURL);
   }
}

Tip #42: Adding Ready-to-use Business Processes

Happy New Year Ladies and Gentlemen – Gus Gonzalez here driving the CRM Tipping Truck today!

One of the biggest additions to Microsoft Dynamics CRM 2013 is Business Process Flow and when you start using Microsoft Dynamics CRM 2013 you will notice that Microsoft has included three new BPF processes for you to understand how this works.

Once you understand how BPF processes work, go ahead and add more Ready-to-Use Business Processes to the mix by Navigating to Settings -> Data Management -> Add Ready-to-Use Business Processes:

tip42-1

A truck load of processes (22 BPF and Workflows) will be automatically added to the list of available processes – some of them will be activated automatically, some of them will not:

tip42-2

I’m still trying to figure out how CRM decides what to activate and what not to activate and when I do I will post a follow up Tip, but until then, Enjoy!

Tip #40: Forty and twelve

It’s been 40 [business] days since our first post. Is it a coincidence that Western Christians have been waiting and preparing for adventus for the exactly forty days ? May be. While Eastern Christians keep the bodies in check throughout 40 days of the Рождественский Пост, we’ve been feeding your minds a steady, healthy and nutritious, even though illegal in some countries, doze of daily tips. Accidental? Perhaps.

A time to scatter tips and a time to gather tips. A time to hi-five and a time to close the shop.

We will re-open our daily injections of CRM wisdom after exactly Twelve Days, on January the 6th, 2014. Happenstance? Don’t think so.

We wish you Happy Holidays and see you (and your friends and colleagues) in the 2014.

Dynamics CRM Tipper
The Custodians of The Tipping Jar, bringing you tips by a truckload

Tip #39: Custom indexes in CRM Online

A little known secret for CRM Online users and a good reminder from . If you’ve added additional search fields to your Quick find or other views, the underlying entity contains a large number of records, and the response time is slow, you might need a custom SQL index added to improve the performance. While administrators of on premises deployments of Dynamics CRM can add SQL indexes as needed, there is no direct access to CRM Online database. The good news is that Microsoft Support can add required database indexes for you. Just open a support ticket and make the request (of course, you’d better do your homework and be sure that the index will solve the issue and not leave database performance unaffected or, worse, slow down your CRM)

Tipped to the jar by

Tip #38: Get Dynamics CRM SDK 6.02

If you’ve been rigorously following our tips, you should have downloaded Update Rollup 1 for CRM 2013 by now. If you are a developer at heart, you’d want latest Microsoft Dynamics CRM SDK as well and, what do you know, version 6.02 has recently been released.

Despite seemingly unimportant version number, this is no ordinary release as it includes cool new Microsoft Dynamics CRM 2013 User Interface Integration package which is available as a separate download.

User Interface Integration (UII) for Microsoft Dynamics CRM uses the features of Dynamics CRM to deliver composite applications that share a common user interface. UII includes development and run-time components. Applications built with UII can provide unified access to customer information spread across different systems, and can aggregate different modes of customer interactions or channels. Unlike expensive, rip and replace approaches or risky investments on custom development, UII provides non-intrusive integration with existing systems.

Tip #37: Update user information in CRM Online (Office 365)

If you use CRM Online on the Office 365 platform, you will notice that the main fields on the user record are read only. This is because user information is managed in Office 365 and synchronizes to CRM.

For example, say you have a CRM environment that already contains active users, and you want to change the format of the full name on the records. Say you want to change it from firstname lastname to lastname, firstname. When you change the format setting in CRM, it only applies to new users. Existing users will keep their existing format for full name.

The answer is to have your Office 365 administrator change something about the user’s name in Office 365. The change will synchronize with CRM, causing the full name format to be updated in the process. Just make sure you wait for a little while–it takes a little bit of time for changes to sync from Office 365 to CRM.