Combined GP Company Report

(0) Share

Report

Posted on by Ryan D McBee

I have a SQL Stored Procedure that generates data for one GP Company. Is there a way to pass a database through as a parameter to return a combined report? For example, how would I go about getting a combined AP Aging for three GP companies?

Any samples would be greatly appreciated.

Thanks!

Ryan

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Community Member on at

Like (0)

Report

Re: Re: Re: Combined GP Company Report

Ryan, please see the link in my post above which discusses about how to capture the results returned from a stored procedure. The idea is to capture the result set for each company into a temp table and then combine these temp tables via a SQL UNION.

I am cutting and pasting the sample script to save the results of a stored proc to a table:

INSERT INTO SomeTableThatMatchesTheSproc (...)
EXEC StoredProcedureName

SELECT * FROM SomeTableThatMatchesTheSproc

Was this reply helpful? Yes No
Ryan D McBee on at

Like (0)

Report

Re: Re: Combined GP Company Report

Thanks Victoria. I have followed your blogs before. This gets me what I need.

If I am to get a historical aging, is there a way to execute a stored proc on each db and have results returned?

Was this reply helpful? Yes No
Victoria Yudin 22,768 on at

Like (0)

Report

Re: Combined GP Company Report

Ryan,

If you know the names of the databases and companies upfront and are ok with hardcoding them, this is pretty straightforward. Here is an example of a multicompany view:

http://victoriayudin.com/2008/11/10/sql-view-for-crystal-reports-to-show-open-ap-invoices-from-multiple-companies-in-gp/

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Re: Combined GP Company Report

You can try to select from a stored procedure into a temp table for each of the companies. After that, assuming you have created the temp tables COMPANY1..temp, COMPANY2..temp, you can do a UNION ALL:

SELECT * FROM COMPANY1..temp

UNION ALL

SELECT * FROM COMPANY2..temp

....

Was this reply helpful? Yes No