HYPHEN IN CLIENT_ID

[khan007]

Here is the problem.
Running CR 8.5 / Win 2k/ JSP.
I am trying to pass UserID having a hyphen like USer-Id.
The Crystal report viewer does not like or allow the hyphen (-) in ClientID. It's giving me an error windows saying:
The sysntax of @logiduser is incorrect.

Please tell me what do do so the hyphen no longer causes a problem.

Thanks
Really apprecite
Khan

 

[IdoMillet]

Need more detail:

Pass how? As a Parameter?
Data type of parameter?
Syntax of formula?

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[synapsevampire]

Perhaps the parameter is of type numeric?

If you're speaking of passing code within Java, post the code that you're using.

The Active X Viewer does allow for a hyphen, unless of course it's a numeric, boolean or date field, it must bea string. Worse yet, it might even allow for passing through the hyphen and treat it as subtraction in math, so it's a bad idea on that front if it's numeric anyway.

If you get an error stating that a formula has an error, post the formula and any formulas it references, as well as the data types involved.

-k

 

[khan007]

Thanks for the response

I am passing this @loginuser as parameter via URL. It's data type is string.
All Reports based on stored procedures. I have no problem in running at report designer, but on report viewer getting this error while passing parameters via URL.

suppose i have six parameters as:
@start_date
@end_date
@discipline
@reportid
@loginuser
@ipaddress

The syntax of URL is:
cr85/bagota/22222.rpt?user0=MMM&password0=NNN
&Promptonrefresh=0
&Promptex-@start_date="02/01/2005"
&Promptex-@end_date="02/28/2005"
&Promptex-@discipline=All
&Promptex-@reportid=22222
&Promptex-@loginuser=khan-007
&Promptex-@IPAddress=aa
(no spaces in between)

where
bagota is SQL database name
22222.rpt is reportid or report file location
MMM is SQL database login id
and NNN is SQL database password

I am getting problem or error with user login id which is khan-007.

Please inform me, i'll appreciate.
Thanks

 

[dgillz]

Try this:

Promptex-@loginuser='khan-007'

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[khan007]

Thanks a lot.
It worked with double quotes as:
Promptex-@loginuser="khan-007"

Again, Thanks a lot.