Solved

crystal report with barcode installed inconsistent

Posted on 2009-07-09
6
625 Views
Last Modified: 2012-05-07
I have 2 similar reports that use idautomation barcode font 128a in a formula field.  The field is mapped to a sql field in the report database.  The reports are embedded in designer in vb6 applications.

Report1 has no issues running on any machine as long as the fonts are installed.  Report2 runs on 2 of 6 machines I've tested.  On the other 2 I am getting the crystal report error "remaining text does not appear to be part of the formula" when it tries to open the report on 2 XP machines, 1 of these a brand new machine.  Both of these machines can run Report1 without error.

The error is tracked to the formula field for the error.  When I remove the formula, there is no error.

I have tried re-registering the CRUFLHD.dll, downloading and installing a new copy of the old version, and downloading and installing the latest version.  No help.

It makes no sense to me why the same machine can one report with the same formula field and barcode font, but not crash on the barcode formula field on the other.

 
0
Comment
Question by:Delta7428
  • 4
  • 2
6 Comments
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
What version of Crystal?

mlmcc
0
 

Author Comment

by:Delta7428
Comment Utility
Crystal 8.0
0
 

Author Comment

by:Delta7428
Comment Utility
I've decided to try converting the report to crystal in VS 2008.  I can't get the report to load.  I downloaded IDAutomation.NetAssembly.dll and added a reference to my project.
I'm not sure what to do next.

The text field on the CR8 report is formatted:  IDAutomationFontEncoderCode128a ({table1.field1})
I changed it according to the format I found on idautomation's site:
FontEncoder.Code128(txtDataToEncode.Text)

http://www.idautomation.com/fonts/tools/dotnet-assembly/

Any body?
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
I haven't used the .Net versions so I don't know.

mlmcc
0
 

Author Comment

by:Delta7428
Comment Utility
Converting to .Net right now is not my preference.  It's not just a matter of converting the report, I'd have to recode the entire application.  So if you come up with anything ...  I've tried everything imaginable to me, including:
1) Formatting a hardcoded string in place of the field.
2) Creating a new report.
3) Making a copy of the report that will run and modifying it with the different tables required for the report that won't work.
4) Modifying the datatype (the barcode field on working report is varchar, the other is nvarchar)
5) Creating a new project.
6) Saving the .dsr report to an rpt. and replacing the .dsr with the new rpt
7) The dll stuff I mentioned in my original post
8) Creating a blank report with just 1 string formatted to a barcode

There's probably more I could add to the list if I thought real hard.  This seems to be a dead end and might be the first issue I've had to wave the white flag to in the 4 years I've been in my present job.  :( I'm thinking there's some dll conflict somewhere.  We've had glitches pop up on other CR 8 reports due to Microsoft upgrades and loss of support there.  i.e, It's not longer possible on an XP machine to export a CR8 report to an RTF without making registry changes.
0
 

Accepted Solution

by:
Delta7428 earned 0 total points
Comment Utility
This is mysteriously working.

Each app that kicked off report1 and report2, retrieved and sent the report paramers in different ways.  The parameter was the string part of the bar code formula.  The report that wouldn't work was looping through selected row(s) on a grid and sending a column value it to the report as a parameter and running the report multiple times, potentially, if more than one row was selected.  I doubt any user is selecting more than 1 row.   After taking the loop out and just sending the column value of the current row as a parm it started working ... BUT after running it a few times, it started getting the error again.

I got the vs2008 version of the crystal report working as a stand alone report in an exe. After I installed it on the machine that was getting the error on the cr8 report, it starting working consistently, as of the last 3 days anyway.

I'll award points for anyone that might have some relevant input or guess as WHY IS IT WORKING NOW?!!
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Introduction As chip makers focus on adding processor cores over increasing clock speed, developers need to utilize the features of modern CPUs.  One of the ways we can do this is by implementing parallel algorithms in our software.   One recent…
It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This video discusses moving either the default database or any database to a new volume.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now