Last post Mar 27, 2015 05:12 AM by Edwin Guru Singh
None
0 Points
1 Post
Mar 15, 2015 10:23 AM|shabuj|LINK
I am creating report in ASP.NET using crystal report, could you please help me out to remove the blank field between two columns data.ut
I am getting data like below:
But I need to get this data like below:
Star
8544 Points
1376 Posts
Mar 27, 2015 05:12 AM|Edwin Guru Singh|LINK
Hi shabuj, As per your case, I have shared my ideas below :
1.Replace the blank space like below :
replace({table.LeftPosition}, chr(10), "") replace({table.RightPosition}, chr(10), "")
2.right click on the formula and go to format field and enable the option can grow
3.Otherwise Manually shrink the those text field size.
4.If you retrieve the data from sqlserver database then you can trim there itself like below
Select MachineID,MachineName, REplace(LeftPosition,' ','')[LeftPosition], REplace(RightPosition,' ','')[RightPosition] from tableName
Hopefully this will be helpful for you. - with regards, Edwin
None
0 Points
1 Post
How to remove blank fields
Mar 15, 2015 10:23 AM|shabuj|LINK
I am creating report in ASP.NET using crystal report, could you please help me out to remove the blank field between two columns data.ut
I am getting data like below:
But I need to get this data like below:
Star
8544 Points
1376 Posts
Re: How to remove blank fields
Mar 27, 2015 05:12 AM|Edwin Guru Singh|LINK
Hi shabuj,
As per your case, I have shared my ideas below :
1.Replace the blank space like below :
2.right click on the formula and go to format field and enable the option can grow
3.Otherwise Manually shrink the those text field size.
4.If you retrieve the data from sqlserver database then you can trim there itself like below
Hopefully this will be helpful for you.
-
with regards,
Edwin
Edwin