Solved

"Value does not fall within the expected range" with long CR parameter

Posted on 2008-10-30
8
1,736 Views
Last Modified: 2013-11-26
Using Crystal Reports for .NET with Visual Studio .NET 2003, I'm passing a string parameter that is sometimes more than 254 characters. When it is, CR fails with the error: "Value does not fall within the expected range"

I've seen both here and on CR's web site that this is a known problem. However, I'm having difficulty finding a fix for it, in part because the support site has been totally rewritten since SAP's purchase of BusinessObjects earlier this year. I've downloaded some hotfix files, and was able to install a couple of them (crnet10win_en.zip and crnet11win_en.zip). However, while the version number of the files in C:\Program Files\Common Files\Crystal Decisions\1.1\Managed is now 9.1.9800.x (varies for different DLLs), the version number displayed in the references both for my project and in VS's list of .NET components still shows the original 9.1.5000.0. I've deleted the references from my project and readded them directly from the Managed files, but the version number doesn't change.

And according to other messages here (such as http://www.experts-exchange.com/Database/Reporting_/Crystal_Reports/Q_21692476.html), I need a version number of 9.2.9500.1 to get the fix anyway. However, if I try to run the update cr90devwin_en.zip, it fails when trying to update registry values, which I believe indicates a version mismatch (.NET isn't the same as CR v9).

Any ideas on how to resolve this, short of moving to a newer version of VS or buying CR? Unfortunately, splitting up the data into multiple pieces doesn't resolve my problem, because the parameter could be lengthy (it's a list of files being used, with full path information) and I don't know how much space to allow.
0
Comment
Question by:ElrondCT
  • 4
  • 4
8 Comments
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
You are correct, the .Net version isn't the same as the full version.

Check here for the service packs and hot fixes.
https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/bobj_download/main.htm

You may have to contact SAP/BO to get what you need since I didn't see any for the older versions of Crystal.Net

mlmcc
0
 
LVL 20

Author Comment

by:ElrondCT
Comment Utility
I've gotten all the packs and hotfixes from that location that I can, but it doesn't resolve the situation.

The only way I see to contact SAP/BO for further assistance is by paying for a support incident at $195. If I'm going to pay that much, I might as well pay a few dollars more and get a full-fledged copy of CR. Is there another way to get assistance at lower (or no) cost?
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
Comment Utility
Only at sites like this.  The new SAP site does have a developer forum you might ask there.

mlmcc
0
 
LVL 20

Author Comment

by:ElrondCT
Comment Utility
I've posted a question in SAP's forums, and have gotten no response. I'm not sure if that means no one's paying attention, or there's nothing to offer. Looks like I'll have to figure out some workaround. Since I only need the parameter to print out at one place in the report, I thought about using

            CType(rptOut.ReportDefinition.ReportObjects(strTextObject), _
                CrystalDecisions.CrystalReports.Engine.TextObject).Text = strOutput

to store the value into a text object, but I'm finding that the line breaks I want (between each file name, so each file is on a separate line) are getting converted into spaces, so the text is just running across the line. Any suggestions for an alternative?
0
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
Build your string like

strOutput = "Some FileName" & chr(13) & "Next FileName" & chr(13) & "thirdFileName"

mlmcc
0
 
LVL 20

Author Comment

by:ElrondCT
Comment Utility
I was already putting chr(13) & chr(10) between each line. When I take out the chr(10), I don't even get a blank space between the file names; they just run on. I wondered if the CanGrow property on the text field could be involved, but setting that False gives the same results.
0
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
Is this in the viewer or are you exporting?

Why are you doing the CTYPE?  That may be converting them to spaces.

mlmcc
0
 
LVL 20

Author Comment

by:ElrondCT
Comment Utility
Sorry, I tried to post a response but it looks like it didn't take. The CType is needed because not all ReportObjects have a Text property, so the CType tells VB what kind of ReportObject I'm working with so it doesn't give an error when compiling.

I found that I posted my question on the wrong forum at SAP; there's a specific forum for CR on .NET (which makes a lot of sense), but it wasn't linked to from the CR for .NET portal page. For anyone interested, the proper forum page is https://forums.sdn.sap.com/forum.jspa?forumID=313&start=0

Because it was posted in the wrong place, I didn't get any help. It was moved, but because the post was several days old, it's now buried, so I'm going to repost. But I'll close out here.
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

In my previous two articles we discussed Binary Serialization (http://www.experts-exchange.com/A_4362.html) and XML Serialization (http://www.experts-exchange.com/A_4425.html). In this article we will try to know more about SOAP (Simple Object Acces…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
This video discusses moving either the default database or any database to a new volume.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

771 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

11 Experts available now in Live!

Get 1:1 Help Now