A Social Network for PeopleSoft Professionals

Using Multiple Queries/XML in XML publisher reports

What is the best way to go about creating a report when you want data from multiple queries/multiple XML

As of now I am only able to load a single XML which gets the data from a single query.

Thanks

Tags: PeopleSoft, Publisher, Query, Reporting, Reports, XML

0 members like this

▶ Reply to This

Replies to This Discussion

Permalink Reply by PSoftPros on April 15, 2009 at 8:51pm

If you want data from multiple queries, you will have to create an application engine program. I do not know of a way to do this in Query.

▶ Reply

Permalink Reply by Michael King on May 13, 2009 at 11:37pm

You are stuck with a single query.

If you are a "functional" and the techies won't let you at this thing called app engine, you might think it cannot be done.

If your only tool is PS Query - there is a way around this.
(If you are a hammer, everything looks like a nail.)

Do you know how to do a UNION in PS Query?
Do you know how to do an EXPRESSION in PS Query?

That is how I solve the problem.

Use EXPRESSIONS where the two queries don't mesh and put in blanks.

Example:
Query 1 returns:

Query 2 returns:

What you need to do using expressions (BLANK EXPRESSIONS) and a union is to combine the 2 queries into one that returns:

This works.

Only problem I have had is if the two queries together take too long and time out - then I have to schedule the XML report to get it to complete.