Any help on this one???
Thanks
9 answers
In the database, the BillingAddress is just 1 field. The 'Address1, 2, and 3 fields are special 'report-only' fields available in the standard report types. (Just like the CloseDate 2 field on Opps reports). Can we remove access for a particular profile for 'Address1, 2, and 3 fields which are available in the standard report types? Do we have any documentation for these fields?
You would have to create custom text fields and parsing apart the BillingAddress into pieces using an Apex trigger. Here is a Developer Community post on the topic: http://salesforce.stackexchange.com/questions/18909/find-line-break-in-formula-field yes - I can see those fields - but I need to break the Billing address into Billing Address 1, Billing address 2, Billing address 3. On the standard reports, these address fields are available, but on the custom report types, you only have the "Billing Address" as one field, and the breakdown options are not showing.
You mean to say above fields you are not able to see if you are creating a custom report type on account .Hi Ashish - thanks for the reply. When I create a custom report, I still cannot see the address breakdown in the standard objects such as account & contact, as this is where I am building the report from If we use standard object like Account , we would be able to see fields like billing and shipping address , though its not possible in custom object as we would be using single field.
Would suggest to create separate fields like Billing address or mailing address and use it in custom reports
