My Personal Blog's
Crystal Report
Connecting Crystal Report ASP.NET using Dataset
Jun 5th
Do you have so many problems with user logon database when you try to connecting asp.net to crystal report using SQL Server 2005 store procedure or table.
By using dataset, you dont have to worries about connection to sql server in crystal report.
First, you need to add or create new item of dataset object. Dataset object format as .xsd
Inside the dataset object, right click and add new datatable, after that right click on datatable and add column.
You can set the datatype as well.
Read the rest of this entry »
Function Terbilang (Number to text) in Indonesian Language using crystal report
May 26th
After googling the net to find anyone who post on how to create function Terbilang in crystal report, finally I found one site thats really works.
The original source is from here:
Read the rest of this entry »
Error when click refresh in crystalreportviewer
Feb 28th
Refresh Button
currently using visual studio.net 2005 vb.net.
As you know that visual studio provide crystalreportviewer as well when we installed it.
But there is a problem with the refresh button in crystalreportviewer. This button suppose to work as a refresing data in crystalreportviewer when there is an update data without any coding behined. When I click this button, it shows error msg that makes the program hang crap shit. Panic happen, what in the red hell is going on with this shit. This thing supposed to work automatically cos its embedded in the viewer.
I can’t remember what version is the crystalreportviewer installed. But for some version this thing does not happen. But most of my friends encounter this problem, they just dont realize until I asked them to check it hihihihihihi.
There are 2 solution for this problem:
1. Add parameter value in your report, when the refresh button click, send different value from the previous value. For example previous value is 1 then after click refresh send 2. This will refresh the value, although this value is only dummy data.
2. Is more nice one hehehhe, add this code in ReportRefresh event:
Private Sub CrReportViewer_ReportRefresh(ByVal source As Object, ByVal e As CrystalDecisions.Windows.Forms.ViewerEventArgs) Handles CrReportViewer.ReportRefresh Dim rpt As Object e.Handled = True rpt = Me.CrReportViewer.ReportSource CrReportViewer.ReportSource = Nothing CrReportViewer.ParameterFieldInfo = rpt.ParameterFields rpt.Refresh() CrReportViewer.ReportSource = rpt End Sub
and walla, it works daaaa. So I assume this is bugs from some of version crystalreportviewer
