I have a numeric field that I am calling in from an access backend. If the length of the field is less than 6 digits, I want it padded with 0 at the front => as a leading zero/s.
How do I implement it in crystal report?
eg: 2567
I want it displayed as 002567
If I concatenate it as string the number gets converted with , and .00 formats => 002,567.00
try using format(variable,"######")
My application is a vb application and I am using Crystal report 8.5. It is working fine on 32 bit system
and 64 bit system of Windows 2003 server. When I run the same application either on win7 64 bit or on 2008
64 bit, report does not open.
I am using vb script to access the database.
Part of the code written in the VB script file is as follows:
`Dim objrsRecordSet 'As RecordSet
Dim strSQL 'As String
'**** Open Database Connection using the parameters passed from the main program
Set dbConnection = CreateObject("ADODB.Connection")
dbConnection.ConnectionString = "Provider=SQLOLEDB;Server=" & mstrServer & ";uid=" & mstrUserName _
& ";pwd=" & mstrPassword & ";Database=" & mstrDatabase & ";"
dbConnection.Open
dbConnection.CommandTimeout = 200
dbConnection.Properties("Enable Fastload").Value = True'
When i run my application in debug mode it is working fine on windows 7 also. But when i run the application
through the set up by consuming the dll of crystal report then it is not working, in this case report is not opening.
Guys please help me out with this issue, i will appreciate for your response.
Add a formula field then format the value :)
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.