Saturday, April 10, 2010

Crystal Report: Image did not reflected in report

There's this incident where a report is developed which retrieve the image from oracle database. The code are all looks fine but the image just did not get refreshed, in other words, not grabbing the latest image from database.

Playing around with crystal reports function which leads us to the setting of "save data with report". Once we uncheck the setting and the image was fetching from database.

Thursday, December 17, 2009

Dynamic page number

Found this code snippet which is quite useful if you're allowing dynamic configurable page length:

intOldPageLength = GetPageLengthValue()

' if there is a new page length value
If intOldPageLength <> m_intPageLength Then

' adjust the page number to compensate
intItemCount = ((m_intPage - 1) * intOldPageLength) + 1
m_intPage = intItemCount \ m_intPageLength
If intItemCount - (m_intPage * m_intPageLength) > 0 Then
m_intPage = m_intPage + 1
End If

End If

Friday, November 13, 2009

Generate Crystal Report Error: 0x800003E5 Failed to open report

This happened when there is an attempt to generate the crystal report. It occurs during the loading of crreportdocument.load. It didn't include any further leads but only the function that triggers the error. This makes me wonder what causes the above stated problem.

I searched around in the usual engine, Google. Few possibilities, and funny thing is, one indicated that the memory has problem (which was what my colleague found). Due to the details of the error given, I drilled down and pick up the suggestion to reset the IIS. After reseting, attempt to access the report success. This further justify that the error is most probably due to the memory resource which has been fully utilized, that exceeds the allocated space.

I recalled, there is somewhere in the article that I read mentioned that when the number of reportdocument object is declared without disposing would generates error. This is most probably the closest reason of such error occured in my situation.

Further checking, the programmer who coded the page that executes the reportdocument did not close, dispose and collect GC. This indeed makes the suspect even stronger.

As changes toward the code would require some time, two steps were taken:

1. to continuously embed the clean up function code once the code has finished its' execution.
2. as step 1 takes time, to avoid any possibility reoccurence, scheduled "IISRESET" command to execute every midnight. This certainly is not a wise approach, but in this situation, the web application or IIS as whole is not accessible by anyone during midnight thus, it is safe to reset it to ensure the reportdocument is dispose off cleanly.


Tuesday, September 22, 2009

Mafia wars and Texas Holdem Poker hacks or cracks

I always wonder, does all game have their crack? Unlike those days, those games that I played have cracks circulated around the net. To name a few, the Grand theft auto and starcraft or age of empire. Those are I believe more of like the infamous "easter eggs" where the hacks itself is coded in the game for the gamer to find out. I believe it makes the game more interesting. How bout those games in facebook? There are plenty of flash games integrated in facebook. The famous Zynga have already produced few games and some of them are mafia wars, texas holdem poker, farmville and many more. Are there any cracks or hacks underneath?

I would think there wont be any intention cracks due to the fact that there is "monetary" object involve in the progression of the game. But, whether there is exploitable bugs in the game is still questionable....

Tuesday, July 14, 2009

Receiving Gmails or 3rd Party email on your hotmail account

Most of us, who surfs internet, have few different emails account. I am, proudly, one of them. I have few emails account to separate its' usage on different purposes. One of account is being used to communicate with friends, while others for different matters.

Thumbs up to Microsoft Live Mail's team. Another great move. Hotmail now allows other emails account to be setup for retrieving and sending mails. This can be solely done on one of your hotmail account. Once you have configured the correct credential, you will be able to choose to download the emails to a new folder or existing inbox folder.

One of the account that I owned, but seldomly used, is this gmail account. I configured the account to forward any incoming emails to my hotmail accounts where I frequently logon (through my msn, where I can see new coming mails through the popup messenger's notice window). I have been rather satisfy with this approach thus far and no complaints with it. But with this new feature incorporated in Hotmail, it's awesome. I can even send email using that email's account. I dont need to logout Hotmail and login Gmail to reply any correspondent shall there be any.

I guess, I am more in love with Hotmail (or Live's mail).

P/S: One the side note, I still think Yahoo! mail sucks. They need us to subscribe to their paid service in order to get the mails to;
1. use POP/SMTP service
2. use forwarding mail feature

Seriously, with so much intense competition from others competitor, why don't they loosen those feature?

Your Ad Here