Monthly Archives: February 2011

Pengiriman Parameter Fastreport dari Visual Basic 6.0

Fastreport merupakan pilihan lain pembuatan laporan selain crystal report. Salah satu yang sering ditemui dalam pembuatan laporan adalah adanya parameter untuk memfilter data yang akan ditampilkan oleh laporan.

Bagaimana mengirim parameter fastreport dari visual basic?

Silakan baca tutorialnya dalam bentuk pdf yang sudah diupload di scribd. atau

Dalam dalam bentuk .rar termasuk source codenya di indowebster.

Jika ada pertanyaan mengenai password, gunakan :

Setup Factory

Setup Factory is the result of over a decade of experience in creating software installation tools. Unlike other installer builders that require week-long training courses in order to get up to speed, Setup Factory was designed to be fast and easy to use. By pairing a visual layout of your softwares files and folders with a point-and-click interface, the entire process becomes completely logical and absolutely painless. Whats more, Setup Factory creates a compact, single-file setup.exe that runs on any version of Windows from 95 to Vista and is perfect for distribution by web download, CD-ROM, DVD-ROM and LAN. With Setup Factory, you simply drag and drop your files onto the project window, and click on the publish button. Thats it. Its really that simple. Youll be up and running in minutes. The Project Wizard can even walk you through it. Whether you want to create shortcut icons on the desktop and start menu, or configure an uninstaller in the control panels Add/Remove Programs panel, its all just a few clicks away. The same thing goes for adding in third-party runtime modules, with support for Visual Basic, .NET and more.

Setup Factory Product Features:
Install Any FileAnywhere!
Compact Single-File Setups
Flexible Uninstaller
System Requirements Checking
NEW! Support for Files Larger Than 2GB
Serial Numbers, Security and Access Features
Packages, Categories and Install Types
Dependency Modules & Runtime Support
NEW! Latest Technologies
International Language Support
NEW! LZMA Data Compression
NEW! Automatic Authenticode Signing
Install Wizard Screens
Themes and Skins
NEW! Visual Dialog Editor
Background Window Options
NEW! Custom Setup Icon and Version Resource Info
Powerful Scripting Engine
Extensive Action Library
Fill-in-the-Blanks Style Action Wizard
Color Syntax Highlighting Action Editor
NEW! Stand Alone Script Editor
NEW! Extensive MSI Action Library
Expandable with Action Plugins
NEW! Custom Error Handling Events
NEW! More Script Actions than Ever
Built-in Spelling Checker
Reports and Logs
Silent Installs
Visual Basic Project Scanner
Unattended Builds
NEW! Plays Well with Source Control
Works with Windows 95 through Windows 7
NEW! Updated for Windows 7, Vista, XP, Server 2003 and Server 2008
NEW! 64 Bit Windows February 2, 2011
Fix: Updated the IRScriptEditor to version 2.0.1000 which contains Lua 5.1 syntax checking.
Fix: Fixed a bug where the DlgListBox.GetItemProperties action could not retrieve the ItemData properly.
Fix: Fixed a bug where the ComboBox control could lose its item data leaving a screen and then returning to it.
Fix: Added syntax support to the code editor for new Lua 5.1 operators.

Link 1 or Link 2

Error Fastreport berparameter – Visual Basic 6

~ Error Fastreport berparameter – Visual Basic 6 ~

langsung aje gue curhat…

awalnya gue biasa pake crystal report pada aplikasi yang gue bikin. tapi setelah kenal ama fastreport, gue jadi jatuh hati pada dia..

hmm, sampe gue ketemu error saat gue manggil report yang berparameter. padahal kalo manggil yang biasa tanpa parameter lancar aje kaga ada masalah.. tp kl gue kasih parameter baru muncul error ampe aplikasi vb’nya pun berakhir..

setelah gue lakukan uji coba ternyata masalahnya gara” variable untuk paramter yang ada di vb. seolah” masih gantung, sehingga saat report yang berparamter itu ditutup yang harusnya kembali ke vb, malahan vbnya yang ikut ke close (sebelumnya muncul warning error).

solusinya, bebaskan / free`kan dulu variable yang digunakan dalam parsing parameter ke fastreport dengan cara di set ke `nothing`.

untuk pemanggilan paramter kurang lebih :

report.LoadReportFromFile (“nama_file.fr3”)
Set Query = report.FindObjectEx(“nama_query_table”)
Set Param = Query.ParamByName(“nama_parameter”)
If Param Is Nothing Then return
Param.Expression = “value_parameter”

kalo hanya itu akan terjadi error (khususnya di aplikasi yang gue buat), solusinya:

report.LoadReportFromFile (“nama_file.fr3”)
Set Query = report.FindObjectEx(“nama_query_table”)
Set Param = Query.ParamByName(“nama_parameter”)
If Param Is Nothing Then return
Param.Expression = “value_parameter”
Set Param = Nothing
Set Query = Nothing


Setelah gue tambahkan baris yang gue bold, kaga muncul lagi errornye 😉

semoga bermanfaat..