I have a SQL-based question. when I run the select statement in my table it shows in one line but when I print it, it comes in multiple rows. because of this when I create SSRS report the data shows in multiple rows.
eg: sql select statement result:
HYDROCARBON CONSTRUCTION CO % L H GUNN PO BOX 53495 HOUSTON TX 77052-3495
but when I print it, it gives results in four rows like below. because of this, I am not getting one line result in SSRS as well.
HYDROCARBON CONSTRUCTION CO
% L H GUNN
PO BOX 53495
HOUSTON TX 77052-3495
it is the address column and I am not able to get this result when I filter by the WHERE clause as well. it shows blank. I want all these multiple rows in one line when I print as well.
It would be appreciated if someone helps me with this.