Jim_Shelton Posted March 23, 2008 Share Posted March 23, 2008 All the fields of a report work off of date range for Order::Active field. For percentages like closing percentages of quotes I need to use date range of Order::QuoteDate. Can one script perform different finds with each find completing only specific fields? Jim Quote Link to comment Share on other sites More sharing options...
Jim_Shelton Posted March 23, 2008 Author Share Posted March 23, 2008 Maybe a better way to state the issue. In one report: I need Order::Quotes turned Active based upon date range for Order::Quotes = Active. I need Order::Quotes sent based upon same date range but for Order::Quote Date. Jim Quote Link to comment Share on other sites More sharing options...
Weetbicks Posted March 24, 2008 Share Posted March 24, 2008 just use 2 different scripts to run the 2 different reports? each doing a different find? Thats about all I can offer because its basically too hard to understand what it is you are wanting answered. Nobody knows anything about your database so you gotta write the question with that in mind. Quote Link to comment Share on other sites More sharing options...
Databasic Posted March 24, 2008 Share Posted March 24, 2008 Maybe a better way to state the issue. In one report: I need Order::Quotes turned Active based upon date range for Order::Quotes = Active. I need Order::Quotes sent based upon same date range but for Order::Quote Date. Jim So it would seem you need a found set of quotes sent between certain dates and a found set ( or count ? ) of active quotes based on the date they became active.. Are all the activated quotes included in the first date range of data or are there older quotes that become active within the selected quote date range ? Quote Link to comment Share on other sites More sharing options...
Jim_Shelton Posted March 26, 2008 Author Share Posted March 26, 2008 The activated quotes could be in the original found set of quotes sent in the designated date range, but they could have been sent at an earilier date. How would I run 2 scripts for a single report? I tried a temp report to pull part of the information in and it did now work well. Jim Quote Link to comment Share on other sites More sharing options...
Weetbicks Posted March 26, 2008 Share Posted March 26, 2008 Create a main script you run which might be along the lines of: if ( Condition 1 ) [ Perform Script [ This script is run for condition 1 ] else [ Perform Script [ This script is run for condition 2 ] End If Or run one script to do the reports, but at the part where it finds certain records, branch with an if/else statement to either perform one find or another. Quote Link to comment Share on other sites More sharing options...
Databasic Posted March 27, 2008 Share Posted March 27, 2008 Ok Jim If you conduct a find to locate all records with a quote date between X and Y OR an active date between X and Y - will that not give you the found set you are after ? ie all records with quote dates in the period and all those older quotes that became active during the same period. then use the report wizard to produce the report on that found set.. Cheers Quote Link to comment Share on other sites More sharing options...
Jim_Shelton Posted March 30, 2008 Author Share Posted March 30, 2008 Thanks for everyone's help. I have the report displaying the numbers for each. Jim Quote Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.