Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
Solved

# Crystal Reports "Too many arguments have been given to this function" error

Posted on 2011-03-15
Medium Priority
3,386 Views
I try to insert this as part of string =>
crBold(ToText(Date({MyProcl;1 MyDate})))

Something like
"You have to come her by " + crBold(ToText(Date({MyProcl;1 MyDate})))

When I do this.. I get en error like:

0
Question by:kmc10314
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 4

Expert Comment

ID: 35137888
wht is the error?
0

LVL 77

Expert Comment

ID: 35138227
1.  crBold is not a function so can't be used this way.

2.  Is this the syntax that crystal gives you when you select a field?
{MyProcl;1 MyDate}

I'm not familiar with the use of  ; as the separator.

3.  What is the datatype of {MyProcl;1 MyDate}?
0

Author Comment

ID: 35138445
1. How should I use crBold?
2. Yes, it's a field (Name of Stored Proc: Field in a Stored Proc)
3. It probably is DateTime, but I want to change it to Date
0

LVL 101

Accepted Solution

mlmcc earned 2000 total points
ID: 35138515
crBold is a Crystal enumerated type value and is used in formulas that specify the font weight.

THere are 2 ways to do what you want.

1.  Using a text box with multiple fields
Insert a text box in the report
Add a formula to the report for the first part of  the line
"You have to come her by "
Add another formula for the date
ToText(Date({MyProcl;1 MyDate}))
Drag the formulas into the text box
You can then edit the textbox and format the pieces as desired.

2.  Use text interpretation on the display of the formula
Change the formula to
"You have to come her by <b>" & ToText(Date({MyProcl;1 MyDate})) & "</b>"
Drag the formula to the rreport
Right click the formula
Click FORMAT FROMULA
On the COMMON TAB set the Text Interpretation to HTML

mlmcc

0

Author Comment

ID: 35138942
I want to have it one formula instead of several textboxes because i actually have a lot of lines,

So when i did second method I get an error like
"a statement is required here"
0

LVL 101

Expert Comment

ID: 35139159
What is highlighted by the error?

mlmcc
0

Author Comment

ID: 35139314
"You have to come her by "
0

LVL 101

Expert Comment

ID: 35139408
Are you using Crystal or Basic format?

If basic it has to be

Formula =  "You have to come her by <b>" & ToText(Date({MyProcl;1 MyDate})) & "</b>"

mlmcc
0

Author Comment

ID: 35139588
I get an error like this now...
) is missing
I know i don't have a parenthesis missing
0

LVL 101

Expert Comment

ID: 35140643
Can you paste the actual formula into a comment?

mlmcc
0

Author Comment

ID: 35141574
"Make a payment" + {Payment;1.PaymentDate} + "and pay" + ToText(SUM({Payment;1.Total}) - SUM({Payment;1.Discount})) + CHR(13) +
"Discount: " + ToText(SUM({Payment;1.Discount})) + CHR(13) +
"By " + {Payment;1.DueDate} + " , it's " + ToText(SUM({Payment;1.Total}))
0

LVL 101

Expert Comment

ID: 35143503
I pasted that into one of my reports and changed the fields so the sums would work and got no errors.

Is that the full formula?

Are you using Crystal or Basic syntax?

mlmcc
0

Author Comment

ID: 35147909
It is.
Right now i'm using Crystal syntax.
However, if I were to change it to HTML, would some work?

Can you show me what you did?

0

Author Comment

ID: 35148051
Hmm... it works as you suggested.
Thanks
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirementsâ€¦
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 biâ€¦
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastrâ€¦
Weâ€™ve all felt that sense of false security beforeâ€”locking down external access to a database or component and feeling like weâ€™ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many wâ€¦
###### Suggested Courses
Course of the Month11 days, 6 hours left to enroll