Showing posts with label Crystal Report. Show all posts
Showing posts with label Crystal Report. Show all posts

Thursday, December 24, 2009

How do automatic sequence number in Crystal Report (Visual Basic 2008)


(Thai Version)
A sequence of numbers we found in numerous reports in daily life. We see how the number sequences automatically in the report in Crystal Report.
Step
1. Open or create a report to report.
2. Field Explorer, right-click "Running Total Fieids" - New



3. Configuration.
3.1 Select Field to set (number 1).
3.2 Click to select Custom Field values (number 2).
3.3 Select "Type of summary" to set (number 3).
3.4 Set "Evaluate"  (number 4).
3.5 Set "Reset" (number 5).
3.6 Click OK. 
 

4. Drag the Field to the area to the report.
 


5. Testing program will work as needed.



Applied to the report.



Thank you,
Worawut  Bunwang

Saturday, December 19, 2009

Code does not ask Login ID and Password in the Crystal Report (Visual Basic 2008)

 
Programmers to develop applications with Crystal Report would have a problem ask the Login ID and Password while processing program before opening the report.
We see the sample code to solve the problem, ask to not reporting hours.

The code to solve the problem.

Variables in the code.

strServernameRpt = name server connection

strDatabaseNameRpt = name database

strUserNameRpt = username

strPasswordRpt = password


When the test program again. Program Login ID and Password do not ask anymore.

Thank you,
Worawut  Bunwang