slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Reporting & Notification Forums - Reporting
Forum to discuss reports for SalesLogix including Crystal, SQL Reports, etc. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to Reporting | New Thread

View: Search:

Author

Thread: Account Relationships - Recursive?

Antony Currington
Posts: 15

Account Relationships - Recursive? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 21 Aug 06 8:22 PM

Hi all,

I have to write a report that shows an Account, and all the child accounts (as defined by the ACCOUNT.PARENTID field), and then all the children of the children, etc, etc, etc.

Basically, there is no way to know how many levels deep I'll need to go.

The client also wants to see the Contacts for each account at each level... and yes, they need to be able to print it (which is why I need to use Crystal)

Any ideas how? I can't see any easy way to do it.

Anyone got one already written they'd like to share?

Antony

[Reply][Quote]

Mike Spragg
Posts: 1226

Re: Account Relationships - Recursive? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 22 Aug 06 4:27 AM

Antony

Crystal has a recursive function for this - it actually has a relationship type report as one of the samples. Open that and just follow that sample.

[Reply][Quote]

Antony Currington
Posts: 15

Re: Account Relationships - Recursive? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 24 Aug 06 6:17 PM

Quote:

Originally posted by Mike Spragg

Antony

Crystal has a recursive function for this - it actually has a relationship type report as one of the samples. Open that and just follow that sample.

Thanks Mike, that looks pretty close to what I want. Anyone know how to filter it to a specific starting point, so that I can specify the top level and show everything from there down?

Antony

[Reply][Quote]

Steve Margeson
Posts: 38

Re: Account Relationships - Recursive? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 25 Aug 06 6:50 AM

Antony,
While you are on the topic. I'm not sure if you have ran into this yet.

Just a heads up, the default Hierarchy view in SalesLogix can hang if it creates a loop. I had a case where at some point a user linked an account as its own parent or back to the original parent at some point creating a loop and it crashed.

To correct the problem I added a function to store a list of accountid's as it was building the hierarchy view and it checks to see if the account is already in the list before it continues and warns the user and exits the function if a duplicate is found.

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/25/2024 5:43:52 AM