For example:

The Sample Detailed Report Template has the city, state and postal code combined to display in one field so that regardless on the length of a city name, the space between city, state and postal is always even.

But in some instances you may find that nothing shows - even though you have checked that the client actually does have a physcial address entered in the client entry screen.

The reason may be due to the script used to display this "combined" city, state and address field is not identifying the band where the field is - resulting in a miscommunication of where to get the data from.

1. Open up the report template in the report designer

2. Click on the field that is using the combined script - in the screen shot example below, this field actually has the property Text set to "combined address field" and is label xrLabel11

3. Now expand the property Scripts

4. Click on the OnBeforePrint property to open the Script Editor for the OnBeforePrint script

5. Take a look - is the band name stated before every instance of GetCurrentColumnValue?

For example, in the screen shot below, the field xrLabel11 is located in the DetailReport band - therefore in the script text, DetailReport. must be identfied before the GetCurrentColumnValue, so your script would look like this:

private void OnBeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e)
{
xrLabel11.Text = string.Format("{0} , {1}  {2}", DetailReport.GetCurrentColumnValue("LT_Address_Label_City"), DetailReport.GetCurrentColumnValue("LT_Address_Label_StateProv"), DetailReport.GetCurrentColumnValue("LT_Address_Label_Postal"));
}

AyaNova Sales & Technical Support

http://www.ayanova.com