Crystal Reports: Large Values 
Author Message
 Crystal Reports: Large Values

Ok, I've used Crystal Reports for about 10 minutes now and I already hate
it. Too much work to pass a value to a parameter.

Anyways, I am forced to use it for this project, but I found out the hard
way that you can only pass 254 characters to a discrete parameter. I have a
textbox with about 400 lines I need to do a report on. Anyone have any ideas
on how I can get that data to the report?

I can't use word or any other remoting method, it needs to be a contained
app.

Thanks!!



Wed, 06 Apr 2005 06:28:37 GMT  
 Crystal Reports: Large Values
I found the same problem some time ago while using CR 8.5 and VB6 when I
tried to pass more than 254 characters to an empty formula I had in my
report. As you can see, formulas and parameters are limited to 254 chars.

The way I found to solve that was to create a subreport. The subreport was
bound to a text file using ADO. Before opening the report from my program, I
rewrote the text file with the string I needed to pass to the formula and
refreshed the datasource and the report. The subreport only consisted of a
field which got data from the text file itself. CR treated that field as a
memo field, so it had no limitations.



Quote:
> Ok, I've used Crystal Reports for about 10 minutes now and I already hate
> it. Too much work to pass a value to a parameter.

> Anyways, I am forced to use it for this project, but I found out the hard
> way that you can only pass 254 characters to a discrete parameter. I have
a
> textbox with about 400 lines I need to do a report on. Anyone have any
ideas
> on how I can get that data to the report?

> I can't use word or any other remoting method, it needs to be a contained
> app.

> Thanks!!



Tue, 26 Apr 2005 01:27:41 GMT  
 Crystal Reports: Large Values
Thanks for the reply!!

Actually, I finally found another way. I couldn't bind my report to a
database (because most of the values were calculated),  so I passed multiple
values to a parameter, then in the Crystal Reports I wrote a small snippet
of code (as a formula) to breakup the array and paste it into the report.

Here is the code I used in the Crystal Reports:

shared x as string:
dim i as number:

for i = 1 to count({?Config})
x=x+{?Config}(i) & chr(13):
next

formula=x

However, my original statement still stands...I find Crystal Reports
cumbersome to use.

Quote:

> I found the same problem some time ago while using CR 8.5 and VB6 when I
> tried to pass more than 254 characters to an empty formula I had in my
> report. As you can see, formulas and parameters are limited to 254 chars.

> The way I found to solve that was to create a subreport. The subreport was
> bound to a text file using ADO. Before opening the report from my program,
I
> rewrote the text file with the string I needed to pass to the formula and
> refreshed the datasource and the report. The subreport only consisted of a
> field which got data from the text file itself. CR treated that field as a
> memo field, so it had no limitations.



> > Ok, I've used Crystal Reports for about 10 minutes now and I already
hate
> > it. Too much work to pass a value to a parameter.

> > Anyways, I am forced to use it for this project, but I found out the
hard
> > way that you can only pass 254 characters to a discrete parameter. I
have
> a
> > textbox with about 400 lines I need to do a report on. Anyone have any
> ideas
> > on how I can get that data to the report?

> > I can't use word or any other remoting method, it needs to be a
contained
> > app.

> > Thanks!!



Tue, 26 Apr 2005 01:32:41 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Need help printing LARGE reports with vb3.0 and Crystal Reports

2. Need help printing LARGE reports with VB3.0 and Crystal Reports 4.5

3. Crystal Reports 3/VB4 Field too large?!!!

4. Crystal Reports 8.5 Truncates Varchar fields larger then 255 characters

5. About Crystal Reports (large explain)

6. Need Idea for Crystal Reports over a large company WAN

7. Crystal Report and large scale archiving

8. Crystal Report Pro shows only 130 fields in large table

9. Crystal Crashes on Large Reports

10. Printing Crystal Reports without Crystal Control ActiveX or Crystal Reports API call

11. Set the parameter value in Crystal Reports

12. Passing value to Crystal report

 

 
Powered by phpBB® Forum Software