Drop Down parameter list length in Crystal 9 RAS

[Luego]

I've got the report application server for Crystal Reports 9. So far I'm liking what I've got working. However, I'm having a bit of an issue with the parameters for multiple discrete values. In the crystal designer the parameter will give a drop down list. I'm working with a database field with 500+ unique records (customers). When I try to "define default values" and just pull in that field. It stops short, perhaps at around 40 records (say customers A through C). I can get around that by copying all customer names into a text document and Importing that text document into the "define paramters" applet. After that, reports ran in the designer are just fine.

However, in moving to the RAS I've found that the parameter dropdown selection is limited to maybe 50 records, I didn't count but the listing stops at A or B instead of showing the entire list through Z.

Is there a fix?

BusinessObjects indicates there is a fix for a problem with parameter values cutting off at 255 characters. I don't think this is the problem.

 

[stajalla]

Hi Luego

Did you find a fix or a workaround for this issue yet?

 

[Luego]

Not yet, I have been contact by another person regarding a possible fix, however, both he and I have gotten busy and the project has been pushed aside. I'll include the comments he made and I'll try to remember to post back here if and when I get back to the project.

If you are calling reports directly through the browser, you will have this problem. If you use Crystals ASP page call, you will not.

With the ASP call, you actually use ASP and your DB until you need to pass values to your report, this includes all parameters. Also using the ASP call does not hinder your ablity for extra licenses.

Once the report is called, it should kill that session to the crxdrt.dll. Calling the report directly through the web page will keep that session open until 5 licenses are reached, once that happens you will have to buy more licenses. Even just for your users to view reports. Not design them. Yea, it sucks.

Search their site for ASPXMPS8.exe. This is for version 8, so search for whatever version you're using.