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