SAVING MULTIPLE QUERYS

We welcome your comments, suggestions and feedback for future R&R releasees.
Post Reply
Arnold_M._Rosenbaum__(Guest)
Posts: 13
Joined: Tue Oct 10, 2017 12:44 pm

SAVING MULTIPLE QUERYS

Post by Arnold_M._Rosenbaum__(Guest) » Thu Mar 29, 2001 10:02 am

I WOULD LIKE TO SEE THE PROGRAM ALLOW FOR DIFFERENT QUERY^S WHICH CAN BE SAVED INTO ONE REPORT.____CURENTLY IF OYU HAVE THE DIFFERENT QUERYS YOU HAVE TO SAVE THE REPORT UNDER A DIFFERENT NAME

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: SAVING MULTIPLE QUERYS

Post by kfleming » Thu Mar 29, 2001 10:19 am

There is a way that you can accomplish conditional queries.____First create a FLAG field. In Version 9 you can make this flag field a parameteRR field so that you will be prompted to select its value when you run the report.____Then in your query expression, you would use a combination of clauses.____For example if Query 1 is CUSTNO=123__and Query 2 is ORDATE>01/01/2001____your saved query would be:____(FLAG=^C^ and CUSTNO=123)__OR (FLAG=^D^and ORDDATE >01/01/2001)____so if FLAG is set to C you get query 1 and if it is set to D you get query 2.____And Version 9 can prompt you to enter either C or D so you can get two reports for the price of one.____Regards,__Kathleen__R&R Support____

Post Reply