Event Report Maximum number of Columns

Hello All,

I have run into this problem where I cannot download reports from event capture after adding more than 130 columns. I was able to run and update the report with 130 columns but that didn’t complete the form. When I wanted to download all the columns the report first couldn’t manage to update as it kept loading forever. Then I started reducing the number of columns and at about 150 or so the report updated but could not be downloaded, beyond that the report won’t even update. Is there a way to increase the number of columns that can be downloaded?

DHIS2 Version: 2.36.6

Thank you,

Hi @WaluQ,

Could you tell me what format are you trying to export?
If you are trying to export to XLS and CSV, the request string should be shortened, so please provide me the request string starting from /api/… and I will show you and other community members how to overcome this issue

Regards,
Ulanbek

2 Likes

Format is xls and I think CSV produces the same results.

/api/29/analytics/events/query/H3JYOU839J6.xls?dimension=pe:LAST_3_MONTHS&dimension=ou:hbM9xGqs4Dw&dimension=xxqlPRn6y5L.Mu0zyPtdP5u&dimension=xxqlPRn6y5L.KkVdwLwuNcv&dimension=xxqlPRn6y5L.yiLraWztsed&dimension=xxqlPRn6y5L.eVVITz3TRRo&dimension=xxqlPRn6y5L.L4L4TaYbrSx&dimension=xxqlPRn6y5L.hQFrXEmH3Yp&dimension=xxqlPRn6y5L.SvEPblcql7h&dimension=xxqlPRn6y5L.lg2IAYL8Rg1&dimension=xxqlPRn6y5L.znrzv4L5wMC&dimension=xxqlPRn6y5L.H9PO4NOxhLY&dimension=xxqlPRn6y5L.ma2NDQxDYEy&dimension=xxqlPRn6y5L.TIgcswZogTQ&dimension=xxqlPRn6y5L.q4BinuQ2lt2&dimension=xxqlPRn6y5L.wITEkGtluqd&dimension=xxqlPRn6y5L.NZ57qXIVGEn&dimension=xxqlPRn6y5L.q86fRLYfrWw&dimension=xxqlPRn6y5L.CaUoWenpqSW&dimension=xxqlPRn6y5L.RWqEnuyj4ue&dimension=xxqlPRn6y5L.SUYHTLotvtx&dimension=xxqlPRn6y5L.yvvtkovhvYG&dimension=xxqlPRn6y5L.ZRJA6uLppKq&dimension=xxqlPRn6y5L.YfWszsTnYYa&dimension=xxqlPRn6y5L.mUo6gmjy98T&dimension=xxqlPRn6y5L.ZHmZZYwG0KG&dimension=xxqlPRn6y5L.s0YSUVdkoXf&dimension=xxqlPRn6y5L.EJsTzVtAx6i&dimension=xxqlPRn6y5L.iBDYiSy3OpM&dimension=xxqlPRn6y5L.m84Ljo5tWGQ&dimension=xxqlPRn6y5L.VEUVUS5rDGL&dimension=xxqlPRn6y5L.IY5ZOplcSVd&dimension=xxqlPRn6y5L.geAYXqrnqL4&dimension=xxqlPRn6y5L.V6hbYtEJih5&dimension=xxqlPRn6y5L.WCHOz7ZgU5K&dimension=xxqlPRn6y5L.oHYmOSLsGnM&dimension=xxqlPRn6y5L.TokAPvANVrs&dimension=xxqlPRn6y5L.jkmiVLKaDty&dimension=xxqlPRn6y5L.vCzF7KRvQV3&dimension=xxqlPRn6y5L.HZ1I8mT4Cjn&dimension=xxqlPRn6y5L.Zaw4lHRvD7V&dimension=xxqlPRn6y5L.CgMfvG5fyj6&dimension=xxqlPRn6y5L.ew0BzNk1eWQ&dimension=xxqlPRn6y5L.RMFnfPaXMUP&dimension=xxqlPRn6y5L.G3Ttvk15Tjt&dimension=xxqlPRn6y5L.Vv2J6D06g3b&dimension=xxqlPRn6y5L.BKdIiD3fSpH&dimension=xxqlPRn6y5L.nvsITnJQHVk&dimension=xxqlPRn6y5L.JRqg9Xs5jyI&dimension=xxqlPRn6y5L.JR7uW6U9r1q&dimension=xxqlPRn6y5L.PSFqXQ6F0YC&dimension=xxqlPRn6y5L.Y3GnZcVR8pP&dimension=xxqlPRn6y5L.ZrioiED1idg&dimension=xxqlPRn6y5L.QA6bIMWT2IR&dimension=xxqlPRn6y5L.Zn66b7Dd1HN&dimension=xxqlPRn6y5L.Es5dSGUlQ1w&dimension=xxqlPRn6y5L.cDWV770MYBO&dimension=xxqlPRn6y5L.FERLzCyZMGh&dimension=xxqlPRn6y5L.hDa1LtFuavO&dimension=xxqlPRn6y5L.QVr1MqCsOPh&dimension=xxqlPRn6y5L.e9RVlPDpXm9&dimension=xxqlPRn6y5L.I4ykT8PKV5h&dimension=xxqlPRn6y5L.vm89coTlMAe&dimension=xxqlPRn6y5L.PfzyrUUXPdu&dimension=xxqlPRn6y5L.knoVWF6SZqP&dimension=xxqlPRn6y5L.rXlPjGeQKqO&dimension=xxqlPRn6y5L.Z9qUZScZdpR&dimension=xxqlPRn6y5L.ZiG5tLnYCAN&dimension=xxqlPRn6y5L.pDzHJdI8nZp&dimension=xxqlPRn6y5L.i1aZn5ibBwO&dimension=xxqlPRn6y5L.fdGbqXYJ6Ma&dimension=xxqlPRn6y5L.jIxPyKOgAfU&dimension=xxqlPRn6y5L.TahMcgUDKNU&dimension=xxqlPRn6y5L.cKRKb5OnxRO&dimension=xxqlPRn6y5L.mrIaqCtCL8h&dimension=xxqlPRn6y5L.mUwRtlM3Osy&dimension=xxqlPRn6y5L.bxRQnaRQrZC&dimension=xxqlPRn6y5L.B9c8F79Z4G7&dimension=xxqlPRn6y5L.bjcSe4ITYhg&dimension=xxqlPRn6y5L.gQJm4MTytWX&dimension=xxqlPRn6y5L.xfHVbSofpcM&dimension=xxqlPRn6y5L.mJbBLhCk2GZ&dimension=xxqlPRn6y5L.oq36nv7nmPW&dimension=xxqlPRn6y5L.eac6u6yC0Hz&dimension=xxqlPRn6y5L.p480XqAbCPE&dimension=xxqlPRn6y5L.a39oz9yZMKZ&dimension=xxqlPRn6y5L.DDo4WlKh2vz&dimension=xxqlPRn6y5L.niQ9QAeeRdy&dimension=xxqlPRn6y5L.bQau8ATuW1i&dimension=xxqlPRn6y5L.W8LtJCcD9CM&dimension=xxqlPRn6y5L.zUdMKlNawrN&dimension=xxqlPRn6y5L.OnghD5rmxqw&dimension=xxqlPRn6y5L.JlQVGnvNVmo&dimension=xxqlPRn6y5L.tKxAjOUBhFe&dimension=xxqlPRn6y5L.UYQIdPSsgM4&dimension=xxqlPRn6y5L.PjvvRcZNRzE&dimension=xxqlPRn6y5L.wDGRmFn3jZR&dimension=xxqlPRn6y5L.bDk3L1APPsn&dimension=xxqlPRn6y5L.lsxXrM8plWJ&dimension=xxqlPRn6y5L.bi9I14jrSBG&dimension=xxqlPRn6y5L.EPYxzAQePTV&dimension=xxqlPRn6y5L.P5ZI1gecndP&dimension=xxqlPRn6y5L.Ucy3cTQbfph&dimension=xxqlPRn6y5L.wwbP0pFoPHp&dimension=xxqlPRn6y5L.EURIVSu8eDa&dimension=xxqlPRn6y5L.C2YZWR3Tpdw&dimension=xxqlPRn6y5L.uZUF77BjyGG&dimension=xxqlPRn6y5L.NvGenDL5jUy&dimension=xxqlPRn6y5L.yDskC7SIccH&dimension=xxqlPRn6y5L.h2f0FyRkyJK&dimension=xxqlPRn6y5L.tdpwpJib6B6&dimension=xxqlPRn6y5L.Pzkjgrn8xSR&dimension=xxqlPRn6y5L.mkczoovIMtj&dimension=xxqlPRn6y5L.XIqivsKcyFZ&dimension=xxqlPRn6y5L.MOOAtScJ1GW&dimension=xxqlPRn6y5L.yriwuALZwr0&dimension=xxqlPRn6y5L.sYYaGKuFWjo&dimension=xxqlPRn6y5L.PYuDJJKyKIh&dimension=xxqlPRn6y5L.re39E0J3UZD&dimension=xxqlPRn6y5L.WROckxx6KwX&dimension=xxqlPRn6y5L.V36Kn1SygFk&dimension=xxqlPRn6y5L.GtdykTMZFl5&dimension=xxqlPRn6y5L.TYYNgKwsvjZ&dimension=xxqlPRn6y5L.iqo0yVAYDas&dimension=xxqlPRn6y5L.dAC8ttoGNbh&dimension=xxqlPRn6y5L.I1bGnoIkPlU&dimension=xxqlPRn6y5L.EYJN0IknPri&dimension=xxqlPRn6y5L.khFH6CHJ3Cz&dimension=xxqlPRn6y5L.nVWAKggzzDj&dimension=xxqlPRn6y5L.wFrHIWlrIAN&dimension=xxqlPRn6y5L.WOGfpA1vpDy&dimension=xxqlPRn6y5L.yxPpiMZ5c85&dimension=xxqlPRn6y5L.uQ0ncXDlgqi&dimension=xxqlPRn6y5L.SgZ59OTKIOp&dimension=xxqlPRn6y5L.hcXy8c4pwkp&dimension=xxqlPRn6y5L.vR3vgdrGR3m&dimension=xxqlPRn6y5L.ObAEVBLKrRz&dimension=xxqlPRn6y5L.ofCsF1O7TZx&dimension=xxqlPRn6y5L.rAzZS6xc4a8&dimension=xxqlPRn6y5L.akXXtBNbbAH&dimension=xxqlPRn6y5L.E1Tqgw0jEmi&dimension=xxqlPRn6y5L.IgtXrXIqhwP&dimension=xxqlPRn6y5L.ChrqDeHE1AH&stage=xxqlPRn6y5L&displayProperty=NAME&completedOnly=true&tableLayout=true&dataIdScheme=NAME&columns=pe;ou;Mu0zyPtdP5u;KkVdwLwuNcv;yiLraWztsed;eVVITz3TRRo;L4L4TaYbrSx;hQFrXEmH3Yp;SvEPblcql7h;lg2IAYL8Rg1;znrzv4L5wMC;H9PO4NOxhLY;ma2NDQxDYEy;TIgcswZogTQ;q4BinuQ2lt2;wITEkGtluqd;NZ57qXIVGEn;q86fRLYfrWw;CaUoWenpqSW;RWqEnuyj4ue;SUYHTLotvtx;yvvtkovhvYG;ZRJA6uLppKq;YfWszsTnYYa;mUo6gmjy98T;ZHmZZYwG0KG;s0YSUVdkoXf;EJsTzVtAx6i;iBDYiSy3OpM;m84Ljo5tWGQ;VEUVUS5rDGL;IY5ZOplcSVd;geAYXqrnqL4;V6hbYtEJih5;WCHOz7ZgU5K;oHYmOSLsGnM;TokAPvANVrs;jkmiVLKaDty;vCzF7KRvQV3;HZ1I8mT4Cjn;Zaw4lHRvD7V;CgMfvG5fyj6;ew0BzNk1eWQ;RMFnfPaXMUP;G3Ttvk15Tjt;Vv2J6D06g3b;BKdIiD3fSpH;nvsITnJQHVk;JRqg9Xs5jyI;JR7uW6U9r1q;PSFqXQ6F0YC;Y3GnZcVR8pP;ZrioiED1idg;QA6bIMWT2IR;Zn66b7Dd1HN;Es5dSGUlQ1w;cDWV770MYBO;FERLzCyZMGh;hDa1LtFuavO;QVr1MqCsOPh;e9RVlPDpXm9;I4ykT8PKV5h;vm89coTlMAe;PfzyrUUXPdu;knoVWF6SZqP;rXlPjGeQKqO;Z9qUZScZdpR;ZiG5tLnYCAN;pDzHJdI8nZp;i1aZn5ibBwO;fdGbqXYJ6Ma;jIxPyKOgAfU;TahMcgUDKNU;cKRKb5OnxRO;mrIaqCtCL8h;mUwRtlM3Osy;bxRQnaRQrZC;B9c8F79Z4G7;bjcSe4ITYhg;gQJm4MTytWX;xfHVbSofpcM;mJbBLhCk2GZ;oq36nv7nmPW;eac6u6yC0Hz;p480XqAbCPE;a39oz9yZMKZ;DDo4WlKh2vz;niQ9QAeeRdy;bQau8ATuW1i;W8LtJCcD9CM;zUdMKlNawrN;OnghD5rmxqw;JlQVGnvNVmo;tKxAjOUBhFe;UYQIdPSsgM4;PjvvRcZNRzE;wDGRmFn3jZR;bDk3L1APPsn;lsxXrM8plWJ;bi9I14jrSBG;EPYxzAQePTV;P5ZI1gecndP;Ucy3cTQbfph;wwbP0pFoPHp;EURIVSu8eDa;C2YZWR3Tpdw;uZUF77BjyGG;NvGenDL5jUy;yDskC7SIccH;h2f0FyRkyJK;tdpwpJib6B6;Pzkjgrn8xSR;mkczoovIMtj;XIqivsKcyFZ;MOOAtScJ1GW;yriwuALZwr0;sYYaGKuFWjo;PYuDJJKyKIh;re39E0J3UZD;WROckxx6KwX;V36Kn1SygFk;GtdykTMZFl5;TYYNgKwsvjZ;iqo0yVAYDas;dAC8ttoGNbh;I1bGnoIkPlU;EYJN0IknPri;khFH6CHJ3Cz;nVWAKggzzDj;wFrHIWlrIAN;WOGfpA1vpDy;yxPpiMZ5c85;uQ0ncXDlgqi;SgZ59OTKIOp;hcXy8c4pwkp;vR3vgdrGR3m;ObAEVBLKrRz;ofCsF1O7TZx;rAzZS6xc4a8;akXXtBNbbAH;E1Tqgw0jEmi;IgtXrXIqhwP;ChrqDeHE1AH&rows=pe;ou;Mu0zyPtdP5u;KkVdwLwuNcv;yiLraWztsed;eVVITz3TRRo;L4L4TaYbrSx;hQFrXEmH3Yp;SvEPblcql7h;lg2IAYL8Rg1;znrzv4L5wMC;H9PO4NOxhLY;ma2NDQxDYEy;TIgcswZogTQ;q4BinuQ2lt2;wITEkGtluqd;NZ57qXIVGEn;q86fRLYfrWw;CaUoWenpqSW;RWqEnuyj4ue;SUYHTLotvtx;yvvtkovhvYG;ZRJA6uLppKq;YfWszsTnYYa;mUo6gmjy98T;ZHmZZYwG0KG;s0YSUVdkoXf;EJsTzVtAx6i;iBDYiSy3OpM;m84Ljo5tWGQ;VEUVUS5rDGL;IY5ZOplcSVd;geAYXqrnqL4;V6hbYtEJih5;WCHOz7ZgU5K;oHYmOSLsGnM;TokAPvANVrs;jkmiVLKaDty;vCzF7KRvQV3;HZ1I8mT4Cjn;Zaw4lHRvD7V;CgMfvG5fyj6;ew0BzNk1eWQ;RMFnfPaXMUP;G3Ttvk15Tjt;Vv2J6D06g3b;BKdIiD3fSpH;nvsITnJQHVk;JRqg9Xs5jyI;JR7uW6U9r1q;PSFqXQ6F0YC;Y3GnZcVR8pP;ZrioiED1idg;QA6bIMWT2IR;Zn66b7Dd1HN;Es5dSGUlQ1w;cDWV770MYBO;FERLzCyZMGh;hDa1LtFuavO;QVr1MqCsOPh;e9RVlPDpXm9;I4ykT8PKV5h;vm89coTlMAe;PfzyrUUXPdu;knoVWF6SZqP;rXlPjGeQKqO;Z9qUZScZdpR;ZiG5tLnYCAN;pDzHJdI8nZp;i1aZn5ibBwO;fdGbqXYJ6Ma;jIxPyKOgAfU;TahMcgUDKNU;cKRKb5OnxRO;mrIaqCtCL8h;mUwRtlM3Osy;bxRQnaRQrZC;B9c8F79Z4G7;bjcSe4ITYhg;gQJm4MTytWX;xfHVbSofpcM;mJbBLhCk2GZ;oq36nv7nmPW;eac6u6yC0Hz;p480XqAbCPE;a39oz9yZMKZ;DDo4WlKh2vz;niQ9QAeeRdy;bQau8ATuW1i;W8LtJCcD9CM;zUdMKlNawrN;OnghD5rmxqw;JlQVGnvNVmo;tKxAjOUBhFe;UYQIdPSsgM4;PjvvRcZNRzE;wDGRmFn3jZR;bDk3L1APPsn;lsxXrM8plWJ;bi9I14jrSBG;EPYxzAQePTV;P5ZI1gecndP;Ucy3cTQbfph;wwbP0pFoPHp;EURIVSu8eDa;C2YZWR3Tpdw;uZUF77BjyGG;NvGenDL5jUy;yDskC7SIccH;h2f0FyRkyJK;tdpwpJib6B6;Pzkjgrn8xSR;mkczoovIMtj;XIqivsKcyFZ;MOOAtScJ1GW;yriwuALZwr0;sYYaGKuFWjo;PYuDJJKyKIh;re39E0J3UZD;WROckxx6KwX;V36Kn1SygFk;GtdykTMZFl5;TYYNgKwsvjZ;iqo0yVAYDas;dAC8ttoGNbh;I1bGnoIkPlU;EYJN0IknPri;khFH6CHJ3Cz;nVWAKggzzDj;wFrHIWlrIAN;WOGfpA1vpDy;yxPpiMZ5c85;uQ0ncXDlgqi;SgZ59OTKIOp;hcXy8c4pwkp;vR3vgdrGR3m;ObAEVBLKrRz;ofCsF1O7TZx;rAzZS6xc4a8;akXXtBNbbAH;E1Tqgw0jEmi;IgtXrXIqhwP;ChrqDeHE1AH&paging=

Try to run this query. I have truncate unnecessary part of the request.

/api/29/analytics/events/query/H3JYOU839J6.xls?dimension=pe:LAST_3_MONTHS&dimension=ou:hbM9xGqs4Dw&dimension=xxqlPRn6y5L.Mu0zyPtdP5u&dimension=xxqlPRn6y5L.KkVdwLwuNcv&dimension=xxqlPRn6y5L.yiLraWztsed&dimension=xxqlPRn6y5L.eVVITz3TRRo&dimension=xxqlPRn6y5L.L4L4TaYbrSx&dimension=xxqlPRn6y5L.hQFrXEmH3Yp&dimension=xxqlPRn6y5L.SvEPblcql7h&dimension=xxqlPRn6y5L.lg2IAYL8Rg1&dimension=xxqlPRn6y5L.znrzv4L5wMC&dimension=xxqlPRn6y5L.H9PO4NOxhLY&dimension=xxqlPRn6y5L.ma2NDQxDYEy&dimension=xxqlPRn6y5L.TIgcswZogTQ&dimension=xxqlPRn6y5L.q4BinuQ2lt2&dimension=xxqlPRn6y5L.wITEkGtluqd&dimension=xxqlPRn6y5L.NZ57qXIVGEn&dimension=xxqlPRn6y5L.q86fRLYfrWw&dimension=xxqlPRn6y5L.CaUoWenpqSW&dimension=xxqlPRn6y5L.RWqEnuyj4ue&dimension=xxqlPRn6y5L.SUYHTLotvtx&dimension=xxqlPRn6y5L.yvvtkovhvYG&dimension=xxqlPRn6y5L.ZRJA6uLppKq&dimension=xxqlPRn6y5L.YfWszsTnYYa&dimension=xxqlPRn6y5L.mUo6gmjy98T&dimension=xxqlPRn6y5L.ZHmZZYwG0KG&dimension=xxqlPRn6y5L.s0YSUVdkoXf&dimension=xxqlPRn6y5L.EJsTzVtAx6i&dimension=xxqlPRn6y5L.iBDYiSy3OpM&dimension=xxqlPRn6y5L.m84Ljo5tWGQ&dimension=xxqlPRn6y5L.VEUVUS5rDGL&dimension=xxqlPRn6y5L.IY5ZOplcSVd&dimension=xxqlPRn6y5L.geAYXqrnqL4&dimension=xxqlPRn6y5L.V6hbYtEJih5&dimension=xxqlPRn6y5L.WCHOz7ZgU5K&dimension=xxqlPRn6y5L.oHYmOSLsGnM&dimension=xxqlPRn6y5L.TokAPvANVrs&dimension=xxqlPRn6y5L.jkmiVLKaDty&dimension=xxqlPRn6y5L.vCzF7KRvQV3&dimension=xxqlPRn6y5L.HZ1I8mT4Cjn&dimension=xxqlPRn6y5L.Zaw4lHRvD7V&dimension=xxqlPRn6y5L.CgMfvG5fyj6&dimension=xxqlPRn6y5L.ew0BzNk1eWQ&dimension=xxqlPRn6y5L.RMFnfPaXMUP&dimension=xxqlPRn6y5L.G3Ttvk15Tjt&dimension=xxqlPRn6y5L.Vv2J6D06g3b&dimension=xxqlPRn6y5L.BKdIiD3fSpH&dimension=xxqlPRn6y5L.nvsITnJQHVk&dimension=xxqlPRn6y5L.JRqg9Xs5jyI&dimension=xxqlPRn6y5L.JR7uW6U9r1q&dimension=xxqlPRn6y5L.PSFqXQ6F0YC&dimension=xxqlPRn6y5L.Y3GnZcVR8pP&dimension=xxqlPRn6y5L.ZrioiED1idg&dimension=xxqlPRn6y5L.QA6bIMWT2IR&dimension=xxqlPRn6y5L.Zn66b7Dd1HN&dimension=xxqlPRn6y5L.Es5dSGUlQ1w&dimension=xxqlPRn6y5L.cDWV770MYBO&dimension=xxqlPRn6y5L.FERLzCyZMGh&dimension=xxqlPRn6y5L.hDa1LtFuavO&dimension=xxqlPRn6y5L.QVr1MqCsOPh&dimension=xxqlPRn6y5L.e9RVlPDpXm9&dimension=xxqlPRn6y5L.I4ykT8PKV5h&dimension=xxqlPRn6y5L.vm89coTlMAe&dimension=xxqlPRn6y5L.PfzyrUUXPdu&dimension=xxqlPRn6y5L.knoVWF6SZqP&dimension=xxqlPRn6y5L.rXlPjGeQKqO&dimension=xxqlPRn6y5L.Z9qUZScZdpR&dimension=xxqlPRn6y5L.ZiG5tLnYCAN&dimension=xxqlPRn6y5L.pDzHJdI8nZp&dimension=xxqlPRn6y5L.i1aZn5ibBwO&dimension=xxqlPRn6y5L.fdGbqXYJ6Ma&dimension=xxqlPRn6y5L.jIxPyKOgAfU&dimension=xxqlPRn6y5L.TahMcgUDKNU&dimension=xxqlPRn6y5L.cKRKb5OnxRO&dimension=xxqlPRn6y5L.mrIaqCtCL8h&dimension=xxqlPRn6y5L.mUwRtlM3Osy&dimension=xxqlPRn6y5L.bxRQnaRQrZC&dimension=xxqlPRn6y5L.B9c8F79Z4G7&dimension=xxqlPRn6y5L.bjcSe4ITYhg&dimension=xxqlPRn6y5L.gQJm4MTytWX&dimension=xxqlPRn6y5L.xfHVbSofpcM&dimension=xxqlPRn6y5L.mJbBLhCk2GZ&dimension=xxqlPRn6y5L.oq36nv7nmPW&dimension=xxqlPRn6y5L.eac6u6yC0Hz&dimension=xxqlPRn6y5L.p480XqAbCPE&dimension=xxqlPRn6y5L.a39oz9yZMKZ&dimension=xxqlPRn6y5L.DDo4WlKh2vz&dimension=xxqlPRn6y5L.niQ9QAeeRdy&dimension=xxqlPRn6y5L.bQau8ATuW1i&dimension=xxqlPRn6y5L.W8LtJCcD9CM&dimension=xxqlPRn6y5L.zUdMKlNawrN&dimension=xxqlPRn6y5L.OnghD5rmxqw&dimension=xxqlPRn6y5L.JlQVGnvNVmo&dimension=xxqlPRn6y5L.tKxAjOUBhFe&dimension=xxqlPRn6y5L.UYQIdPSsgM4&dimension=xxqlPRn6y5L.PjvvRcZNRzE&dimension=xxqlPRn6y5L.wDGRmFn3jZR&dimension=xxqlPRn6y5L.bDk3L1APPsn&dimension=xxqlPRn6y5L.lsxXrM8plWJ&dimension=xxqlPRn6y5L.bi9I14jrSBG&dimension=xxqlPRn6y5L.EPYxzAQePTV&dimension=xxqlPRn6y5L.P5ZI1gecndP&dimension=xxqlPRn6y5L.Ucy3cTQbfph&dimension=xxqlPRn6y5L.wwbP0pFoPHp&dimension=xxqlPRn6y5L.EURIVSu8eDa&dimension=xxqlPRn6y5L.C2YZWR3Tpdw&dimension=xxqlPRn6y5L.uZUF77BjyGG&dimension=xxqlPRn6y5L.NvGenDL5jUy&dimension=xxqlPRn6y5L.yDskC7SIccH&dimension=xxqlPRn6y5L.h2f0FyRkyJK&dimension=xxqlPRn6y5L.tdpwpJib6B6&dimension=xxqlPRn6y5L.Pzkjgrn8xSR&dimension=xxqlPRn6y5L.mkczoovIMtj&dimension=xxqlPRn6y5L.XIqivsKcyFZ&dimension=xxqlPRn6y5L.MOOAtScJ1GW&dimension=xxqlPRn6y5L.yriwuALZwr0&dimension=xxqlPRn6y5L.sYYaGKuFWjo&dimension=xxqlPRn6y5L.PYuDJJKyKIh&dimension=xxqlPRn6y5L.re39E0J3UZD&dimension=xxqlPRn6y5L.WROckxx6KwX&dimension=xxqlPRn6y5L.V36Kn1SygFk&dimension=xxqlPRn6y5L.GtdykTMZFl5&dimension=xxqlPRn6y5L.TYYNgKwsvjZ&dimension=xxqlPRn6y5L.iqo0yVAYDas&dimension=xxqlPRn6y5L.dAC8ttoGNbh&dimension=xxqlPRn6y5L.I1bGnoIkPlU&dimension=xxqlPRn6y5L.EYJN0IknPri&dimension=xxqlPRn6y5L.khFH6CHJ3Cz&dimension=xxqlPRn6y5L.nVWAKggzzDj&dimension=xxqlPRn6y5L.wFrHIWlrIAN&dimension=xxqlPRn6y5L.WOGfpA1vpDy&dimension=xxqlPRn6y5L.yxPpiMZ5c85&dimension=xxqlPRn6y5L.uQ0ncXDlgqi&dimension=xxqlPRn6y5L.SgZ59OTKIOp&dimension=xxqlPRn6y5L.hcXy8c4pwkp&dimension=xxqlPRn6y5L.vR3vgdrGR3m&dimension=xxqlPRn6y5L.ObAEVBLKrRz&dimension=xxqlPRn6y5L.ofCsF1O7TZx&dimension=xxqlPRn6y5L.rAzZS6xc4a8&dimension=xxqlPRn6y5L.akXXtBNbbAH&dimension=xxqlPRn6y5L.E1Tqgw0jEmi&dimension=xxqlPRn6y5L.IgtXrXIqhwP&dimension=xxqlPRn6y5L.ChrqDeHE1AH&stage=xxqlPRn6y5L&displayProperty=NAME&completedOnly=true&tableLayout=true&dataIdScheme=NAME

2 Likes

Thank you @Ulanbek that did the trick.Very grateful.

1 Like

You are welcome!

1 Like

Dear @Markus, @Morten_Haugen, @dhis2-analytics @tracker-analytics team,

Would it be possible to change request string and shorten it by removing columns field? They listed data columns in the &columns= field are extra, and doesn’t add anything usable. Removing the columns will enable to download reports with more fields.
I used to struggle a lot as well, while found the way how overcome the situation.

Thank you
Regards,
Ulanbek

2 Likes

I have sent your message to the analytics team. Thank you for your support and suggestions! :+1:

You could take this further and make suggestions in the Github repo of the app. :relaxed:

2 Likes

Thank you @Gassim!
Community will be alive, only if the members can help each other. It can be enhanced if the ambassadors/liason person like you can support users on their requests, and pass to the team.

Thanks again
Regards,
Ulanbek

2 Likes

That’s the spirit! Thank you @Ulanbek! Will continue to try my best :grin:

1 Like