Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
amitkumarmadhukar
Starting Member
45 Posts |
 Posted - 2004-07-30 : 10:14:15
|
| Hello Dears,I m again here with some brusty Question regarding me.I Developed a software where Printer is used through Code directly( an online printer) i have a problemi am using code of line " Printer.Print Space(10);Value1;Space(10);Value2;Space(10);Value3" i a grid like design , problem is that the length of variable Value1..Value 3 is not fixed so the space between columns become imporper. i want in some allignment wheather value is of full length or not present like reports designed with Data Reports in VB6 or Crystal Report in VB5 of VB.Neti Want this type of Records+---------------------+--------------------+--------------------+ Name of Employee Address Phone+---------------------+--------------------+--------------------+ amit kumar India 11111111111111 MAC Kumar and Sons India,Asia 1111 Sumit Kumar Australia 88888788788887888888+----------------------+--------------------+-------------------+but it currently is produces result as follows:- +---------------------+--------------------+--------------------+ Name of Employee Address Phone+---------------------+--------------------+--------------------+ amit kumar India 11111111111111 MAC Kumar and SonsIndia,Asia 1111 Sumit Kumar Australia 88888788788887888888+----------------------+--------------------+-------------------+ Please Help meamit kumar madhukar |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2004-07-30 : 14:34:30
|
| Format your output of values by using things like:Left(value1, 50) to set it to fixed length.-----------------------------------------------------Words of Wisdom from AjarnMark, owner of Infoneering |
 |
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2004-07-31 : 03:44:54
|
| Actually that needs to be Left(value1 + Space(100), 100)OS |
|
|
|
|
|
|
Printer Configuration in VB