Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SQL Expression field in Crystal 10.0
Thanks for your response Gordon. I tried this: SELECT A."pract_rpt_name" FROM "SMSPHdssc4z0"."smsdss"."pract_dim" A, "SMSPHdssc4z0"."smsdss"."pms_vst_fct" B WHERE B."prim_pract_no_key"=A."pract_key" Still got the same error. What I tried after that was ljoining the same table pract_dim...- area4486
- Post #3
- Forum: Business Objects: Crystal Reports 1 Formulas
-
SQL Expression field in Crystal 10.0
Hi all, if anyone can help with this one, I will really appreciate it: I'm using Crystal 10.0 and need to add a sql expression field to my report, the expression is like this: SELECT "SMSPHdssc4z0"."smsdss"."pract_dim"."pract_rpt_name" FROM "SMSPHdssc4z0"."smsdss"."pract_dim" A WHERE...- area4486
- Thread
- Replies: 3
- Forum: Business Objects: Crystal Reports 1 Formulas
-
How to narrow the bar code?
I'm done with this project already. Anyway, yes the 10 and 30 were modified in order to print the bars in a proportional scale (my labels are very small). Thanks all for helping. -
How to narrow the bar code?
That's the data I need to present in bar code. I place it right before the field. -
Sorting of Grouping
I guess there is an icon on the menu bar that allows you to edit the sql script, there you can condition the result to order by 'field name' asc or desc.- area4486
- Post #7
- Forum: Business Objects: Crystal Reports 1 Formulas
-
How to narrow the bar code?
Remember that my initial question was how to narrow the bars. Well, #,#b#,#s for bars and whites means what I quoted above: #,#b as in 10,30b Thin bars are 10 dots wide, thick bars are 30 dots wide #,#s 10,30s Thin spaces are 10 dots wide, thick spaces are 30 dots wide That's how we should... -
How to narrow the bar code?
The sequence DansDad explains is working for me when I want to print human readable text e.g. "Bank Name: XYZ" Now, to print the customer account number as scanner readable text(or bar code), I have to use #,#b#,#s for bars and whites width -at least with this chip-. Yes you may be right, it... -
How to narrow the bar code?
Hi all, I stopped playing with 'h' and 'v' since it wasn't giving me the results I was looking for. Jim you had a point, I'm using DIMM. I checked a DIMM manual and they use different parameters to modify non human readable text (bars). This is the explanation I found: A valid PCL escape... -
How to narrow the bar code?
It isn't working Webrabbit, but the problem resides in my environment. I am new around here and learned that someone else was trying to condense the bar code and they couldn't. Jim I'm printing my test document in an HP LJ 4050, yet this document will print in a variety of 4 or 5 printers (all... -
How to narrow the bar code?
Thanks Jlasman and Webrabbit for taking time to discuss my question. As I said before, I am totaly new with PCL. I'm working with CICS and need to print in very small labels. Yes Jim you are right, the value before the h determines how tall the bar displays. I tried that before. Yet, my problem... -
How to narrow the bar code?
Hi, I'm new with PCL. I'm printing in small labels and even though it's been scanned correctly, the user wants to have enough blank space before and after the bar code prints in each label. The font setting before the bar code print is: ¬(s0p06h09v24700T I changed it to ¬(s0p04h07v24700T but...
