Clear Previous RegData

Stimulsoft Reports.NET discussion
Post Reply
fkmfkm
Posts: 181
Joined: Thu Jul 05, 2007 11:26 pm
Location: Kuala Lumpur

Clear Previous RegData

Post by fkmfkm »

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 ?
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Clear Previous RegData

Post by Alex K. »

Hello,

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
Thank you.
fkmfkm
Posts: 181
Joined: Thu Jul 05, 2007 11:26 pm
Location: Kuala Lumpur

Re: Clear Previous RegData

Post by fkmfkm »

Will there be any problem the RegData keep accumulating inside the report ?

The loop may reach up to thousands...
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Clear Previous RegData

Post by HighAley »

Hello.

If you use RegData method you could remove the previous data with next code:

Code: Select all

report.Dictionary.DataStore.Clear();
Thank you.
fkmfkm
Posts: 181
Joined: Thu Jul 05, 2007 11:26 pm
Location: Kuala Lumpur

Re: Clear Previous RegData

Post by fkmfkm »

To test this out...

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...
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Clear Previous RegData

Post by HighAley »

Hello.

We need to see your report template to answer your question.

Thank you.
fkmfkm
Posts: 181
Joined: Thu Jul 05, 2007 11:26 pm
Location: Kuala Lumpur

Re: Clear Previous RegData

Post by fkmfkm »

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" />
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Clear Previous RegData

Post by Alex K. »

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.
fkmfkm
Posts: 181
Joined: Thu Jul 05, 2007 11:26 pm
Location: Kuala Lumpur

Re: Clear Previous RegData

Post by fkmfkm »

It working now !!! the data got cleared after calling

rep.Dictionary.DataStore.Clear()


I must have made some mistake...


Thank you.
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Clear Previous RegData

Post by Alex K. »

Hello,

Thank you for the information.
Post Reply