Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Crystal reports 11 on windows 7 64 bits Post Reply Post New Topic
Author Message
h.v.grimbergen
Newbie
Newbie


Joined: 13 Aug 2012
Location: Netherlands
Online Status: Offline
Posts: 1
Quote h.v.grimbergen Replybullet Topic: Crystal reports 11 on windows 7 64 bits
     Posted: 13 Aug 2012 at 9:25pm
Hello,

I have a problem regarding Crystal reports 11 on windows 7 64 bits. We have some reports designed many years ago using bardcodes (azalea barcodeI2of5) which is working fine in Windows XP. Now we have installed crystal reports on an windows 7 64 bits PC where we have a problem which is very wierd.

When starting CR en selecting the report al is fine in design and view mode. We can see the barcodes without any problem. After refreshing the parameters (getting new data from the database) al the barcode fields are empty.

I have already seen that this is not an font problem with the azalea software. I think the problem is that the formula I use is the problem, testing several possibilities:

1. When using BarcodeI2of5('12345') the barcode is printing.

2. When using BarcodeI2of5({@Barcode01}[1]+' '+@Barcode01}[2]+' '+@Barcode01}[3]+' '+@Barcode01}[4]+' '+@Barcode01}[5]) then I got an empty field

@Barcode01:
{@Kundenkennung}+ToText ({@CntrGtl03},0)

@CntrGtl03
IF ({@CntrGtl01}-{@CntrGtl02}=10) THEN 0 ELSE ({@CntrGtl01}-{@CntrGtl02})

@CntrGtl01
(Int(((
((ToNumber({@Kundenkennung}[11])+ToNumber({@Kundenkennung}[9])+ToNumber({@Kundenkennung}[7])+ToNumber({@Kundenkennung}[5])+ToNumber({@Kundenkennung}[3])+ToNumber({@Kundenkennung}[1]))*4)+
((ToNumber({@Kundenkennung}[10])+ToNumber({@Kundenkennung}[8])+ToNumber({@Kundenkennung}[6])+ToNumber({@Kundenkennung}[4])+ToNumber({@Kundenkennung}[2]))*9))/10)+1)*10)

@CntrGtl02
((ToNumber({@Kundenkennung}[11])+ToNumber({@Kundenkennung}[9])+ToNumber({@Kundenkennung}[7])+ToNumber({@Kundenkennung}[5])+ToNumber({@Kundenkennung}[3])+ToNumber({@Kundenkennung}[1]))*4)+
((ToNumber({@Kundenkennung}[10])+ToNumber({@Kundenkennung}[8])+ToNumber({@Kundenkennung}[6])+ToNumber({@Kundenkennung}[4])+ToNumber({@Kundenkennung}[2]))*9)

@Kundenkennung
'94166'+({@Pakbonnr}[2]+{@Pakbonnr}[3]+{@Pakbonnr}[4]+{@Pakbonnr}[5]+{@Pakbonnr}[6]+{@Pakbonnr}[7])

@Pakbonnr
If (Length (TrimLeft ({orhkrg.pakbon_nr}))=2) then ('00000'+TrimLeft ({orhkrg.pakbon_nr})) else
If (Length (TrimLeft ({orhkrg.pakbon_nr}))=3) then ('0000'+TrimLeft ({orhkrg.pakbon_nr})) else
If (Length (TrimLeft ({orhkrg.pakbon_nr}))=4) then ('000'+TrimLeft ({orhkrg.pakbon_nr})) else
If (Length (TrimLeft ({orhkrg.pakbon_nr}))=5) then ('00'+TrimLeft ({orhkrg.pakbon_nr})) else
If (Length (TrimLeft ({orhkrg.pakbon_nr}))=6) then ('0'+TrimLeft ({orhkrg.pakbon_nr})) else
If (Length (TrimLeft ({orhkrg.pakbon_nr}))=7) then (TrimLeft ({orhkrg.pakbon_nr}))



It is going wrong on the windows 7 64 bits only.

With regards,
H.v.grimbergen

Edited by h.v.grimbergen - 13 Aug 2012 at 9:28pm
IP IP Logged
naga6303
Newbie
Newbie
Avatar

Joined: 13 Aug 2012
Location: India
Online Status: Offline
Posts: 16
Quote naga6303 Replybullet Posted: 15 Aug 2012 at 8:02am
Hi,
 
Did you able to refresh the report in Windows 7 machine?
 
if not please create a 32 bit ODBC connection for the report and test the issue.
 
Regards,
Naga.
IP IP Logged
money
Newbie
Newbie


Joined: 26 Mar 2012
Online Status: Offline
Posts: 3
Quote money Replybullet Posted: 30 Aug 2012 at 10:15pm
Hope you find solution here: Barcode Generator in Crystal Reports Tutorial
IP IP Logged
jamesjim882
Newbie
Newbie


Joined: 03 Jan 2013
Online Status: Offline
Posts: 4
Quote jamesjim882 Replybullet Posted: 27 Jan 2013 at 9:12pm
Hope you could find a solution to your question in Barcode Generate SDK for Crystal Report
IP IP Logged
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum