Clear Previous RegData
Clear Previous RegData
Hi,
I will be calling ExportDocument hundreds of times for the same report template; but each time with different DataTable.
Eg.
For i = 1 to 100
report.RegData(DataTables(i))
report.ExportDocument (xx, yyy)
Next
Question: How do I clear the previous Registered Datatable ?
I will be calling ExportDocument hundreds of times for the same report template; but each time with different DataTable.
Eg.
For i = 1 to 100
report.RegData(DataTables(i))
report.ExportDocument (xx, yyy)
Next
Question: How do I clear the previous Registered Datatable ?
Re: Clear Previous RegData
Hello,
Please try to use the following code:
Thank you.
Please try to use the following code:
Code: Select all
For i = 1 to 100
report.RegData(DataTables(i))
report.Render(False)
report.ExportDocument (xx, yyy)
Next
Re: Clear Previous RegData
Will there be any problem the RegData keep accumulating inside the report ?
The loop may reach up to thousands...
The loop may reach up to thousands...
Re: Clear Previous RegData
Hello.
If you use RegData method you could remove the previous data with next code:
Thank you.
If you use RegData method you could remove the previous data with next code:
Code: Select all
report.Dictionary.DataStore.Clear();
Re: Clear Previous RegData
To test this out...
But somehow there is still data in my exported Excel...
Code: Select all
rep.RegData(dtRecDetail)
rep.Dictionary.DataStore.Clear()
rep.Render(False)
rep.ExportDocument(Stimulsoft.Report.StiExportFormat.Excel2007, repFileName)
But somehow there is still data in my exported Excel...
Re: Clear Previous RegData
Hello.
We need to see your report template to answer your question.
Thank you.
We need to see your report template to answer your question.
Thank you.
Re: Clear Previous RegData
This is my template...
Code: Select all
<stimul:StiWebReport ID="stiReport" runat="server" ReportSource="H4sIAAAAAAAEAO29B2AcSZYlJi9tynt/SvVK1+B0oQiAYBMk2JBAEOzBiM3mkuwdaUcjKasqgcplVmVdZhZAzO2dvPfee++999577733ujudTif33/8/XGZkAWz2zkrayZ4hgKrIHz9+fB8/Ih7/Hu8WZXqZ101RLT/7aHe881GaL6fVrFhefPbRuj3fPvgobdpsOcvKapl/9tF13nz0exz9xsnj123xOq+LrCx+kNcBhL2P0vZ6RW1f5O1HabZalcU0a/lbeulVvqrq9iMCkaaPnxZTfJHV1+mr/JzeNq+6Lz5Ki+b3yq8/+6it17m8Ri8+WTfFMm+aLyc/nU/bhto8L5pWG6XTar2kP2gsd80LT7M2m2RNfsumr6t1PR1qvGvQQOO8zYpSsLcDB4Q32aTMBUx0CPz2cVlkzZHAeHxX/vK+PqnK9WI5hMWnPihqfZmV6/zohAZ59nT0+rpp88X4dVvTTD6+K99Fmr/IFvmtGz+ps+V0/jRvprd+5SRr84uqvn6vl16vJ1/rvS+q2brM3+uVl3VF87TAO3WxAs/d+tVX+QXNSl7TbFsS4vc3xSLf8NqXr59m14154WzZ3tvb0Pq4aYqL5Zvq1li9brN23bwXDQiHvF5m5at8kdVvLWo3vvf6+fG3icHtC0/zabHIyg1vcPM32dvcUvmm8fMbz/PzduR+818d/f7vdnb2Dn7/Ytnybw9/f5GmsUGOP935/bf1p37rENnI7nk2neezkf0loIzpWn/4kIGmdogf905+f/1rR5H0vjRtnslfe7//7u+jvzzyW+39/nsv9JcQRn8Aj++q4vA/81Rt0Rhla3Qet4AqsLqI/+h8ebYUfRY0sh9alXhXvjbq9K6nT81nr/KSLcIttLHYC4Oz/81PZmR+SHhvAkIY2LHLB6fLC7IePyk260j/Ii4MP+emn5fVBDaO0ZV5v7G/L3Ko/5vbvcwubjQx3GhX7Ms9Y1/w2YBRefykqmd5ffSCrPXhkzKbvj3cO3xdlcXs8FlWNvnhvnz6+K42dC/W62Z+9IZUfLPK6nzZUhP+yLY4qRYrArscsrf7gW2TiXtTtKXBf9/g7331hFyLQft4G6wEs7Kgr16RK5AtL8r8aGe0M94f3XswfkC/HJA8dL4PX75hWJ651zfe5O/avQcyqPtmUPhww0j4xVuNhltGRjS69+n405vHI69Xy1lxOwnz3npWLdujYzh1o9290ZOqnD2+y5/1Wn6R1SQqDaNF/z2+az7otWRFIgTraRVtAnY2An4vithLJpZpsx9tgz6Ovpvnb8vr9OxN+u28XM3y5m0qOjv9cpUvUzhH6S/MFqvDVHR6SmYiVRWTNWnWpr+Y3F1I+fhZVS+yduujX7zz6Jqeu198cXc2+yUfjdI31Sy7vpP+ksd3ucsoIjKrKmnug35bYp2j03ermnxZmi1qiw867HZXyBdy7V3Htl12fs+plynyxTUyUZsnqTNBne8f3/WB+198Xlfr1bfzjBSR6ohPjTh5X/1s6Yg9oyE+/VnREPfuy5Ae/PA0xO798d7N45HX35dN+C1PQxx80wri3v1vSkF8OqwgfvGW+mnGp0s/+yz9aPf3+ejO75F+ZD+DVoCuaD5KH6Uffbdo58WSP2Tv7qMfsujfu/++on/0izuj/CV4yXz5TagLX3K/cXXhA/e/CDTFgRGrn10lce8bdCQO4npCxvPwh6gmWEvs/9xric/Xxezo04NP703uf/pg/2G+t7+3d//h3sMH9+9/OpnNsp37k4ekzLjZN6JivikNczCsYV5UP2TtEOOpPc2n7fxwmIoZavT/Eqb6Gnyx90PgC/Y9z57+cJljL8Yc+8ocNtv6s8sc95g57v2/Suc82J3sZw8fTM5Jwexne3n2cPLpg4PZ/f3ZzqfZ3uT8G9Q5+z8E3vqqQQIPaccfJnPtx5jrU2Uumwz/2WWuT8k8k+b5fxVz3d/dye4dZNN7OXHZzuQ8e/BgejA7n+3fe7h378H+9Btkrk9/CMwlWf8fLmt9GmOth8paNg/2s8taB8i2/L+MtWbn97PdB7MHe/nD8/0He9Nslu0eZOcP7u3d29nd3d3/Blnr4Q+Btcwqzw+XuR7GmGtXw4pdm6X82eWuXYon/l/HXvceTGa7n+4eHOzmk/39g0n24Dyf3T948HByvje5d/7wG2Sv3VjYyE2+Qf6ihcT054bHdv3A1fazq7He7g8pa7x77wYW67z+Q2Cxg+nBzgGpsIP7O9P9vZ0H2Q4Ff7v5bH9ysL+7u/NNGsfdH0a49wWvOf+QmSsa8+1qvnHX5lB/lpmLk42j+/8v0l8Hnx5Md3ank/OHu/v7+d7s4GDnfLZ772BvkuXZp/cOvknm+saylRuY62Vd0QLnIsVyfl2sWmGLHyanhalHw2m69rX7Q0pt7+0wp+3CYv6/htf2sk8f3p/tPsgeHuxRCHnv4f1703xnen4+uZdNJw8n3ySvfWNLZxt47VV+QYTK63z2Q2axB1EWO1AWs2nen2UWEwb7f5MztnNvf3b//GCy9/De7v70IM/2Zwez/d2dnSzff5Dn+TfJYAc/BAb78nX6NLtufsjcdRDjrj3j7P+Qku57kgPbQ7Li/zX8tZdT5v2cNNfB5Hz/09nB5OH5wcFefv5gkh8c5Pe/ybz73g/D2T8mXrhY0urdmx9yBn4v6uvvaZp174eUg9+7z/mKXfz7/xoeu5/PZqTCsnzn4f39B/cmk/sPJjvnk+nOw90H9/eyb9Ih2/thJFo5if+6zdr1D1mP7UWTrXvq8u/9kFL5ew9Yj/2/SYtNpp/u7u/cJ1eMjOPBbHeyu08Z/Hz/HhnMnJyxb5LDfhgu/6t8kdVvf9jcFXXz99QH2/sh5fLv7f6/0M2fkSk8ON/ZuZ9nu/sHDyaT2Xl2sDt9uJflk5372eyb5K8fhhf2+vlx+u1qXf+wOSzqh93bUQ77IaX07937fx1/ZdmDg+ne7vnkgHJg0/vTh7sHO2Qozx8ePLj/6d75/W+Qv+7t/P+Xv+7tRPlrT/nrh5TUv7fPSf3/d3HYbGcn3z8n/XVAC0QH0/vZvYfTe5Tdz2nJO7v/6c43yWF7PwQOY+5Kn+fn7Q+Zxfa6H3+7qosfEOGz8nmxzDWm3LO5/fDrl3WxoKm+zG9ivy7T7ICXRvc+Zcd+Z+/+7fiqrGozevmj1+Z0OTvJVoq0zRnTRzcgeEvwdwX+ALd0SPezyzbksNetG6vNWn5zYzU99BinM87NHGS0lc15fXMc9LPNPzaR8s3RdIh/1Gw+fDDZnzy8P6Hk2Cz7dHJ+8Ol0LzvffzijUCAfTF5EmO9nWWeFzHfPZgO+OULdkvlC9QVwi1W1JPxDjf7+NkmJmmezvI5J8mZCdojY+Z4GIXD9z55mbaba9p6NfPHhk2w520DU21n2x0/WDZGrab6c/DRJCPiIQL5Yl6UhRGcAfXG7P7r3YPwA+eTNsvbYzUGc1rSW151VmCIz+B9SYCZx2d7N45G335d/+K1b+zRfwy35xswLuG3ILfnFT/M2K8oxUkRnT3/JB/smmr+OTb9mfe59eNR0q+mX5DX+/f8qA3xjiZvbMAB6+qamP5qX0dXXez+koOZTrFrQ2sX/d6f/G1s+vc30PyEST+dYsf+mmOBBjAk0N3fPRhs/u0wAWu/+v4UF2LU7zx5M73/66fkOpeT29/JZNrt373z2YG/nAaVU9ibfZFj7jeXlNvIPfLQPZxm0RQT7+poW8xc/mRE5J2WObMxQXBvNzO1qZu6eDQx/dvnrgBev/r+sZHa/sezabbTMSdbmF1V9/U3qmd1oDm1Xo9J7Nmz+2eWE3R3Oof1/mhW+sZDyNqzwej35WeGGXrqLP9VV7Xs2R/GzzA33/r/OC9/YsvRteOGLarYu82+UDaILz7ufKhvYvM/PMhvc5xjk/v932eDTHyYbvKwrMvoL8EFdrECID2cHtIULgTwLZaLWi0258t1Po1zzULhm3ybBfna5Zm/HLij/f5ZvHv4w+eZVfkGDzmua42/IFaWvnlX1Imt15m267mTdtNVCvrs5D/q6rYvlhbQ+uqbn7hdf3J3NkPv0vuh1f9f1H2fThzE23VPfd/+HlF7bEyb9/66N2/uhur5fvn6aXTc/O+xpM2ov1otJXt+WPZ/m02KRlU+Li4Ky6USN8IPIG5/X1Xr1OidOyVpK6o8oWg0/ibzzIr/IsPzzMmtJRpdHSGt2Poq89VWTP6+mWfk6b1sSlaNnWdnkj+92P35v2dmLRgt7Gi3s/5CSU3uSnNyjHNX/Z6XnhxotHNMy98XyTfXNyM+tHYK9aDSxd0+55YeUxdq7z2mGXfr3/7Pccu+HyS20tNium28ynti7F2UEjSf2f0jppr0HrDb+P6w0fqjxxNkS1iUrX+WLrH77Ddhe5YVolLBnooQfUsLp3u7/56OEvR9qlPD6+fG3q3X9zbFB1Au/p4vc+z+kTNO9e/8fZ4J7P9RlbuaAN9nb/IedWrgXXRK/ZzyJH1JC6t4+Z6n/P80v9x7f/SHzy/P8vP1wdlE+CB0JmoJqsaqWhFY46Pen/GPw4au8zPASKETvvViXpXkv0vo1jW6aMzVlvBQChh8HrzwrSjKot8ZH4BK8mIRvnq3uTPW+f13VbRyPva7APL7MynV+dPz65PFd+TX6fWzG+80pdUM9ex8JxZxwRyf0/SZTFor39nYOst3p7s6nD+/v72U7k/ODyWTv093zg/OH+zs7DzsLxVaUdkf8X1+UZD5A9u58PP6yhhpgxjl6ni1nzTRbUbDtf2zbAsC38+Ji3h7tESDvz6DJd4tZOz+693D8QNrI37bJq3wlM8jzGw7/u5TGq+GxiW68b9Our9tisS6b6rwdy/tjR2vy+Qv74qAC9TXT7s5OTy150vy9+zuP+L/vx0T68V3bmX4mwxRGkN+F9I9fUqqPmmrGotFB2Yxif1D8AsbTeTMclVKMKHmek6xM8xnFyPliQhp9gMkODCWU42Wtffy0LENO73xdZ1fU+03NvlssZ9VVM0bqpbkRJonMTW1+70U53MTRjCSrratyQ5eu7ZOsyW/TTueh0/Lx3RipzSTgjeOyyJoj+R2t3Wdeo5M5mdp8drS7e/fe3b0dWpLae7Tz6aP9/fTlF+Yl08Z/rc6J4fi1XXlt/xFx6P6O/5q28V4jlZ07TsEnolwmO/cmn96b7pxnn+5Pdu89/PRg9mm+/+nB+T0Si4N9A9GqGH2Z1UY4QKtJtMlXy6I9OiGRLBY5rIVpx5977X6SvoNiobHsj3fHuw8hjuFX3Po1rwUdrRtiwlR44/A3Tvw/DYt2Pw5YsvcOsaD7rM9Pse+Ef7qddflm+JvxU9I71UUUdk+hUaPfOFkSccnHm+apfN/8xskvFq5drYn9pum0zJpGv0wfRQDSJ/KbvKZvexDk26075mOvBZ52XjQUSJPxysriB7nFb+vOoWv4S4Cr+ePHa1qOqZap7TmlRAwl7/I6vcjpX7AoqaRZnm6nsypdVm26qGbF+fVvnPzYj/14vpx9/fcVF/of2WnhG4+HyLJdrEkvH528nmf1yjSxH0vT9rocUqBqprB8U7zOa6FIffT/ALTsNq6OagAA" />
Re: Clear Previous RegData
Hello,
We couldn't reproduce this bug on our samples.
Please send us a simple project with test data which reproduces the issue for analysis.
Thank you.
We couldn't reproduce this bug on our samples.
Please send us a simple project with test data which reproduces the issue for analysis.
Thank you.
Re: Clear Previous RegData
It working now !!! the data got cleared after calling
rep.Dictionary.DataStore.Clear()
I must have made some mistake...
Thank you.
rep.Dictionary.DataStore.Clear()
I must have made some mistake...
Thank you.
Re: Clear Previous RegData
Hello,
Thank you for the information.
Thank you for the information.