Im using SQL Server 2005 with Reporting Services;
The problem is that the report will display a blank block of test if the proper conditions are not met-
The problem fields are address1 and address2-and the concatenation of each;
I dont think Im building the string correctly.
Both address1 and address2 are not required so they could be blank
Address1 is a field directly from the database;
Address2 is a concatenation of the database fields: City, State and Zip;
And I wanted a new field, addressb, to be the concatenation of address1 and address2.
Attached below is the section of the sql query in question;
I need this data for the report.
And one of these fields must be returning a blank but I can pin down which one...
coalesce(b.address1,'') + ' ' + coalesce(b.city,'') + ' ' +
coalesce(b.state,'') + ' ' + coalesce(b.zip,'') AS addressb,
ISNULL(RTRIM(b.Address1),'NA') AS address1,
ISNULL(RTRIM(b.City),'') + ' ' + ISNULL(RTRIM(b.State),'') + ' ' + ISNULL(RTRIM(b.Zip),'') AS address2
a.[Meeting End] AS [meetingend]
ON B.ClientID = A.[general/clientid]
ON R.Room_id = A.Room_id
ON D.Location_ID = R.Location_ID
ON E.EventID = A.[general/eventid]
WHERE R.[Location_ID] = 6