Hi,
So I almost have my company switched from Alpha4 to Alpha Anywhere v12 desktop, but I am getting stuck on printing reports. I would love to set up a print option screen similar to the one in Alpha4, because we print the same report with a different index, range, and/or filter, for numerous reasons around the office on a daily basis. I figured out how to make the print genie appear onPush on the start-up screen "print" button, but I can't figure out how to enter both a filter and a range into the genie at the same time.
For example: I want to run a metro report for publications we produce in a certain metro, that haven't been cancelled.
In Alpha4 I would select "print", "report", "metro report" (name of the report), primary index= Sort by Metro Area, State, City, Book Name (which are all different fields in the table), show all records (on the choice of all, deleted, or not deleted), type in the specific metro I am looking for into the "First record" "Last Record" prompts, and then filter the report for books without cancel dates.
In Alpha Anywhere through the genie it looks like I can either choose to use a filter/order, or a range, not both. I would set it up in each report to ask for those specific fields to create a built-in query, but I use that same report to look for data in other fields as a filter all the time.
Is there an easy way to set up a screen that will allow the user to specify both a filter and a range for a certain report? We have 70 different reports that we use, and I would love to avoid having to find out every single filter that each person uses, on each report, and have to build queries for each of those filters.
-Amanda
So I almost have my company switched from Alpha4 to Alpha Anywhere v12 desktop, but I am getting stuck on printing reports. I would love to set up a print option screen similar to the one in Alpha4, because we print the same report with a different index, range, and/or filter, for numerous reasons around the office on a daily basis. I figured out how to make the print genie appear onPush on the start-up screen "print" button, but I can't figure out how to enter both a filter and a range into the genie at the same time.
For example: I want to run a metro report for publications we produce in a certain metro, that haven't been cancelled.
In Alpha4 I would select "print", "report", "metro report" (name of the report), primary index= Sort by Metro Area, State, City, Book Name (which are all different fields in the table), show all records (on the choice of all, deleted, or not deleted), type in the specific metro I am looking for into the "First record" "Last Record" prompts, and then filter the report for books without cancel dates.
In Alpha Anywhere through the genie it looks like I can either choose to use a filter/order, or a range, not both. I would set it up in each report to ask for those specific fields to create a built-in query, but I use that same report to look for data in other fields as a filter all the time.
Is there an easy way to set up a screen that will allow the user to specify both a filter and a range for a certain report? We have 70 different reports that we use, and I would love to avoid having to find out every single filter that each person uses, on each report, and have to build queries for each of those filters.
-Amanda
Comment