Refresh database mysql di Cristal Report 8.5

Jika anda mengalami Crystal Report tidak otomatis me-refresh data baru yang dimasukkan ke database, mungkin tips berikut bisa anda coba. Awalnya saya juga bingung kenapa Crystal Report 8.5 yang saya gunakan dengan database MySQL dan Visual Basic 6 tidak bisa membaca data baru yang dimasukkan, dan harus me-refresh report nya langsung dari Crystal Report nya. Repot juga kalau tiap kali dimasukkan data baru, harus refresh report nya.
Dan akhirnya setelah Googling, cara berikut saya coba, dan berhasil.

1. Buka Crystal Report, masuk ke File > Option > Reporting > uncheck ‘Save Data With Report‘ > OK.

2. Sekarang tambahkan perintah berikut di Visual Basic nya.

   CrystalReport1.DiscardSavedData = True

   simpan di bagian button untuk mencetak, contoh nya seperti berikut :
   
   view sourceprint

   Private Sub cmdCetak_Click()

   CrystalReport1.ReportFileName = App.Path + "\databarang.rpt"

   CrystalReport1.DiscardSavedData = True

   CrystalReport1.ReplaceSelectionFormula "{pembayaran_calon.no}=" & Adodc3.Recordset!no

   CrystalReport1.Destination = crptToWindow

   CrystalReport1.WindowState = crptMaximized

   CrystalReport1.Action = 1

   End Sub

3. Sekarang report nya berjalan sebagaimana mestinya. Tiap ada data baru, langsung report nya me-refresh.

Licensing Frequently Asked Questions

Q: How is Studio Enterprise licensed?

A: Studio Enterprise is licensed per developer per seat. This is anyone that uses ComponentOne components and controls to create and compile projects in Microsoft’s Visual Studio. If someone wants to work with the code that a component or control has created, they need to have a license.
There are no limits on the distribution of applications – unlimited, royalty-free, run-time distribution.  The licensing only affects design time.

Q: What is the difference between the Subscription and the License?

A: When you purchase the license, you receive a free one year subscription that entitles you to the latest version of the software. The license is perpetual and does not expire, the subscription runs year to year. If you choose not to renew, you can still use the software as is, you just won't have access to the latest version.

Q: What is activation?

A: Activation is used by ComponentOne to verify the authenticity of the product key used to license the software and also to ensure that keys are only used to license an approved number of machines. The activation process does not collect any customer-specific information and protects the end user’s privacy completely.

Q: Since I have a new (28-digit) license key, how do I use an older version of a ComponentOne product?

A: Products are backward-compatible. You can use just the first 17 digits of your serial number to unlock older products. For example, for SE307AC-3G-140062-06-6WNWR1K you would use SE307AC-3G-140062.

Q: What is the difference in the serial numbers?

A: Beginning February 18th, 2008, ComponentOne distributes serial numbers that are 28 characters long. The old ComponentOne serial numbers are 17 characters. The new serial numbers are comprised of an old serial number followed by 11 additional characters. The new serial numbers can still be used with older versions of ComponentOne products, and vice versa.

Q: Can I still license new controls with an old serial number?

A: Yes. As long as your serial number reflects an active subscription, you can enter it into the activation window and successfully license your controls.

Q: I clicked on the "OK" button in the activation window and nothing happened. What do I do?

A: Make sure that the file "C1Licensing.exe" is in your bin folder (for example: C:\Program Files\ComponentOne Studio.Net 2.0\bin) – this should happen by default when you run any ComponentOne installers starting with the 2008 v2 release. If this file is not on your machine, you can obtain the latest version from http://prerelease.componentone.com. If problems persist, please contact the ComponentOne support team. Information on support options can be found here.

Q: I received an error that my serial number is invalid. What should I do?

A: Click on the "About" button for the control you are trying to license and identify the version number. If the control is a 2007 v3 control or earlier, then you should only enter the first 17 characters of your serial number. If it is 2008 v1 or later, you should your full serial number (if your serial number is from 2008 v1 or later it will be 28 characters, otherwise it will be 17). If you are still experiencing problems, please contact your sales representative for assistance. The ComponentOne Sales team can be reached at 1-800-858-2739. Your sales representative can determine if your serial number is valid and help you to get a valid serial number or further assistance if your serial number is valid.

Q: I have an expired license on my machine and my controls did not activate properly. What do I do?

A: Run the license removal tool (files are located here). This will remove the existing license. Once this is done, you can activate your studio by pressing the "Activate" button in the About Box of any ComponentOne control.

Q: The license removal tool did not find any licenses. What do I do next?

A: You will need to manually deactivate your controls. To do this, go into the About box of any .NET 2.0 control, and click “deactivate.” Enter your new license key into the appropriate boxes and click OK.

Q: Is there a limit to the number of activations I can use for a single license?

A: The limit is three (3) machines per license. Allowed installations include any combination of a primary machine (desktop), backup machine (laptop), build machine, or test machine.

Q: Is any personal information collected/submitted during the activation process?

A: No. No personal information is collected.

Q: What happens if I have used all of the activations I am allowed and I need to activate another computer?

A: You can deactivate a computer from the About box of any installed ComponentOne control. The About box will contain a button for "Activate" if the controls are not activated, and will contain a button for "Deactivate" if the controls are activated. Once a computer has been deactivated, you may activate another. If you cannot deactivate any of your current computers, you will need to purchase additional licenses.

Q: I was previously given a multi-year license, what do I do now?

A: You will need to receive a new license key. Please contact your sales representative for assistance. The ComponentOne Sales team can be reached at 1-800-858-2739.

Q: I want to activate products on a machine that does not have an internet connection. What do I do?

A: You can activate by phone, e-mail, or online.  All three processes are described here: https://c1verification.componentone.com/webfiles/. Once you have completed your manual activation, you will receive an Activation Code. Then enter the serial number of your product and the authentication number you received into the Activation Wizard, and complete the process.

Q: If I am redistributing ComponentOne controls in my application, do my users need to use activation?

A: No. Only the developers who are installing ComponentOne controls for use in development projects need to activate their controls.

Q: The activation wizard completed, but activation was not successful! What do I do now?

A: You can activate by phone, e-mail, or online. All three processes are described here: https://c1verification.componentone.com/webfiles/. Once you have completed your manual activation, you will receive an Activation Code. Then enter the serial number of your product and the authentication number you received into the Activation Wizard, and complete the process.

Q: What is the impact of activation on Windows Vista users?

A: Licensing procedures invoked by ComponentOne Studio setups will always request activation so that all controls will be licensed. Running the ComponentOne setup will require Administrative privileges during execution. For Windows Vista operating systems, a prompt requesting Administrative privileges will be given if the Vista UAC is turned on and the process starting the setup program does not already have Administrative privileges.

serial number

3DS Max v3.1 Win9xNT SN : 110-12345678 CD Key : S4ED6W
ACDSee 4.0 Winall.Regged : 654-237-149-322-681-441
ACDSee 4.01 : 148-817-607-012-681-441 / 711-108-595-288-491-441
ACDSee 5.0 : 581-076-451-038-881-441
ACDSee 5.0 PowerPack : 382-936-064-050-881-441
ACDSee 5.0 Standar : 664-828-790-472-030-541
ACDSee 6.0 PowerPack : 147-755-260-960-487-541
ACDSEE V.7.0.43 POWER : 4WBDGK-KVP87-F23BT8-JWRN8P8
ACDSEE 9.0 BUILD 5.5 DYWDLK-PS6C7-W39CLK-GL9TL23
Adobe Illustrator 10 : 1034-1003-4400-0000-1115-2040
Adobe Pagemaker 6.52 : 03W652R3818820-549
Autocad 2000 :Serial : 112-11111111.CD Key : 5X8NUG.
Autocad 2002 :Serial : 400-12345678. CD Key : T4ED6P.
Borland C++ Builder v.4.0 for Windows : Number : 3448. A Key : 86×8-19×0.
COREL Print House 6 = PH06WRD-0020403-WQ
COREL R.A.V.E 2 = RA02WRD- 0001311-CHE
CAKEWALK MEDIAWORK= CWMW1.00-009968
CORELDRAW 10 = D10NR-32542-53T76
CORELDRRAW 11= DR11CRD-0012082-DGW
CORELDRAW 12 = DR12WEX-1504397-KTY
CYBERLINK DVDSUITE PRO V.5 = MS595725518122J4
COREL PRINT HOUSE 6 = PH06WRD-0020403-WQF
DELPHI 5 = 111-111-1111 CODE= FEX1-91X0
DELPHI 6 = Z9J8-PUM4N-C6GZQ CDKEY= RW2-7JW
DELPHI 7 = GAKD-PD29Q9-RDF?JQ-X65Z
CD KEY = QY8.EEC
DELPHI 8 = TIDAK PAKAI
FRUITY LOOPS 4 = PC752-VNVK5-28DKNSYP9V
Flash Cam : C06-122-000
FLASH 5 = FLW500-03143-77238-80660
FLASH 6 = FLW600-11335-72240-33333
FLASH MX = FLW600-53733-75540-61552
FLASH MX 6.0 RETAIL = FLW600-56032-66640-21856
HOY QUR’AN 7,1 = N1A6-N0A9
Hollywood FX Pro : HF559-PRO-807189-75Q
Macromedia director 8.5 = WDW850-02044-87235-26420
MACROMEDIA FREAND 11 = FHW110-02426-47231-55458
MACROMEDIA FIREWORKS 4 = FWW400-02666-67248-0254
MACROMEDIA COLDFUSION MX = CPD600-08480-B7213-22568
Macromedia DreamWeaver 4 : DWW400-03771-57289-73501
MACROMEDIA DREAMWEAVER MX = DWW600-54622-26755-01760
MACROMEDIA FLASH MX = FLW600-09531-57240-83750
MDAEMON SERVER = GDPFFMF-QAWLYFJ-XQDIYAO
MS. OFFICE 97 = 4156-0212207
MS. OFFICE FRONT PAGE = WFDWY-XQXJF-RHRYG-BG7RQ-BBDHM
MS. VISIO PROF 2002 = F8BFX-2B8M6-X373J-TBQ8M-K3C76
MS. VISUAL FOX FRO 8.0 = TCJC7-H2QDH-3T7G7-R6RTM-YRK3Y
Nero Burning Rom v.5044 : 1500-0001-0053-0316-2508-6123
Nero Burning Rom v.5.5.5.1 for WinXP : 1503-0947-6845-2627-4181-1200.
NERO 6 = 1A23-0006-7130-1204-8976-4901
NERO 6.3 = 1A25-0006-7130-1352-4239-7903
NERO 6.6 = 1A25-0006-7130-1827-2429-2198
NERO 7.7.5.1 PREMIUM ED = 1C80-0014-19E5-MA2X-400C-4X27-4A50
OFFICE 2000 = GC6J3-GTQ62-FP876-94FBR-D3DX8 KEY = 1111-1111
OFFICE 2003 = GWH28-DGCMP-P6RC4-6J4MT-3HFDY
OFFICE XP FULL = FM9FY-TMF7Q-KCKCT-V9T29-TBBBG
OFFICE ENTERPRISE 2007 = KGFVY-7733B-8WCK9-KTG64-BC7D8
OMNIPAGE 15 = E709X-KD1-NHXD-QQDF-F8
ORCAD = SCO 021061
ADOBE PREMIER V.7.5 = AB1234565
PINACLE INSTAN-VIDEO ALBUM = 7777777777
PINACLE STUDIO V.8.3 = 1555856630
PHOTOSOP 6 = PWWW600R7105467-948
PHOTOSOP 7 = 1045-0203-3247-2217-3566-6177
PHOTOSOP 8/CS = ANGKA 1 SEMUA
PHOTO IMPACT 7 = 11103-07000-00001531
Power DVD 5.0 : MV588995988G2285
POWER QUEST PARTITON MAGIC V.7.O = PM700ENEU-110965
PARTITION MAGIC 8.01 = M800EN1-11111111/PM800FR1-3193805303
Swif3d 2.0 : T3DW200-65700-95005-88056
Sonic Foundry Video Capture 2.0b : 9H-RBXSQT-YE7GEX-NQW5GX
TRANSTOOL 5 = 100706-27816-08499520-03
TWEAK XP V.20 PRO = E090402963592
Teleport Pro v.1.29.1107 : 787318958
ULEAD COOL 3D STUDIO = 274A5-11085-78578888
ULEAD MEDIA STUDIO PRO 7.0 = 011A2-27042-0190DCN14
ULEAD MOVIE FACORY 2.0 = 111A2-62000-00300082
ULEAD PHOTO IMPACT XL = 111A3-08500-00002098
ULEAD VIDEO STUDIO 7 = RORA2-870RO-ROROROR1
UNIVERSAL TRANSLATOR = EWB3APACDVBGYT2ENZJX
ULEAD PHOTO IMPACT = 11103-07000-00001531S
VCD CUTER V.4.03 RETAIL= 017697-023393
VISUAL BASIC 5.0 = 425-1689004
VISUAL BASIC 6 PROF ED.= 422-1111111
VISIO 2003 = WFDWY-XQXJF-RHRYG-BG7RQ-BBHDM
VISUAL STUDIO ENTERPRISE ED = 807-1426627
VIDEO STUDIO 8 = 111A2-88000-00230680
VIDIO WAVE POWER ED = 75-0R0BN-X89HZ-21DCN
WORLD PERFECT OFFICE = WS12WCX-0203227-XWJ
WinBoost 2001 Gold Edition : 5T5K4-D483-VZ7A-AC4T.
WinBoost 2002 Gold : 5T5K4-D483-VZ7A-AC4T.
WINDOWS 95 = 15695-OEM-0001346-00885
WINDOWS 98 JAPAN = C4GVG-CHRD3-9D12C-BBXHR-3CB76
WINDOWS 98 SECOND RELOADED EDIION SP1.5 =
K4HVD-Q9TJ9-6CRX9-C9G68-RQ2D3
WINDOWS 98 & SE = HQ6K2-QPC42-3HWDM-BF4KJ-W4XWJ
WINDOWS ASIA ED = FCKGW-RHQQ2-YXRXT-8TG6W-2B7Q8
WINDOWS ME = B6BYC-6T7C3-4PXRW-2XKWB-GYV33
WINDOWS 2000 = F6PGG-4YYDJ-3FF3T-R328P-3BXTG
WINDOWS 2000 PROF = RM2333-2PRQQ-FR4RH-JP89H-46QYB
WNDOWS SERVER 2003 = JB88F-WT203-DPXTT-Y8GHG-7YYQY
WNDOWS SERVER 2003 ENT = CW32K-48T2T-3D2PJ-DXBWY-C6WRJ
WINDOWS SEVER 3 IN 1 = JB88F-WT2Q3-DPXTT-Y8GHG-7YYQY
WINDOWS LONGHORN = CKY24-Q8QRH-X3KMR-C6BCY-T847Y
WINDOWS XP HE = GYG6B-HK868-CYF3H-YHQPX-TGCW6
WINDOWS XP SP1A = XP8BF-F8HPF-PY6BX-K24PJ-TWT6M
WINDOWS XP HOME ED = FGJXW-KRTJP-DM2RH-9GQ7T-KYQG8
WINDOWS XP HOME ED OEM 2007 = JQ4T4-8VM63-6WFBK-KTT29-V8966
WINDOWS XP SP1+RUI = XP8BF-F8HPF-PY6BX-K24PJ-TWT6M
WINDOWS XP PROF SP2 = CRTGH-B68P2-XB6JC-44GCD-X9JHM
WINDOWS XP FULLRELEASE = FCKGW-RHQQ2-YXRKT-8TG6W-2B7Q8
WINDOWS XP CORPORATE PLUS = 7QVT6-T2738-WRKJB-YKRFQ-XVK98
WINDOWS XP MEDIA CENTER = XJM6Q-BQ8HW-T6DFB-Y934T-YD4YT
WINDOWS XP MEDIA CENTER 2005 SP2 = C4BH3-P4J7W-9MT6X- PGKC8-J4JTM
WINDOWS XP PRO-SP2 2004 = CRTGH-B68P2-XB6JC-44GCD-X9JHM
WINDOWS XP SP2 GOLD ED = MYHVT-WQ49M-QRPVF-V86FC-P3R8Y
WINDOWS XP PROF SP1A INDONESIA =
62KYQ-3JWQH-WDJBG-D374R-Q8FCW
XPCK2-HY3VB-74KK4-JG6V4-JMDVM
WINDOWS XP ARABIC 2004 = 3FC6J-PVRYV-38KFF-B2K46-CDHH6
WINDOWS XPMEDIA CENTER 2005 =KCQ9Q-FTBM4-6HTWV-M7DKM-T4BF5
WINDOWS XP HOME ED 2006 =RH6M6-7PPK4-YR86H-YFFFX-PW8M8
WINDOWS XP PROF CORP SP2 FEB-SEP2006 =
XP8BF-F8HPF-PY6BX-K24PJ-TWT6M

Sry Novanta

Sry Novanta