Sign In/My Account | View Cart  

advertisement

AddThis Social Bookmark Button

Article:
  Using the SQL Server 2000 Reporting Services
Subject:   Mailing List and Formula Fields
Date:   2005-09-23 10:47:42
From:   TJWARD
How do I create a mailing list (3 columns) in Reporting Services Layout?
Which control should I use? (ie. table, list...)


Example Layout:



12345 48548 857455


South Washington Street Harrison Blvd NBA North Avenue


Yoyo, IL 65859 Washington, DC 58485 Shreveport, Tx 74854



Also, how or where would I go within Visual Studio for SRS to create Crystal Report like formula fields to be added into the report?


EXAMPLE:



if {Addresses.ADDR_State} = ""
then
{Addresses.ADDR_City} + " " + {Addresses.ADDR_Zip}
else
{Addresses.ADDR_City} +", " + {Addresses.ADDR_State} +" " + {Addresses.ADDR_Zip}



Thank you.