In one of our ACT Custom SSRS Reports, we are noticing that it is leaving the address field blank for certain constituents. (not all constituents.) When I dig a little deeper it seems to be leaving the address field blank for those constituents who were started on our web system (and therefore the address1 and address2 are attributed to web.)
Has anyone seen this type of behavior before and do you have any leads on how to fix it so that the report populates those address fields with the appropriate data?
Just a quick question, do the addresses created by the web site look the same as those created elsewhere. ie are they using the same address type, are they flagged as primary addresses etc
Assume your custom report is looking for a specific address and just checking that the addresses are set as Primary address as that is the easiest way to only bring back one address.
Mark
Thank you, Mark for the quick reply. It seems that the address is coming in as home address. Then the report is coded to pull:<Field Name="street1"> <DataField>street1</DataField> <rd:TypeName>System.String</rd:TypeName> </Field>
I'm not sure what I may be missing here. I appreciate your support! :o)
Can you check the sql for how this links to T_address or if it uses [dbo].[FT_GET_PRIMARY_ADDRESS] () instead
What we are trying to find is the criteria used by sql to include the addressOnce we know this we can then check an address created by the web to see what values it has for that criteria.Then we can work out if we need to fix how the web is storing addresses and/or tweak the sql to include them.