Good Afternoon,
I good really use some help. I am using CR XI and am pulling data using SQL Server 2005.
I am creating a report from two SQL tables that have no common fields and no way to add one to link them together. That being said:
Table1 has street names and address descriptions for every address in the city.
Table2 has meter addresses that can have a street_name, a cross_st_nm or both. The kicker is that these fields are only the first five letters of the street name.
My report is trying to show all the meter information from table2 where the street names do not match from table1.
I created a formula called @LEFT_5_ST_NM, to give me the first 5 letters of the street names from table1.
What I need to get is:
either:
tbl2.street_name not in @LEFT_5_ST_NM
and/or
tbl2.cross_st_nm not in @LEFT_5_ST_NM
Grouped by Atlas_pg, meter_nbr.
Displayed like so:
ATLAS_PG METER_NBR STREET_NM CROSS_ST
a-10-1 1 Sccot Howar
k-12-5 2356 Wshin Linkn
w-5-4 12456 Phili Ntion
Because the following did not match @LEFT_5_ST_NM or
left(tbl1.street_name,5):
Sccot s/b Scott; Wshin s/b Washi; Ntion s/b Natio.
Please advise as I have been at this way too long, THX.
I good really use some help. I am using CR XI and am pulling data using SQL Server 2005.
I am creating a report from two SQL tables that have no common fields and no way to add one to link them together. That being said:
Table1 has street names and address descriptions for every address in the city.
Table2 has meter addresses that can have a street_name, a cross_st_nm or both. The kicker is that these fields are only the first five letters of the street name.
My report is trying to show all the meter information from table2 where the street names do not match from table1.
I created a formula called @LEFT_5_ST_NM, to give me the first 5 letters of the street names from table1.
What I need to get is:
either:
tbl2.street_name not in @LEFT_5_ST_NM
and/or
tbl2.cross_st_nm not in @LEFT_5_ST_NM
Grouped by Atlas_pg, meter_nbr.
Displayed like so:
ATLAS_PG METER_NBR STREET_NM CROSS_ST
a-10-1 1 Sccot Howar
k-12-5 2356 Wshin Linkn
w-5-4 12456 Phili Ntion
Because the following did not match @LEFT_5_ST_NM or
left(tbl1.street_name,5):
Sccot s/b Scott; Wshin s/b Washi; Ntion s/b Natio.
Please advise as I have been at this way too long, THX.