Combining multiple queries into one report

I would like allow the generation of a report that contains three separate queries but the results appear like a sectionalized report. I would like the cooridinator of each group to be able to click on one query and the results would be as follows: A) New documents added yesterday that pertain to that group

Documents that were deleted or cancelled yesterday that pertain to that group C) A list of all active documents that pertain to that group.I can generate the reports individually fine by queries of the various attributes. What I have not been able to come up with is a solution on how all three separate queries appear in one report. Any suggestions or ideas greatly appreciated.

Find more posts tagged with

Comments

eLink User

Message from Hans Stoop via eLinkIf you are using an Oracle database you can use the UNION statement tocombine to selects.Hans Stoop--------------Consultant Partner Programs Europehstoop@opentext.com+31 23 5652333http://www.opentext.com/Register for LiveLinkUp 2000 TodayOctober 28-31, 2000http://www.opentext.com/livelinkup> -----Original Message-----> From: eLink Discussion: Development Discussion> [mailto:development@elinkkc.opentext.com]> Sent: donderdag 24 augustus 2000 16:13> To: eLink Recipient> Subject: Combining multiple queries into one report>>> Combining multiple queries into one report> Posted by lldevteam on 08/24/2000 10:12 AM>> I would like allow the generation of a report that contains> three separate queries but the results appear like a> sectionalized report.>> I would like the cooridinator of each group to be able to> click on one query and the results would be as follows:>> A) New documents added yesterday that pertain to that group>

Documents that were deleted or cancelled yesterday> that pertain to that group> C) A list of all active documents that pertain to that group.>>> I can generate the reports individually fine by queries of> the various attributes. What I have not been able to come> up with is a solution on how all three separate queries> appear in one report. Any suggestions or ideas greatly appreciated.>>> [To reply to this thread, use your normal e-mail reply function.]>> ============================================================>> Discussion: Development Discussion> https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=786303&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe

Brian_Rourk_(rourk_-_(deleted))

We are using MS SQL

eLink User

Message from Hans Stoop via eLinkI don't know that much abour MS SQL. But I'm told that you don't havea UNION for MS SQL.The only other thing you can try is creating a stored procedure thatruns the 3 queries and gives back the combined result. WithinLiveReport you call the stored procedure with a select statement.Hans Stoop--------------Consultant Partner Programs Europehstoop@opentext.com+31 23 5652333http://www.opentext.com/Register for LiveLinkUp 2000 TodayOctober 28-31, 2000http://www.opentext.com/livelinkup> -----Original Message-----> From: eLink Discussion: Development Discussion> [mailto:development@elinkkc.opentext.com]> Sent: donderdag 24 augustus 2000 22:03> To: eLink Recipient> Subject: RE- RE- Combining multiple queries into one report>>> RE- RE- Combining multiple queries into one report> Posted by lldevteam on 08/24/2000 03:59 PM>> We are using MS SQL>> [To reply to this thread, use your normal e-mail reply function.]>> ============================================================>> Topic: Combining multiple queries into one report> https://knowledge.opentext.com/knowledge/livelink.exe?func=l> l&objId=2329835&objAction=view>> Discussion: Development Discussion> https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=786303&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe

eLink User

Message from Dylan Wright via eLinkUNION works in SQL server too> -----Original Message-----> From: eLink Discussion: Development Discussion> [mailto:development@elinkkc.opentext.com]> Sent: Thursday, August 24, 2000 11:08 PM> To: eLink Recipient> Subject: RE- RE- RE- Combining multiple queries into one report>>> RE- RE- RE- Combining multiple queries into one report> Posted by eLink on 08/25/2000 02:07 AM>> Message from Hans Stoop via eLink>>> I don't know that much abour MS SQL. But I'm told that you don't have> a UNION for MS SQL.> The only other thing you can try is creating a stored procedure that> runs the 3 queries and gives back the combined result. Within> LiveReport you call the stored procedure with a select statement.>>> Hans Stoop>> --------------> Consultant Partner Programs Europe> hstoop@opentext.com> +31 23 5652333> http://www.opentext.com/> Register for LiveLinkUp 2000 Today> October 28-31, 2000> http://www.opentext.com/livelinkup>> > -----Original Message-----> > From: eLink Discussion: Development Discussion> > [mailto:development@elinkkc.opentext.com]> > Sent: donderdag 24 augustus 2000 22:03> > To: eLink Recipient> > Subject: RE- RE- Combining multiple queries into one report> >> >> > RE- RE- Combining multiple queries into one report> > Posted by lldevteam on 08/24/2000 03:59 PM> >> > We are using MS SQL> >> > [To reply to this thread, use your normal e-mail reply function.]> >> > ============================================================> >> > Topic: Combining multiple queries into one report> > https://knowledge.opentext.com/knowledge/livelink.exe?func=l> > l&objId=2329835&objAction=view> >> > Discussion: Development Discussion> > https://knowledge.opentext.com/knowledge/livelink.exe?func=l> l&objId=786303&objAction=view>> Livelink Server:> https://knowledge.opentext.com/knowledge/livelink.exe>> [To reply to this thread, use your normal e-mail reply function.]>> ============================================================>> Topic: Combining multiple queries into one report> https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2329835&objAction=viewDiscussion: Development Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=786303&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe

Sun_Livelink_Admin_(sunmic01admin_-_(deleted))

Any suggestion or advise will be greatly appreciated. yc