🤓 Xplan Hint: Client List - generating a report

Did you know you can customise your client search list and export the list into either PDF or CSV? Previously only the PDF version was available from this screen, but now you can export the data into...

xplan

luke.watson3

Advisely Contributor

5 months ago

Thanks Laura, Any ideas what report type and selections in Xport would need to be to extract this data?

laura.capozzi

Xplan Expert

5 months ago

Hi Luke,

I would try starting with a Tasks data source. Add the columns you need using this first, if there are other key details you need that you can't get from the Tasks data source such as Client Adviser, then you can also add the Entity (child of tasks) data source. Try to limit the number of data sources though as this can often cause issues when there are too many data sources.

Hopefully you can get most of what you need with just these two.

Once you have added your sources and columns, you can refine the threads and/or tasks to search through by clicking the cog icon (data source filters) next to the Tasks data source and completing the fields. This is where you can also set rolling dates (so you can restrict to the last 3 months or the like), and also limit the user groups to search within.

If there are any other hints and tips that anyone would like to share with Luke, please feel free to add to this thread. We would also love to hear about them.

Welcome to the Advisely forums!

This is where financial advice professionals from all walks of life come together to share knowledge, swap ideas, solve problems, and talk all things growth and efficiency.

Here are some tips when posting in the forums:

Be respectful and courteous to fellow members
If a reply helped you, mark it as a solution so other users can find it easily
Take a moment to read through our Community Guidelines
For Xplan support issues, it's best to raise a ticket in Iress Connect first. You can also search the discussions for posts about the same issue first before starting a new thread.
Keep an eye out for our 'Ask me anything (AMA)' threads – these are live text-based Q&As with industry and Xplan experts during a set period of time. Find out when the next one is happening here.
Don’t be shy! You don’t need to be an expert to help someone out. Many users are looking for practical advice, shared experiences, or just a fresh perspective
Introduce yourself and meet other members here!